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 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.
- 2.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.
- 3.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.
- 4.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.
- 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 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.
- 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 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.
- 9.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.
- 10.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.
- 11.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.
- 12.A bar chart is drawn for a set of categorical data. Write down what the height of each bar represents.
- 13.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.
- 14.A pie chart of the favourite hobby of a group of pupils has three sectors: reading 50%, sport 25% and music 25%. Write down, as a fraction in its simplest form, the share of the pie chart taken up by the reading sector.
- 15.A dual bar chart shows the number of hours of rain recorded in Leeds and in Bristol on each of four days. Leeds: Monday 3 hours, Tuesday 5 hours, Wednesday 2 hours, Thursday 4 hours. Bristol: Monday 4 hours, Tuesday 4 hours, Wednesday 6 hours, Thursday 2 hours. Work out the greatest amount, in hours, by which Bristol's rainfall exceeded Leeds's rainfall on a single day.
Answer key
- (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.
- (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) 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.
- (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.
- (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.
- (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%.
- (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) 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.
- (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.
- (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.
- (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) 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.
- (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) 1/2 — Method: a percentage is turned into a fraction by writing it over 100 and then cancelling the fraction down to its simplest form. Working: the reading sector is 50% of the pie chart, so as a fraction it is 50/100; dividing the numerator and the denominator by 50 gives 1/2. Answer: 1/2 of the pie chart — a fraction of the chart, not a number of pupils. The distractors: 1/4 comes from reading the share of the sport sector, 25%, instead of the share of the reading sector; 1/3 comes from counting the three sectors and assuming that three sectors must each take a third of the chart, which is only true when the sectors are equal; 3/4 comes from adding the reading and sport sectors together, 50% + 25% = 75%, instead of taking the reading sector on its own.
- (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.
Build your own mix at the worksheet builder.