FREQUENCY function

FREQUENCY(Values, Intervals) FREQUENCY(Values; Intervals)

Values

{ Number }

The values whose frequency in the given intervals should be returned.

Intervals

{ Number }

The intervals to group the given values into.

Returns

{ Number }

The frequency distribution of the values of the first array when grouped into the intervals of the second array.

Returns the frequency distribution of the values of the first array when grouped into the intervals of the second array.

Example

FREQUENCY({ 1, 2, 3, 4, 5, 9, 10, 16 }, { 5, 10, 15 })FREQUENCY({ 1; 2; 3; 4; 5; 9; 10; 16 }; { 5; 10; 15 })

Returns the array { 5, 2, 0, 1 }{ 5; 2; 0; 1 }, because the interval ending with 5 contains the five values 1, 2, 3, 4 and 5. The next interval, ending with 10, contains the two values 9 and 10. The next interval, ending with 15, contains no values. The implicit final interval contains one value, 16.