Worked example · Maths · Year 9 · Advanced

Interpreting Box Plots and Averages for Broadband Speeds in Wales

LNF: Numeracy → Using data skills → Interpreting data · DCF: Data and information literacy

What this is

A complete model response and answer key for the cover teacher and for marking. Headline answers: Cwm Hafod: Min = 6, Q1 = 10, Median = 18, Q3 = 26, Max = 310, Range = 304, IQR = 16, Mean = 37 Mbps. Trefelin: Min = 32, Q1 = 44, Median = 56, Q3 = 68, Max = 80, Range = 48, IQR = 24, Mean = 56 Mbps. Claims in Step 3: A = False / Misleading, B = True, C = True, D = True.

Step 1: Order the data and find the five-number summaries

(a) Cwm Hafod’s 15 speeds in ascending order (with 4th, 8th and 12th highlighted):
6, 8, 9, 10 (Q1), 12, 14, 15, 18 (Median), 20, 22, 24, 26 (Q3), 28, 33, 310.

Statistic (in Mbps) How to find it (for n = 15) Cwm Hafod (Mbps) Trefelin (Mbps)
Minimum 1st ordered value 6 32
Lower quartile (Q1) 4th ordered value 10 44
Median (Q2) 8th ordered value 18 56
Upper quartile (Q3) 12th ordered value 26 68
Maximum 15th ordered value 310 80
Range Maximum − Minimum 310 − 6 = 304 80 − 32 = 48
Interquartile range (IQR) Q3 − Q1 26 − 10 = 16 68 − 44 = 24
Mean Total of all 15 speeds ÷ 15 555 ÷ 15 = 37 840 ÷ 15 = 56

Orders all 15 values accurately before locating the 4th, 8th and 12th items, and computes the range, IQR and mean for both communities. Evidences criteria 1 and 2.

Step 2: Explain why the interquartile range is fairer than the range

(a) Range of the 14 Cwm Hafod homes without Hendre Farm: 33 − 6 = 27 Mbps.

(b) Why the IQR is fairer: Cwm Hafod’s full range of 304 Mbps (310 − 6) is inflated by a single outlier (Hendre Farm’s private 310 Mbps line), making Cwm Hafod look far more variable than Trefelin (range 48 Mbps) when 14 of the 15 village homes actually lie within a 27 Mbps band (6 to 33 Mbps). The interquartile range (IQR) of 16 Mbps (26 − 10) measures the middle 50% of homes and cuts off the top and bottom 25%, so it is completely unaffected by the 310 Mbps outlier.

Contrasts the full range (304 Mbps), the 14-home range (27 Mbps) and the IQR (16 Mbps) to show why the IQR gives a faithful representation of spread. Evidences criterion 2.

Step 3: Test 4 broadband claims

Claim Statement made at the council meeting True or False / Misleading? Mathematical proof (quote exact figures)
A “On average, homes in Cwm Hafod get 37 Mbps, so more than half the village enjoys speeds above 35 Mbps.” False / Misleading Although the mean is 37 Mbps, it is skewed by the 310 Mbps outlier. The median is only 18 Mbps, and the 14th highest speed is 33 Mbps, so only 1 out of 15 homes (6.7%) gets above 35 Mbps.
B “The middle 50% of broadband speeds in Cwm Hafod are less spread out (more consistent) than the middle 50% in Trefelin.” True The spread of the middle 50% is the IQR. Cwm Hafod’s IQR is 16 Mbps (26 − 10), which is smaller than Trefelin’s IQR of 24 Mbps (68 − 44).
C “Every single surveyed home in Trefelin has a faster download speed than at least three-quarters of the homes in Cwm Hafod.” True Trefelin’s minimum speed is 32 Mbps, which is higher than Cwm Hafod’s upper quartile (Q3 = 26 Mbps, covering 75% of homes; in fact 13 of 15 homes in Cwm Hafod get 28 Mbps or less).
D “At least a quarter of the surveyed homes in Trefelin receive 68 Mbps or faster.” True Trefelin’s upper quartile (Q3, the 12th value) is 68 Mbps, so the top 4 homes out of 15 (68, 72, 75 and 80 Mbps, which is 26.7%) receive 68 Mbps or faster.

Uses quartiles, medians and minimums accurately to test proportions (quarters, halves and three-quarters) and exposes the misuse of the mean in Claim A. Evidences criterion 3.

Step 4: Write a comparison report for the county council

Broadband download speeds in Cwm Hafod are substantially slower on average than in Trefelin: Cwm Hafod’s median speed is 18 Mbps, which is less than a third of Trefelin’s median of 56 Mbps. The middle 50% of connections in Cwm Hafod are slightly more consistent (less spread out) than in Trefelin, with an interquartile range of 16 Mbps (from 10 Mbps to 26 Mbps) compared with Trefelin’s interquartile range of 24 Mbps (from 44 Mbps to 68 Mbps), because village homes are consistently stuck on slow copper lines. The council should ignore Cwm Hafod’s mean of 37 Mbps and range of 304 Mbps because both are distorted by a single private full-fibre outlier of 310 Mbps at Hendre Farm, whereas 13 of the 15 village homes do not even reach the 30 Mbps superfast threshold.

Meets the full GCSE distribution-comparison standard: compares medians in context with numbers, compares IQRs in context with numbers, and explains why the outlier invalidates the mean and range. Evidences criterion 4.

If you finish early: answers

Why this response is secure