FREQUENCY
Returns a frequency distribution as a vertical array.
StatisticalStatistics & Analysis
What it does
Calculates how often values occur within a range of values (bins).
Syntax
FREQUENCY(data_array, bins_array)
Arguments
data_array(range) — Data values.bins_array(range) — Intervals to group into.
Examples
Count Scores
Group scores into bins (0-50, 51-80, >80).
FORMULA
=FREQUENCY(A2:A6, B2:B3)
RESULT
[1; 3; 1]
SAMPLE DATA
| A | B | |
|---|---|---|
| 1 | Scores | Bins |
| 2 | 45 | 50 |
| 3 | 75 | 80 |
| 4 | 60 | |
| 5 | 90 | |
| 6 | 70 |