Histogram and frequency analysis in Excel - Cell-by-Cell Formula Trace

Sample Data

This data shows student test scores in column A and bin limits in column B for grouping scores.

Cell	Value
A1	Scores
A2	55
A3	67
A4	45
A5	70
A6	89
A7	90
A8	72
A9	60
A10	85
B1	Bins
B2	50
B3	60
B4	70
B5	80
B6	90
C1	Frequency

Formula Trace

=FREQUENCY(A2:A10, B2:B6)

Step 1: A2:A10

Step 2: B2:B6

Step 3: FREQUENCY([55,67,45,70,89,90,72,60,85], [50,60,70,80,90])

Cell Reference Map

1

↓

2

↓

3

↓

4

↓

5

The formula uses scores from A2:A10 and bins from B2:B6 to calculate frequency counts.

Result

    A      B      C
1 Scores  Bins  Frequency
2  55     50      1
3  67     60      2
4  45     70      2
5  70     80      1
6  89     90      2
7  90             1
8  72
9  60
10 85

Column C shows how many scores fall into each bin range defined in column B.

Sheet Trace Quiz - 3 Questions

How many scores are less than or equal to 50?

A 0

B 2

C 1

D 3

Key Result

FREQUENCY(data_array, bins_array) returns counts of values in data_array grouped by bins_array limits.