Calculates the frequency distribution (how often some values occur) of a one-column array into specified classes.
Sample Usage
FREQUENCY({1,2,3,4},{2,4})
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.
Examples
FREQUENCY({1,2,3,4},{2,4}) calculates the frequency of the data according to the classes specified. In this case, counts the number of values up to 2, between 2 and 4, and greater than 4, with the function returning 2,2,0.
FREQUENCY(A2:A40,B2:B5) calculates the frequency of the data according to the classes specified in B2:B5.
Notes
- If data contains no values, FREQUENCY returns a list of zeros.
- The output of FREQUENCY will be a list of size one greater than classes as the final value is the number of elements in data greater than any of the class boundaries.
- The number of elements in the returned list is one more than the number of elements in classes. The extra element is the count of any values above the highest interval.
- FREQUENCY ignores blank cells and text.