FREQUENCY function

FREQUENCY indicates the frequency distribution in a set of values.

Syntax

FREQUENCY (NumberSequenceList_data,NumberSequenceList_bins)

Example

In the following table, column A lists unsorted measurement values. Column B contains the intervals you entered for the classes into which you want to divide the data in column A. According to the interval entered in B1, the FREQUENCY function returns the number of measured values less than or equal to 5. As the limit in B2 is 10, the FREQUENCY function returns the second result as the number of measured values that are greater than 5 and less than or equal to 10. The text you entered in B6, >25, is for reference purposes only.

Table 1. FREQUENCY function example
  A B C
1 12 5 1
2 8 10 3
3 24 15 2
4 11 20 2
5 5 25 1
6 20 >25 1
7 16    
8 9    
9 7    
10 16    
11 33    

Use a single column range in which to enter the frequency function according to the class limits. You must enter the function in one field more than the class ceiling. In this example, use the range C1:C6. Enter the function {=FREQUENCY(A1:A11,B1:B5)} in each cell in the range. You will see the frequency count results as above in C1:C5.




Trademarks | IBM Connections wiki