« Conditional Formatting III | Main | Data Consolidation 101 »
March 17, 2005
Basic Functions: FREQUENCY
The following tips will show how the FREQUENCY function can be used in conjunction with the charting capabilities of OpenOffice Calc to create frequency plots of data.
In the example below, our data is in B4:D20. We wish to plot the frequency of occurence of the numbers listed in B26:B31.
The corresponding frequency tabe C26:C31 is created with the array function
{=FREQUENCY(INT(B4:D20);B26:B30)}
For some reason (OOo Calc bug?), you need to specify B26:B30 rather than B26:B31 - but it seems to work as entered here.
The corresponding frequency tabe C26:C31 is created with the array function
{=FREQUENCY(INT(B4:D20);B26:B30)}
For some reason (OOo Calc bug?), you need to specify B26:B30 rather than B26:B31 - but it seems to work as entered here.
Posted by Dave at March 17, 2005 05:53 AM
Comments
Kind of implied here, but the classes list always should be sorted.
-2 cents
Posted by: murf at April 12, 2005 12:35 AM