Array Functions
Advanced
FREQUENCY Function
Create a frequency distribution of data values.
Task:
Count how many test scores fall into each grade range (0-59, 60-69, 70-79, 80-89, 90-100).
Learning Objectives:
- Learn FREQUENCY function
- Understand frequency distributions
- Practice data binning
Hints
Solve without hints for +5 XP
The data in this exercise
This is the grid you start with. Cell references in the task — B6, C2 — point at the row numbers and column letters below.
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Scores | Bins | Frequency | ||
| 2 | 75 | 70 | |||
| 3 | 82 | 80 | |||
| 4 | 90 | 90 | |||
| 5 | 68 | ||||
| 6 | 78 | ||||
| 7 | 85 | ||||
| 8 | 92 | ||||
| 9 | 70 | ||||
| 10 | 88 |
What this exercise teaches (contains the answer)
FREQUENCY counts how many values fall into specified ranges (bins). It's useful for creating histograms and understanding data distribution.