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.
Tables, charts and diagrams for data worksheet — GCSE Foundation
MathsUKwww.geekhero.co.uk
- 1.A dual bar chart shows how many boys and how many girls are in a class. The bar for boys stands at 14 and the bar for girls stands at 16. Work out how many pupils are in the class altogether.
- 2.A line graph shows the temperature in a greenhouse at the end of each of six hours. The six readings were 10 °C, 14 °C, 18 °C, 22 °C, 26 °C and 30 °C. Describe the trend shown by the line graph.
- 3.A two-way table records whether each of 40 people at a gym in Sheffield prefers weights or cardio, and whether they are male or female. 24 of the 40 people are female. 15 of the males prefer cardio. 10 of the females prefer weights. Work out the total number of people who prefer cardio.
- 4.A stacked bar for one day at a café in Norwich shows total drink sales of 50 drinks, split into three parts: 22 were tea, 15 were coffee and the rest were hot chocolate. Work out the number of hot chocolates sold.
- 5.A vertical line chart shows the number of pets owned by each pupil in a class: 0 pets — 5 pupils, 1 pet — 4 pupils, 2 pets — 3 pupils, 3 pets — 3 pupils. Work out the total number of pupils in the class.
- 6.A two-way table records whether each of the 30 pupils in a class passed maths and whether they passed science. 18 pupils passed maths, 12 pupils passed science and 8 pupils passed both. Work out how many pupils passed at least one of the two subjects.
- 7.A bar chart shows the number of books borrowed from a school library on each of five days. The bar heights are: Monday 12, Tuesday 18, Wednesday 9, Thursday 15 and Friday 21. Work out the total number of books borrowed over the five days.
- 8.A charity shop in Leicester made £2,400 in one month. A pie chart shows how this was spent: repairs took up an angle of 90°, wages took up an angle of 150°, and the rest was other costs. Work out how much was spent on wages.
- 9.A pictogram shows the number of cars sold by a garage in Plymouth each month, where each whole car symbol represents 8 cars sold and a half symbol represents 4 cars. March shows 3 whole symbols and one half symbol. Work out how many cars were sold in March.
- 10.A shop records the colour of every car that uses its car park one Tuesday. Its frequency table reads: black 44, silver 37, blue 26, red 18, white 12. Write down the frequency of black cars.
- 11.A vertical line chart shows the number of goals scored by a football team in each of its 20 matches: 0 goals in 4 matches, 1 goal in 7 matches, 2 goals in 6 matches and 3 goals in 3 matches. Write down the modal number of goals.
- 12.A garden centre records its total sales, in pounds, at the end of each of the twelve months of one year, to see how sales change over time. Write down the most suitable type of chart to show this time series data.
- 13.A pie chart shows how 180 shoppers at a supermarket paid for their shopping. The sector for card payments has an angle of 90° at the centre. Work out how many of the 180 shoppers paid by card.
- 14.A composite (stacked) bar for a charity bake sale in Durham shows the number of cakes sold, split into three types. The bar has a total height of 80 cakes: 34 were sponge cakes, 26 were chocolate cakes and the rest were fruit cakes. Work out the percentage of the cakes sold that were fruit cakes.
- 15.A timetable shows the departure times of a bus from Leeds to Harrogate: 08:15, 08:50, 09:25, 10:05, 10:40. Chloe arrives at the bus stop at 09:30. Work out how many minutes she has to wait for the next bus.
Answer key
- (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) 29 — There are 40 − 24 = 16 males, and 15 of them prefer cardio, so 16 − 15 = 1 male prefers weights. There are 24 females, and 10 prefer weights, so 24 − 10 = 14 females prefer cardio. Altogether, 15 + 14 = 29 people prefer cardio. Choosing 15 only counts the males who prefer cardio and forgets the females. Choosing 11 adds the two weights figures, 1 + 10 = 11, instead of the two cardio figures. Choosing 30 comes from 40 − 10, subtracting only the number of females who prefer weights from the grand total, rather than finding both cardio sub-totals separately.
- (b) 13 — The total is 50, and the two known parts are 22 (tea) and 15 (coffee), so 50 − 22 − 15 = 13 hot chocolates. Choosing 28 comes from 50 − 22, subtracting only the tea and forgetting the coffee. Choosing 35 comes from 50 − 15, subtracting only the coffee and forgetting the tea. Choosing 37 comes from 22 + 15, which finds how many drinks were tea or coffee, not the number left over for hot chocolate.
- (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.
- (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.
- (d) 75 — Method: to find a total from a bar chart, add together the height of every bar. Working: 12 + 18 + 9 + 15 + 21 = 75 books. Leaving out Wednesday's bar by mistake, 12 + 18 + 15 + 21 = 66, misses one day out of the total. Giving 21 states only Friday's bar, the tallest one, not the total of all five days. Dividing the total by the number of days, 75 ÷ 5 = 15, finds the mean number of books per day, not the total borrowed. Add up every single bar — do not stop at the biggest one, and do not divide once you have added them all.
- (b) £1,000 — Wages take up 150° out of 360°, so the amount spent on wages is 150 ÷ 360 × 2400 = £1,000. Choosing £600 uses the repairs angle, 90°, instead of the wages angle: 90 ÷ 360 × 2400 = 600. Choosing £3,600 treats the angle in degrees as if it were a percentage, 150 ÷ 100 × 2400 = 3600, instead of dividing by 360°. Choosing £800 uses the angle for the 'other costs' sector, 360 − 90 − 150 = 120°, instead of the wages sector: 120 ÷ 360 × 2400 = 800.
- (c) 28 — Method: multiply the number of whole symbols by the value of one symbol, then add the value of any half symbol shown. Working: 3 whole symbols represent 3 × 8 = 24 cars. The half symbol represents 4 cars. Total cars sold in March = 24 + 4 = 28. Leaving out the half symbol, 3 × 8 = 24, undercounts by exactly the value of that half symbol. Treating the half symbol as if it were a full symbol, 4 × 8 = 32, overcounts because it doubles the value the half symbol is worth. Giving 3.5 reports the number of symbols shown, not the number of cars they represent — the key still needs to be applied. Always apply the key to every symbol shown, including a half symbol, rather than reading off the symbol count itself.
- (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.
- (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.
- (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) 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.
- (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) 35 minutes — Chloe arrives at 09:30, so she needs the first departure time that is at or after 09:30. The bus at 09:25 has already left five minutes before she arrives, so it is missed, not caught; the next one on the timetable is 10:05. From 09:30 to 10:00 is 30 minutes, then a further 5 minutes to 10:05, so the wait is 35 minutes. Giving 40 minutes measures the gap from the missed 09:25 bus to the 10:05 bus, counting from the bus Chloe missed instead of from the time she arrived. Giving 5 minutes uses the missed 09:25 bus, working out 09:30 − 09:25 the wrong way round. Giving 45 minutes comes from treating the times as decimals — 10.05 − 9.30 = 0.75, then × 60 = 45 — instead of working in hours and minutes, where 05 minutes past the hour is not 0.05 of an hour.
Build your own mix at the worksheet builder.