On Sun, 04 Sep 2005 14:18:41 +1200, Ian Laurenson 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
Ian, that was a great walk-through. Sorry, my sig wasn't working before - I'm on OOo v. 1.0.4 under Windows XP. The problem I have in general with Calc is that, though I know it is powerful, I continually find its advanced features inaccessible. The Help file, the manual, simply do not enable me to understand how to proceed. Maybe it's me, but my experience is that they tell you what you already did, if you knew enough to do it in the first place. I find it very frustrating and wish I knew of another help source. Thanks for your great input. Paul -- Using OOo 1.9.104 on Win XP sp2. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
