Manuals/calci/FREQUENCY
Jump to navigation
Jump to search
FREQUENCY(d_arr,b_arr)
d_arr is an array of or reference to a set of values to count frequencies and b_arr is an array of or reference to intervals to group the values in d_arr.
FREQUENCY
Syntax
Examples
Description
i.e. =FREQUENCY (C1R1:C1R9, C2R1:C2R3) is 1,2,4,2
It is used to calculates how often values occur within a range of values, and then returns a vertical array of numbers.
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | 69 | 60 | 1,2,4,2 | |
| Row2 | 75 | 69 | ||
| Row3 | 68 | 79 | ||
| Row4 | 75 | |||
| Row5 | 40 | |||
| Row6 | 71 | |||
| Row7 | 85 | |||
| Row8 | 78 | |||
| Row9 | 87 |
