← VCE Spreadsheets, SQL & Visualisation

Histograms

A chart with touching columns showing how many values fall in each numeric bin. Bins go on the x axis, frequency on the y axis. It shows the shape of the data, unlike a bar chart of categories.

Part of: VCE Applied Computing - U1O1 - Data analysis — Module 64, VCE Data Analytics - U3O1 - Data Analytics — Module 93, VCE Data Analytics - U4O1 - Development and Evaluation — Module 31

Understanding Histograms in VCE Spreadsheets, SQL & Visualisation

What it does: Bins are ranges of numbers placed along the x axis. Each range gets one column. Bins are on the x axis. The frequency, or count, goes on the y axis. The height of each column shows the frequency, which is the number of values in that bin. Test scores are numeric data, so grouping them into bins in a histogram shows the shape of the spread.

Common mistakes: A histogram's x axis shows numeric bins, such as score ranges, not names or categories. It should be 'X axis: score bins'. Histogram columns touch because the bins run on from one another along a number line. The line should say there is no gap between columns.

Class: _____________________  ·  Name: _____________________  ·  Date: _________

Free printable worksheet with full answer key — or add this module to a class and your students practise it interactively.

🖨 Print worksheet + answer key Add Histograms to a class →

This module's key terms are also in a printable crossword (Modules 55–70) and word search (Modules 55–86).

Take this worksheet further — free with Cloodit

Each concept is reinforced from every angle — learned, then applied, then tested.

Learning
Duo
Which chart uses touching columns to show how many values fall in each numeric bin?
HistogramPie chart
Matches
Histogram with gaps between columns, x axis: Cat, Dog, Fish
↓
Categories like Cat, Dog and Fish belong on a bar chart. A histogram uses numeric bins on the x axis and its columns touch.
Applying
Meanings
Term
histogram
Meaning
A chart with touching columns showing how many values fall in each numeric bin. Bins go on the x axis, frequency on the y axis. It shows the shape of the data, unlike a bar chart of categories.
Practice
=COUNTIFS(B2:B30,">=50",B2:B30,"<60")
Testing
Gaps
=(B2:B30,">=50",B2:B30,"<60")
Check Answer
Spots
1Chart type: Histogram
2X axis: student names

Cloodit turns curriculum-aligned coding content into journeys students work through one biome at a time.

The 'Deer' badge — Forest Streak, one of Cloodit's 106 collectible badges
Students earn collectable badges

Over 100 of them, across seven natural biomes.

Study Buddy
Students build a real study resource

Turns their work into revision material ready for Flash Cards and Exam study.

Diamond Dash — one of Cloodit's live, competitive Sprint games
Students lock in with Sprints

Live, competitive practice for the start of the lesson or a teacher-led lesson finisher.

A Cloodit certificate of achievement, ready to personalise and print
Custom printable certificates

Honour your top performers, or encourage a student who's trying hard — ready to print in seconds.

Add to class →

Quick Questions

1. Which chart uses touching columns to show how many values fall in each numeric bin?
A. Histogram ✓
B. Pie chart
A histogram groups numbers into bins and shows the frequency of each bin with columns that touch, so you can see the shape of the data.
2. What goes on the x axis of a histogram?
A. Frequency (how many values)
B. Bins (number ranges like 0-9, 10-19) ✓
Bins are on the x axis. The frequency, or count, goes on the y axis.
3. What goes on the y axis of a histogram?
A. Frequency (how many values fall in each bin) ✓
B. The name of each category
The height of each column shows the frequency, which is the number of values in that bin.
4. A teacher wants to show how a class's test scores (0-100) are spread out. Which chart is the better choice?
A. Pie chart with one slice per student
B. Histogram with bins like 0-19, 20-39, 40-59 ✓
Test scores are numeric data, so grouping them into bins in a histogram shows the shape of the spread.
5. In a histogram, the columns touch each other. Why?
A. The bins are continuous number ranges with no gaps between them ✓
B. The columns are just drawn too wide by mistake
Touching columns show that the bins follow on from each other along a number line. A bar chart of categories has gaps because the categories are separate.

Match the Pairs

histogram → A chart with touching columns showing how many values fall in each numeric bin, so you can see the shape of the data
=COUNTIFS(B2:B30,">=50",B2:B30,"<60") → Counts how many marks fall in the 50 to 59 bin, giving the frequency for one histogram column
The x axis of a histogram shows numeric bins, which are ranges of values → Bins: 0-9, 10-19, 20-29, 30-39
The y axis of a histogram shows frequency, the count of values in each bin → Frequency: 3, 8, 12, 5
Histogram with gaps between columns, x axis: Cat, Dog, Fish → Categories like Cat, Dog and Fish belong on a bar chart. A histogram uses numeric bins on the x axis and its columns touch.
Histogram y axis: student names → The y axis of a histogram should show frequency (a count), not names of individual items.

Key Term

histogram
A chart with touching columns showing how many values fall in each numeric bin. Bins go on the x axis, frequency on the y axis. It shows the shape of the data, unlike a bar chart of categories.

Fill in the Blanks

1. =COUNTIFS(B2:B30,">=50",B2:B30,"<60")
Hint: Type the function that counts values meeting two criteria, used to find the frequency for one bin.
2. X axis: score bins Y axis: frequency
Hint: Type the word for how many values fall in each bin, shown on the vertical axis.
3. X axis: bins (50-59, 60-69, 70-79)
Hint: Type the word for the numeric ranges along the horizontal axis of a histogram.
4. =COUNTIFS(B2:B30,">=60",B2:B30,"<70")
Hint: Type the comparison operator that keeps the upper limit out of this bin, so it counts in the next bin.
5. Histogram: numeric bins, columns touch Bar chart: categories, columns have gaps
Hint: Type the verb that describes how histogram columns sit next to each other.

Spot the Error

Question 1
A Chart type: Histogram
B X axis: student names
C Y axis: frequency
D Columns touch: yes
Line B — A histogram's x axis shows numeric bins, such as score ranges, not names or categories. It should be 'X axis: score bins'.
Question 2
A Bins: 0-9, 10-19, 20-29
B Data: test scores
C Chart type: Histogram
D Gap between columns: wide
Line D — Histogram columns touch because the bins run on from one another along a number line. The line should say there is no gap between columns.
Question 3
A A1: Bin
B B1: Frequency
C B2: =SUMIF(D:D,"<10")
D Chart: Histogram of B2:B6
Line C — Frequency is how many values fall in a bin, so it needs COUNTIF. SUMIF adds up the values instead of counting them.
Question 4
A Chart type: Pie chart
B Data: ages 10 to 60
C Bins: 10-19, 20-29, 30-39
Line A — Numeric ages grouped into bins on an axis are shown with a histogram, not a pie chart. The line should be 'Chart type: Histogram'.
Question 5
A Bin 0-9: 2 students
B Bin 10-19: 5 students
C Bin 15-29: 9 students
D Bins do not overlap
Line C — Bins must not overlap, and 15-29 overlaps with 10-19. The bin should be 20-29 so each value falls in exactly one bin.

Student with a class code? Join your class →