Printable · GCSE Foundation · ages 14-16
Tables, charts and diagrams for data worksheet — GCSE Foundation
Fifteen questions on "tables, charts and diagrams for data" — DfE statement S2. Print it, or print three versions so neighbours cannot copy by letter; the key gives the letter for each version.
Answer key: Tables, charts and diagrams for data worksheet — GCSE Foundation
MathsUKwww.geekhero.co.uk
- (a) £16,000 — Method: first find the quarter with the highest sales figure, then subtract quarter 1's sales from it — remembering that every figure is given in THOUSANDS of pounds. Working: the highest sales figure is quarter 2, at £34,000 (34 thousand pounds). The increase from quarter 1 is £34,000 − £18,000 = £16,000. Giving £34,000 reads off the highest sales figure on its own, without subtracting quarter 1's sales — that is the highest quarter's total, not the increase. Giving £12,000 uses quarter 3's sales, 30, the SECOND-highest figure, instead of quarter 2's 34, the actual highest — 30 − 18 = 12, but quarter 3 is not the quarter with the highest sales. Giving £16 gets the subtraction right, 34 − 18 = 16, but forgets that every figure in the question is in thousands of pounds, so the increase is £16,000, not £16. Always identify the correct quarter FIRST, and always check the units the numbers are given in before writing your final answer.
- (a) A vertical line chart (discrete numerical data) — The number of pets is discrete numerical data — whole-number values such as 0, 1, 2, 3 or 4 — recorded for one variable, so a vertical line chart is the chart specified for this kind of data. A bar chart is used for categorical data, such as favourite colour, not numerical values counted like this. A pie chart shows proportions of a whole and does not show the frequency of each separate value. A scatter graph compares two different variables against each other, and only one variable, the number of pets, is recorded here.
- (d) 30 — Method: on a dual bar chart each bar is a separate frequency, so a total for the whole class is found by combining the two frequencies the bars show. Working: the bars show 14 boys and 16 girls, and 14 + 16 = 30. Answer: 30 pupils, a count of pupils in the class. The distractors: 32 comes from doubling the taller bar, 16 + 16, as though the two bars were equal; 28 comes from doubling the shorter bar, 14 + 14, in the same way; 2 comes from finding the difference between the two bars, 16 − 14, which answers how many more girls there are rather than how many pupils there are.
- (a) The temperature is rising steadily — Method: the trend of a line graph is the overall direction of the readings as time goes on, found by comparing each reading with the one before it. Working: from 10 °C to 14 °C is a rise of 4 °C, and the same comparison from 14 °C to 18 °C, from 18 °C to 22 °C, from 22 °C to 26 °C and from 26 °C to 30 °C gives a rise of 4 °C every time; every reading is greater than the one before it and none of them falls. Answer: the temperature is rising steadily — steadily because the rise is the same size each hour. The distractors: falling steadily comes from reading the six values from right to left, which reverses the direction of time; stays the same comes from noticing that the step of 4 °C is the same each hour and describing the step as constant instead of the temperature; rises and then falls comes from assuming that a line graph has to turn at some point rather than reading the values that are actually given.
- (b) 4 — The difference, Bristol minus Leeds, on each day is: Monday 4 − 3 = 1, Tuesday 4 − 5 = −1, Wednesday 6 − 2 = 4, Thursday 2 − 4 = −2. The greatest amount by which Bristol exceeded Leeds is 4 hours, on Wednesday. Choosing 1 takes Monday's smaller positive difference instead of the greatest one. Choosing 2 takes the size of Thursday's difference, but that is the amount by which Leeds exceeded Bristol, the opposite direction to the one asked for. Choosing 6 takes Bristol's raw figure on Wednesday without subtracting Leeds's 2 hours first.
- (c) The frequency of that category — Method: a bar chart for categorical data has one bar for each category, and the vertical scale on which the bars are measured is a count. Working: a bar drawn twice as tall as another tells you that twice as many items of data fell into its category, so the height measures how many items of data belong to that one category, which is exactly what a frequency is. Answer: the height of each bar is the frequency of that category — a count of items of data. The distractors: the number of different categories comes from reading the vertical scale as though it counted the bars, which is shown along the horizontal axis instead; the total of all the data comes from treating one bar as though it stood for the whole data set rather than for one category; the mean of all the data comes from confusing a bar chart with a measure of average, which no single bar can show.
- (d) 45 — Method: convert the angle into a fraction of the full circle, 360°, then apply that fraction to the total number of shoppers. Working: the card sector is 90° out of 360°, a fraction of 90 ÷ 360 = 0.25. Applying that fraction to the 180 shoppers gives 0.25 × 180 = 45 shoppers. Giving 90 states the angle itself, not a number of shoppers — the angle first has to be converted into a fraction. Using the remaining angle, 360 − 90 = 270°, and scaling that, 270 ÷ 360 × 180 = 135, finds the number who did NOT pay by card, not the number who did. Dividing 360 by 90, 360 ÷ 90 = 4, finds how many equal 90° sectors fit in the circle, a fact about the pie chart's shape, not about the shoppers at all. Always convert the angle to a fraction of 360° first, and apply that same fraction to the total number of people.
- (b) A line graph — Sales recorded at the end of each of the twelve months are time series data, and a line graph is the chart built to show how a value changes over time, with the points usually joined in order. A pie chart is for showing categorical data as shares of a whole, not a trend over time. A pictogram shows a frequency for separate categories using symbols, not a continuous trend. A scatter graph is for comparing two different variables against each other, not one variable over time.
- (d) 44 — Method: the frequency of a category in a frequency table is the number of times that category was counted, and it is read from the row for that category. Working: the rows of the table pair each colour with its count, and the row for black is paired with the count 44, so the frequency of black cars is 44. Answer: 44 cars — a frequency is a count of cars, not a colour and not a percentage. The distractors: 37 comes from reading the count paired with silver, that is from reading the wrong row of the table; 137 comes from adding every count in the table, 44 + 37 + 26 + 18 + 12, which gives the total number of cars rather than the frequency of one colour; 5 comes from counting how many different colours the table lists instead of how many cars were black.
- (c) 90° — Method: the sectors of a pie chart share the 360° at the centre of the chart in the same proportion as the data, so a sector's angle is its share of the data multiplied by 360°. Working: a share of 25% is the fraction 25/100, which is one quarter of the whole chart, and one quarter of 360° is 360 ÷ 4 = 90°. Answer: 90°, an angle in degrees rather than a percentage. The distractors: 25° comes from sharing out 100 instead of 360, so the percentage is written straight down as a number of degrees; 14.4° comes from dividing 360 by 25 instead of multiplying 360 by the fraction 25/100, which is the division done the wrong way round; 45° comes from taking a quarter of 180° instead of a quarter of 360°, treating the pie chart as a semicircle.
- (b) 1 — The four frequencies are 4, 7, 6 and 3 matches, and the largest of these is 7, which corresponds to 1 goal, so the modal number of goals is 1. Choosing 7 confuses the frequency, how many matches, with the number of goals itself. Choosing 2 uses the second-largest frequency, 6 matches, instead of the largest. Choosing 3 uses the smallest frequency, which belongs to the fewest matches, not the most.
- (d) 25% — First find the number of fruit cakes: 80 − 34 − 26 = 20. Then write this as a percentage of the total: 20 ÷ 80 × 100 = 25%. Giving 20% comes from reporting the count of fruit cakes, 20, directly as a percentage, without dividing by the total of 80 first. Giving 32.5% computes the percentage of chocolate cakes instead of fruit cakes: 26 ÷ 80 × 100 = 32.5%. Giving 42.5% computes the percentage of sponge cakes instead of fruit cakes: 34 ÷ 80 × 100 = 42.5%.
- (a) 22 — Method: the two subject totals overlap, because every pupil who passed both subjects has been counted once in the maths total and once again in the science total; adding the totals therefore counts those pupils twice, and the overlap has to be taken off once. Working: 18 + 12 = 30, and the 8 pupils who passed both have been counted twice in that 30, so the number who passed at least one subject is 30 − 8 = 22. Answer: 22 pupils, a count of pupils, and it is less than the 30 in the class, which leaves 8 pupils who passed neither. The distractors: 30 comes from adding the two subject totals and never removing the overlap, so it counts the 8 pupils twice; 14 comes from taking the 8 away twice, 18 + 12 − 8 − 8, removing an overlap that was only counted twice once too often; 18 comes from writing down the larger of the two subject totals on its own, which leaves out every pupil who passed science but not maths.
- (b) 20 — Method: each sector of a pie chart stands for a percentage of the whole set of data, so the number of pupils in a sector is that percentage of the total number of pupils. Working: the football sector is 50% and the whole pie chart stands for all 40 pupils, so the number of pupils is 50% of 40 = 0.5 × 40 = 20. Answer: 20 pupils, which is a count of pupils rather than a percentage. The distractors: 10 comes from taking the netball sector, 25% of 40, instead of the football sector; 80 comes from doubling the 40 pupils instead of halving them, which is what multiplying by 50% would do the wrong way round; 40 comes from writing down the total number of pupils in the class and never applying the percentage at all.
- (b) 15 pupils — The frequencies are 5, 4, 3 and 3 pupils, and 5 + 4 + 3 + 3 = 15, so there are 15 pupils in the class. Choosing 6 pupils comes from adding the numbers of pets, 0 + 1 + 2 + 3 = 6, instead of the frequencies. Choosing 10 pupils comes from leaving out the '0 pets' row: 4 + 3 + 3 = 10. Choosing 18 pupils comes from counting the '3 pets' row twice: 5 + 4 + 3 + 3 + 3 = 18.
Build your own mix at the worksheet builder.