Here is a DataPilot mini-tutorial: http://www.openofficetips.com/blog/archives/2004/09/datapilot_101.html ( 1.1.x)
Another... http://www.openofficetips.com/blog/archives/2005/08/datapilot_revis.html ( 1.9.x) Another.. http://www.openofficetips.com/blog/archives/2005/08/datapilot_revis_1.html ( 1.9.x) Any feedback on how these can be improved/ expanded much appreciated... Dave On 9/3/05, Ian Laurenson <[EMAIL PROTECTED]> wrote: > > On Sat, 2005-09-03 at 19:53 -0400, Paul_B wrote: > [snip] > > I figured out how to do a frequency distribution, using the > > FREQUENCY function. I'd still like to know more about Data Pilot > > if possible. > > Which version of OpenOffice.org are you using? > > In 1.1.4 you would need to create a column with a formula for creating > your bin ranges (E.g. if numbers between 0 and 1 and want to group on > every 0.1 a suitable formula would be =int(a1*10) ). > > A Data Pilot is called a Pivot Table in Excel, or Cross Tab in some > other packages. > > The idea is to quickly summarise data using the standard statistical > functions (count, average, ...) > > I have always found it easier to show what it does rather than explain. > > Requirements for the data: > * Organised in columns > * Top row is the "field" name for the column > * No blank rows > > Steps: > Position the cursor in the data to be summarised > Data > DataPilot > Start > Current selection > OK > > Drag a field into the row area > (For doing frequency) drag the same field into the Data area > Double click on the field in the data area and choose Count > OK > Click More >> to choose where the resulting table will go (by default it > will go below the data). > Click OK > > In 1.9.x (I'm not sure which version this was introduced but certainly > works in the current beta): > In the newly created data pilot select a cell in the "Row" area (I.e. > first column) > Data > Outline > Group > Automatic start chooses the minimum value, typically choose manual and > type in your own start value. > Similarly for end (except maximum). > Type in the bin size in the Group by field. > > Hope that helps. > > Thanks, Ian > > OpenOffice.org Conference (OOoCon 2005) > September 28th - 30th 2005, Koper-Capodistria, Slovenia > http://marketing.openoffice.org/ooocon2005/index.html > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > -- My OpenOffice Calc Website http://www.openofficetips.com
