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 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.
- 2.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.
- 3.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.
- 4.A bar chart is drawn for a set of categorical data. Write down what the height of each bar represents.
- 5.A garden centre's sales, in thousands of pounds, at the end of each quarter last year were: quarter 1 — 18, quarter 2 — 34, quarter 3 — 30, quarter 4 — 22. Work out the increase in sales from quarter 1 to the quarter with the highest sales.
- 6.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.
- 7.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.
- 8.In a vertical line chart of test results, the tallest line stands for 40 pupils. The same results are to be shown in a pie chart of all 100 pupils. Work out the angle at the centre of the sector that will stand for those 40 pupils.
- 9.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.
- 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 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 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.
- 13.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.
- 14.A sports centre in Newcastle asks 60 members which activity they prefer: swimming 15 members, football 25 members, badminton 12 members and other activities 8 members. Work out the angle at the centre of the pie chart sector that represents badminton.
- 15.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.
Answer key
- (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) 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) £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) 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.
- (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.
- (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.
- (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) 144° — Method: a pie chart shares the 360° at its centre between the categories in proportion to their frequencies, so the angle of a sector is that category's fraction of the total multiplied by 360°. Working: the sector stands for 40 pupils out of 100, which is the fraction 40/100; one pupil is worth 360 ÷ 100 = 3.6°, so 40 pupils are worth 40 × 3.6° = 144°. Answer: 144°, and the answer is an angle in degrees, not a number of pupils. The distractors: 40° comes from sharing out 100 instead of 360, so the percentage is written straight down as a number of degrees; 216° comes from working out the angle for the other 60 pupils, 60 × 3.6°, which is the rest of the pie chart; 180° comes from assuming that the tallest line must stand for half of the pupils and so take half of the chart.
- (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.
- (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) 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) 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.
- (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.
- (c) 72° — The angle is 12 ÷ 60 × 360 = 72°. Choosing 150° divides football's frequency of 25 instead of badminton's 12: 25 ÷ 60 × 360 = 150. Choosing 20° finds badminton as a percentage of the members, 12 ÷ 60 × 100 = 20, rather than an angle in degrees. Choosing 90° uses 48, the total of the other three activities, as the total instead of the full 60 members: 12 ÷ 48 × 360 = 90.
- (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.
Build your own mix at the worksheet builder.