FREQUENCY

Syntax:

FREQUENCY ( data-array , bins-array )

Description: Calculates how often values occur within a range of values. A call to FREQUENCY shall be entered as an array formula.

Arguments:

Name	Type	Description
data-array	array, reference to number	Set of values for which frequencies are to be computed. If data-array contains no values, `FREQUENCY` returns an array of zeros. Cells containing text or that are empty are ignored.
bins-array	array, reference	Set of intervals into which the values in data-array are to be grouped. If bins-array contains no values, `FREQUENCY` returns the number of elements in data-array.

Return Type and Value: vertical array of numbers – The frequency at which values occur within a range of values. The number of elements in the returned array is one more than the number of elements in bins-array. The extra element contains the count of any values above the highest interval.

example: