FREQUENCY indicates the frequency distribution in a set of values.

FREQUENCY (`NumberSequenceList_data`,`NumberSequenceList_bins`)

`NumberSequenceList_data`represents the set of values to be counted.`NumberSequenceList_bins`represents the intervals into which you want to divide the data

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.

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.