FREQUENCY(DataArray, BinArray)
- Where is an 'array of values' or 'reference to set of values' from which frequency of values is to be counted, and
- is an array or a reference to intervals in which values can be grouped.
FREQUENCY() calculates the number of occurrences within a range of values, and then returns a vertical array of numbers.
Description
FREQUENCY(DataArray, BinArray)
- is an input array from which frequency of values is to be calculated.
- If does not contain values, it returns array of zeros.
- is an array of intervals in which input values are to be grouped.
- If has no values, Calci returns the number of values in DataArray.
- Blank cells are considered as zero value.
- Text values are ignored.
Examples
Below table shows the use of FREQUENCY function:
| 5 | 10 | |
| 20 | 30 | |
| 15.5 | 50 | |
| 21 | ||
| 0.3 | ||
| 45 | ||
| 38 | ||
| -2 |
=FREQUENCY(A1:A8,B1:B3) : Returns the frequencies as 3(for values < 10), 3(for values between 10 and 30), </ br>2(for values between 30 and 50), 0(for values > 50). </ br>Displays 3 3 2 0 as a result. =FREQUENCY(A1:A9,B1:B3) : Returns the frequencies as 4(for values < 10, A9 is considered '0'), 3(for values between 10 and 30), </ br>2(for values between 30 and 50), 0(for values > 50). </ br>Displays 4 3 2 0 as a result.