FREQUENCY (Values, Intervals) FREQUENCY (Values; Intervals)
Values
The values whose frequency in the given intervals should be returned.
Intervals
The intervals to group the given values into.
Returns
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.