Statistical
Frequency Distribution
Create a frequency distribution that counts how many data points fall into each defined range (bin). Perfect for creating histograms and understanding data distribution.
Excel Formula
=FREQUENCY(A2:A100, C2:C6)Step-by-Step Explanation
1
FREQUENCY counts values falling into specified ranges
2
A2:A100 is the data to analyze
3
C2:C6 are the bin boundaries (upper limits)
4
Returns an array of counts for each bin
5
Select output range → enter formula → Ctrl+Shift+Enter (legacy Excel)
Example
| Bin Upper Limit (C) | Count (D) |
|---|---|
| 60 | 3 |
| 70 | 7 |
| 80 | 12 |
| 90 | 8 |
| 100 | 5 |
Result: =FREQUENCY(A2:A100,C2:C6) → counts in each score range
Common Variations
COUNTIFS alternative
=COUNTIFS(A:A,">="&C2,A:A,"<"&C3)Manual bin counting
Percentage distribution
=FREQUENCY(A2:A100,C2:C6)/COUNT(A2:A100)*100As percentage of total
Need a Custom Version?
Use our AI generator to create a formula tailored to your specific data and requirements.
Try It with AI →