Histograms

Tip: Choose Save as PDF in the print dialog to download. Use A4 paper size.

Histograms

Name:
Date:
Class:
A

Quick Questions

Shade in the A or B circle for each question.

1. Which chart uses touching columns to show how many values fall in each numeric bin?
A Histogram
B Pie chart
2. What goes on the x axis of a histogram?
A Frequency (how many values)
B Bins (number ranges like 0-9, 10-19)
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
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
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
B

Match the Pairs

Draw a line connecting each item on the left to its match on the right.

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

Definitions

histogram
D

Fill in the Blanks

Complete each line of code by filling in the missing parts.

1.
=________(B2:B30,">=50",B2:B30,"<60")
2.
X axis: score bins Y axis: _________
3.
X axis: ____ (50-59, 60-69, 70-79)
4.
=COUNTIFS(B2:B30,">=60",B2:B30,"_70")
5.
Histogram: numeric bins, columns _____ Bar chart: categories, columns have gaps
E

Spot the Error

Shade in the letter of the line that contains an error.

Question 1
A Chart type: Histogram
B X axis: student names
C Y axis: frequency
D Columns touch: yes
Question 2
A Bins: 0-9, 10-19, 20-29
B Data: test scores
C Chart type: Histogram
D Gap between columns: wide
Question 3
A A1: Bin
B B1: Frequency
C B2: =SUMIF(D:D,"<10")
D Chart: Histogram of B2:B6
Question 4
A Chart type: Pie chart
B Data: ages 10 to 60
C Bins: 10-19, 20-29, 30-39
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

Answer Key

Histograms
Section A: Quick Questions
Q1
A — Histogram
Q2
B — Bins (number ranges like 0-9, 10-19)
Q3
A — Frequency (how many values fall in each bin)
Q4
B — Histogram with bins like 0-19, 20-39, 40-59
Q5
A — The bins are continuous number ranges with no gaps between them
Section B: Match the Pairs
Q1
histogram → A chart with touching columns showing how many values fall in each numeric bin, so you can see the shape of the data
Q2
=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
Q3
The x axis of a histogram shows numeric bins, which are ranges of values → Bins: 0-9, 10-19, 20-29, 30-39
Q4
The y axis of a histogram shows frequency, the count of values in each bin → Frequency: 3, 8, 12, 5
Q5
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.
Q6
Histogram y axis: student names → The y axis of a histogram should show frequency (a count), not names of individual items.
Section C: Definitions
Q1
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.
Section D: Fill in the Blanks
Q1
=COUNTIFS(B2:B30,">=50",B2:B30,"<60")
Q2
X axis: score bins Y axis: frequency
Q3
X axis: bins (50-59, 60-69, 70-79)
Q4
=COUNTIFS(B2:B30,">=60",B2:B30,"<70")
Q5
Histogram: numeric bins, columns touch Bar chart: categories, columns have gaps
Section E: Spot the Error
Q1
B — A histogram's x axis shows numeric bins, such as score ranges, not names or categories. It should be 'X axis: score bins'.
Q2
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.
Q3
C — Frequency is how many values fall in a bin, so it needs COUNTIF. SUMIF adds up the values instead of counting them.
Q4
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'.
Q5
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.