Cover lesson · Maths · Year 11 · Advanced

Comparing broadband speeds with box plots

DCF: Data and computational thinking → Data and information literacy

Name: Class: Date:

Cover teacher: you need no subject knowledge

What this practises: GCSE Mathematics and Numeracy (Double Award), Unit 3: Calculator-allowed, Higher tier statistics: constructing and interpreting cumulative frequency tables and diagrams, estimating the median and interquartile range (4.2.18), using box-and-whisker diagrams to compare distributions (4.2.19), and testing a hypothesis while taking account of the limitations of the data (4.1.2, 4.1.4, 4.2.23). This GCSE has no NEA: this is exam practice with invented data. Calculators are allowed.

Print: this sheet, one per pupil, and the stimulus sheet “Broadband speeds in Bryn Eira and Cwm Derwen”, one between two. Pupils need a calculator, a ruler and a sharp pencil. No computers are needed. The raw data are also in broadband-bryn-eira-cwm-derwen-speeds.csv if you are in a computer room, for the extension tasks only.

Run: 5 min Step 1, read the survey · 8 min Step 2, the cumulative frequency table · 12 min Step 3, drawing the curve · 8 min Step 4, reading the curve · 7 min Step 5, the box plot · 15 min Step 6, the conclusion, on their own and in silence. Total 55 minutes.

Collect: this sheet. The class teacher has the answer key (the worked example). Graph readings will vary a little from pupil to pupil; that is expected.

What you are doing

A community council surveyed broadband speeds in two villages to test a hypothesis. You will turn the Bryn Eira results into a cumulative frequency curve, estimate the median and quartiles, and draw a box plot next to the one for Cwm Derwen. Then you will decide whether the evidence supports the hypothesis, judge how reliable the survey is, and change the conclusion if the data show that you should.

Step 1: read the survey

Read all six sections of the stimulus sheet. Then answer:

(a) The hypothesis has two parts. Which statistic will you use to test “faster”, and which will you use to test “more consistent”?

(b) What percentage of homes in each village took part? Give your answers to 1 decimal place.

Step 2: cumulative frequency table for Bryn Eira

Use Table 1. Cumulative frequency is a running total: the number of homes with a speed up to and including each value.

Download speed, s (Mbps)Cumulative frequency
s ≤ 10
s ≤ 20
s ≤ 30
s ≤ 40
s ≤ 50
s ≤ 60
s ≤ 70
s ≤ 80

Step 3: draw the cumulative frequency curve

Plot each cumulative frequency at the upper end of its class: for example, the point for s ≤ 10 goes at 10 across. Also plot (0, 0). Join the points with a smooth curve.

0010102020303040405050606070708080Download speed, s (Mbps)Cumulative frequency (number of homes)

Step 4: read the curve

Draw your reading lines on the graph so a reader can see where each answer came from.

(a) Estimate the median, the lower quartile and the upper quartile for Bryn Eira. There are 80 homes, so read across from 40, 20 and 60. Then work out the interquartile range.

Lower quartileMedianUpper quartileInterquartile range

(b) Use your curve to estimate how many homes in Bryn Eira had a download speed of 15 Mbps or less. What percentage of the 80 homes is that?

(c) Use the tables to find the percentage of homes in each village that got a “superfast” speed (more than 30 Mbps), and the percentage that got 10 Mbps or less.

 More than 30 Mbps10 Mbps or less
Bryn Eira
Cwm Derwen

Step 5: draw the box plot

The Cwm Derwen box plot is drawn for you. Draw the Bryn Eira box plot below it, on the same scale. You need five values: the slowest home (2.8 Mbps), your lower quartile, median and upper quartile from Step 4, and the fastest home (76.4 Mbps).

01020304050607080Download speed (Mbps)Cwm DerwenBryn Eira: draw your box plot here

Step 6: the conclusion

(a) Compare the two villages. Write one sentence comparing an average and one sentence comparing a measure of spread. Give the figures, and say what they mean for the people who live there.

(b) Does the evidence support Councillor Bevan’s hypothesis? Justify your answer with figures.

(c) Test the resident’s claim: “Nobody in Bryn Eira gets a decent speed. We are all stuck below 30.” Use figures.

(d) Give three reasons why the survey results might not be reliable. For each one, say how the council could make the survey fairer.

 Why the results might not be reliableHow to make the survey fairer
1
2
3

(e) Look at Section 6 of the stimulus sheet. What happens to the difference between the villages if you only compare the cable tests? Rewrite the council’s conclusion, or the hypothesis, so that it matches all of the evidence.

Step by step

  1. 5 min Step 1: read the stimulus sheet and answer (a) and (b).
  2. 8 min Step 2: complete the cumulative frequency table.
  3. 12 min Step 3: plot the points and draw a smooth curve.
  4. 8 min Step 4: read the median, quartiles and percentages from the curve and the tables.
  5. 7 min Step 5: draw the Bryn Eira box plot.
  6. 15 min Step 6: write the conclusion on your own, in silence.

Success criteria

If you finish early