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 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.
- 2.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.
- 3.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.
- 4.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.
- 5.A bar chart shows the highest temperature recorded on each of five days. The temperatures were Monday 20 °C, Tuesday 22 °C, Wednesday 18 °C, Thursday 25 °C and Friday 23 °C. Write down the day on which the temperature was highest.
- 6.A two-way table records whether each of 50 pupils in Year 10 or Year 11 at a school walks to school or is driven. 28 of the 50 pupils are in Year 10. In total, 22 of the 50 pupils walk to school. Of the Year 10 pupils, 15 walk to school. Work out how many Year 11 pupils are driven to school.
- 7.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.
- 8.A frequency polygon for the mass, in kg, of 40 parcels at a delivery depot is drawn by plotting one point at the midpoint of each class, joined by straight lines: (5, 6), (15, 10), (25, 16), (35, 6), (45, 2). Every class has a width of 10 kg. Write down the modal class.
- 9.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.
- 10.A teacher records the number of pets owned by each of 25 pupils in a class; each pupil owns 0, 1, 2, 3 or 4 pets. The teacher wants to show how many pupils own each number of pets. Write down the most suitable type of chart for this data, and give a reason for your answer.
- 11.A pie chart shows the favourite sport of the 40 pupils in a class: football 50%, netball 25%, tennis 15% and swimming 10%. Work out how many pupils chose football.
- 12.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.
- 13.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.
- 14.A two-way table records the favourite subject, Maths or Art, of 60 pupils in Year 10, and whether each pupil is left-handed or right-handed. 9 of the 60 pupils are left-handed, and 6 of those left-handed pupils prefer Art. In total, 24 of the 60 pupils prefer Art. A pupil is chosen at random from the 60. Work out the probability that the pupil is right-handed and prefers Art.
- 15.A sector of a pie chart stands for 25% of the data. Work out the angle at the centre of that sector.
Answer key
- (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.
- (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) 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.
- (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.
- (c) Thursday — Method: on a bar chart the tallest bar belongs to the greatest value, so compare the five temperatures and then read off the day that the greatest one belongs to. Working: the temperatures are 20 °C, 22 °C, 18 °C, 25 °C and 23 °C; in order of size these are 18, 20, 22, 23 and 25, so the greatest temperature is 25 °C, and the day recorded with 25 °C is Thursday. Answer: Thursday — the answer is a day, not a temperature. The distractors: Friday comes from stopping at the final temperature listed instead of comparing all five; Wednesday comes from picking out the shortest bar, 18 °C, and so answering for the lowest temperature rather than the highest; Monday comes from writing down the first day in the chart without comparing any of the temperatures at all.
- (a) 15 — Year 11 has 50 − 28 = 22 pupils in total. Of the 22 pupils who walk in total, 15 are in Year 10, so 22 − 15 = 7 Year 11 pupils walk. Subtracting that from the Year 11 total gives 22 − 7 = 15 Year 11 pupils who are driven. Choosing 28 takes the whole school's driven total, 50 − 22 = 28, and treats it as if it were Year 11's alone, without separating the year groups. Choosing 7 correctly finds how many Year 11 pupils walk but stops there, giving that figure instead of the number who are driven. Choosing 35 comes from 50 − 15, subtracting the Year 10 walkers from the whole school total rather than working within Year 11.
- (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.
- (c) 20 kg ≤ mass < 30 kg — The modal class is the class with the highest frequency. Reading the plotted points, the frequencies are 6, 10, 16, 6 and 2, so the highest frequency is 16, plotted at the midpoint 25. A class of width 10 centred on 25 runs from 25 − 5 = 20 to 25 + 5 = 30, so the modal class is 20 kg ≤ mass < 30 kg. Writing '25 kg' gives only the midpoint, not the class — the modal class is an interval, not a single value. '10 kg ≤ mass < 20 kg' is the class before the peak, centred on 15, which has frequency 10, not the highest. '30 kg ≤ mass < 40 kg' is the class after the peak, centred on 35, which has frequency 6, not the highest.
- (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) 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.
- (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.
- (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) £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.
- (a) 3/10 — There are 60 − 9 = 51 right-handed pupils. Of the 24 pupils who prefer Art, 6 are left-handed, so 24 − 6 = 18 are right-handed and prefer Art. The probability that a randomly chosen pupil is right-handed and prefers Art is 18/60, which simplifies to 3/10. Giving 2/5 is 24/60 simplified — the probability of preferring Art, ignoring the right-handed condition entirely. Giving 17/20 is 51/60 simplified — the probability of being right-handed, ignoring the Art condition entirely. Giving 1/10 is 6/60 simplified — the probability of being left-handed and preferring Art, the wrong hand condition.
- (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.
Build your own mix at the worksheet builder.