2 Tables and charts
2.1 Tables
Experiments or surveys usually generate a lot of information from which it is possible to draw conclusions. Such information is called data. Data are often presented in newspapers or books.
One convenient way to present data is in a table. For instance, the nutrition panel on the back of a food packet:
Nutrient Per 100g | Per 400g | |
---|---|---|
Energy | 404.6KJ/97Kcal | 1618.4KJ/388Kcal |
Protein | 61.0g | 244g |
Carbohydrate | 8.6g | 34.4g |
of which sugars | 2.0g | 8.0g |
starch | 6.2g | 24.8g |
Fat | 3.8g | 15.2g |
of which saturates | 1.1g | 4.4g |
mono-saturates | 1.2g | 4.8g |
polysaturates | 0.5g | 2.0g |
fibre | 1.8g | 7.2g |
sodium | 0.2g | 0.8g |
salt | 0.6g | 2.4g |
Scientific experiments often require a series of measurements taken at regular intervals. Information can be recorded as it is collected. For example, the table below resulted from an experiment to determine how quickly a cup of tea cooled down.
Time/mins | 0 | 5 | 10 | 15 | 20 | 25 | 30 | 35 | 40 | 45 | 50 |
Temperature/°C | 85 | 78 | 55 | 50 | 46 | 40 | 35 | 30 | 25 | 24 | 23 |
Tables can be laid out vertically (as in the nutrition panel) or horizontally (as in the tea experiment). Each column or row heading should indicate what is being measured and the unit of measurement. (Columns are vertical; rows are horizontal.)
A table is not merely a convenient way of presenting data. It can often facilitate comparisons and can lead to conclusions that would have been difficult to deduce from the separate data, as the next example shows.
Example 3
Home | Away | |||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Position | Team | Games played | Games won | Games drawn | Games lost | Goals for | Goals against | Games won | Games drawn | Games lost | Goals for | Goals against | Goal difference | Points |
1 | Nottingham Forest | 42 | 15 | 6 | 0 | 37 | 8 | 10 | 8 | 3 | 32 | 16 | 45 | 64 |
2 | Liverpool | 42 | 15 | 4 | 2 | 37 | 11 | 9 | 5 | 7 | 28 | 23 | 31 | 57 |
3 | Everton | 42 | 14 | 4 | 3 | 47 | 22 | 8 | 7 | 6 | 29 | 23 | 31 | 55 |
4 | Manchester City | 42 | 14 | 4 | 3 | 46 | 21 | 6 | 8 | 7 | 28 | 30 | 23 | 52 |
5 | Arsenal | 42 | 14 | 5 | 2 | 38 | 12 | 7 | 5 | 9 | 22 | 25 | 23 | 52 |
6 | West Bromwich Albion | 42 | 13 | 5 | 3 | 35 | 18 | 5 | 9 | 7 | 27 | 35 | 9 | 50 |
7 | Coventry City | 42 | 13 | 5 | 3 | 48 | 23 | 5 | 7 | 9 | 27 | 39 | 13 | 48 |
8 | Aston Villa | 42 | 11 | 4 | 6 | 33 | 18 | 7 | 6 | 8 | 24 | 24 | 15 | 46 |
9 | Leeds United | 42 | 12 | 4 | 5 | 39 | 21 | 6 | 6 | 9 | 24 | 32 | 10 | 46 |
10 | Manchester United | 42 | 9 | 6 | 6 | 32 | 23 | 7 | 4 | 10 | 35 | 40 | 4 | 42 |
11 | Birmingham City | 42 | 8 | 5 | 8 | 32 | 30 | 8 | 4 | 9 | 23 | 30 | −5 | 41 |
12 | Derby County | 42 | 10 | 7 | 4 | 37 | 24 | 4 | 6 | 11 | 17 | 35 | −5 | 41 |
13 | Norwich City | 42 | 10 | 8 | 3 | 28 | 20 | 1 | 10 | 10 | 24 | 46 | −14 | 40 |
14 | Middlesbrough | 42 | 8 | 8 | 5 | 25 | 19 | 4 | 7 | 10 | 17 | 35 | −12 | 39 |
15 | Wolverhampton Wanderers | 42 | 7 | 8 | 6 | 30 | 27 | 5 | 4 | 12 | 21 | 37 | −13 | 36 |
16 | Chelsea | 42 | 7 | 11 | 3 | 28 | 20 | 4 | 3 | 14 | 18 | 49 | −23 | 36 |
17 | Bristol City | 42 | 9 | 6 | 6 | 37 | 26 | 2 | 7 | 12 | 12 | 27 | −4 | 35 |
18 | Ipswich Town | 42 | 10 | 5 | 6 | 32 | 24 | 1 | 8 | 12 | 15 | 37 | −14 | 35 |
19 | Queens Park Rangers | 42 | 8 | 8 | 5 | 27 | 26 | 1 | 7 | 13 | 20 | 38 | −17 | 33 |
20 | West Ham United | 42 | 8 | 6 | 7 | 31 | 28 | 4 | 2 | 15 | 21 | 41 | −17 | 32 |
21 | Newcastle United | 42 | 4 | 6 | 11 | 26 | 37 | 2 | 4 | 15 | 16 | 41 | −36 | 22 |
22 | Leicester City | 42 | 4 | 7 | 10 | 16 | 32 | 1 | 5 | 15 | 10 | 38 | −44 | 22 |
Total goals | — | — | — | — | 741 | 490 | — | — | — | 490 | 741 | — | — |
(a) How many goals did Liverpool score at home and how many did they score away?
(b) Which team scored the most goals away from their home ground?
(c) Which was the worst team defensively away from their home gound, i.e. the team with the highest number of goals scored against them when playing away?
(d) Suggest reasons for the discrepancy between the total number of goals scored at home and the total number of goals scored away.
Answer
(a) Home – 37, Away – 28.
(b) Manchester United scored the most goals away from their home ground, 35.
(c) Chelsea let in 49 goals when away from their home ground.
(d) Possible reasons for the discrepancy could include: familiarity with the pitch, travel discomfort.
It is important to appreciate that, although you can state factual conclusions, you can often only suggest reasons. In many cases, interpretation of data depends on your own experience or on some other information not included in the table.
Example 4
Use the table below to answer the following questions:
(a) What is the Body Mass Index (BMI) of a person who is 5’7” and who weighs 170 lbs?
(b) What category are they in?
(c) How much weight does a person who is 6’0” tall and who currently weighs 250 lbs have to lose in order to be in the low risk category?
Answer
(a) 27.
(b) They are overweight.
(c) You cannot answer this question exactly using the table given. You can see from the table that a person who is 6’0” tall, weighing 190 lbs has a BMI of 26 and is low risk. So losing 60 lbs is sufficient. You also know that a weight of 200 lbs is too much to be classified as low risk, so losing 50 lbs is not sufficient. The table does not allow you to answer this question more accurately.