Calculates the frequency distribution of a one-column array into specified classes.

Sample Usage

FREQUENCY(A2:A40,B2:B5)

Syntax

FREQUENCY(data, classes)

  • data - The array or range containing the values to be counted.

  • classes - The array or range containing the set of classes.

    • classes should be sorted for clarity, but FREQUENCY will sort the values specified internally if they are not and return correct results.

Notes

  • The output of FREQUENCY will be a vertical range of size one greater than classes as the final value is the number of elements in data greater than any of the class boundaries.

Examples