# Documentation/Calc Functions/FREQUENCY

TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate

## Function name:

FREQUENCY

## Category:

Array

## Summary:

Indicates the frequency distribution in a one-column-array. The function counts the number of values in the **Data** array that are within the values given by the **Classes** array.

## Syntax:

FREQUENCY(**Data**; **Classes**)

## Returns:

## Arguments:

**Data** represents the reference to the values to be counted.

**Classes** represents the array of the limit values.

## Additional details:

You can find a general introduction to Array functions at the top of this page.

## Examples:

In the following table, column A lists unsorted measurement values. Column B contains the upper limit you entered for the classes into which you want to divide the data in column A. According to the limit 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 only for reference purposes.

A | B | C | |
---|---|---|---|

1 | 12 | 5 | 1 |

2 | 8 | 10 | 3 |

3 | 24 | 15 | 2 |

4 | 11 | 20 | 3 |

5 | 5 | 25 | 1 |

6 | 20 | >25 | 1 |

7 | 16 | ||

8 | 9 | ||

9 | 7 | ||

10 | 16 | ||

11 | 33 |

Select a single column range in which to enter the frequency according to the class limits. You must select one field more than the class ceiling. In this example, select the range C1:C6. Call up the FREQUENCY function in the *Function Wizard*. Select the **Data** range in (A1:A11), and then the **Classes** range in which you entered the class limits (B1:B6). Select the **Array** check box and click **OK.** You will see the frequency count in the range C1:C6.

More explanations on top of this page.