Year 5: Reading and completing tables
Part of the Year 5 statistics chapter. Chapter overview · whole chapter on one page
Reading and completing tables
A table puts information in rows and columns. Read across a row to find the information for one item, and down a column for one category. A total adds up a row or a column.
To complete a table, work out the missing number from the total and the numbers you already know. Use the subtraction to find the missing part, or addition to find a total.
Points scored at the sports day.
| Class | Races | Relay | Tug of war | Total points |
|---|---|---|---|---|
| 5A | 14 | 9 | 7 | 30 |
| 5B | 11 | 12 | 8 | 31 |
| 5C | 9 | 10 | 13 | 32 |
| 5D | 12 | 6 | 11 | 29 |
Key ideas
- Read across a row for one item, and down a column for one category.
- A total is the sum of the numbers in its row or column.
- To find a missing number, take the known numbers away from the total.
- Check that the numbers in each row add up to its total.
| Class | Races | Relay | Tug of war | Total points |
|---|---|---|---|---|
| 5A | 14 | 9 | 7 | 30 |
| 5B | 11 | 12 | 8 | 31 |
| 5C | 9 | 10 | 13 | 32 |
| 5D | 12 | 6 | 11 | 29 |
Key words. A table puts information in rows and columns. Read along a row for one item and down a column for one category. A total is the sum of a row or a column.
Method. Read along the row for 5C, then add the three numbers in that row.
- Find the row for 5C. Each row is one class.5C
- Read the three events. The races, relay and tug of war are the three numbers in the row.9 + 10 + 13
- Add the three numbers. The total is the sum of the three events.9 + 10 + 13 = 32
- Write the answer. 32 points
Check. The total column also shows 32 for 5C. ✓
Watch out. Use the numbers in the same row. Do not mix up two classes.
| Day | Lemon sales | Chocolate sales | Total sales |
|---|---|---|---|
| Monday | £36 | £48 | £84 |
| Tuesday | £42 | £39 | £81 |
| Wednesday | £30 | £51 | £81 |
| Thursday | £45 | £44 | £89 |
| Friday | £58 | £62 | £120 |
| Whole week | £211 | £244 | £455 |
Key words. A table puts information in rows and columns. Read along a row for one item and down a column for one category. A total is the sum of a row or a column.
Method. Add all five daily lemon sales, reading down the lemon column.
- Find the lemon column. The lemon sales are in the second column.lemon sales
- Read each day. Read the five numbers from the table.£36, £42, £30, £45, £58
- Add the five numbers. The total for the week is the sum of the column.36 + 42 + 30 + 45 + 58 = 211
- Write the answer. £211
Check. The whole-week row of the table also shows £211. ✓
Watch out. Add the column, not the row. Each row is one day.
| Pet | Number |
|---|---|
| Dogs | 4 |
| Cats | ? |
| Fish | 3 |
| Rabbits | 2 |
| Total | 14 |
Key words. A table puts information in rows and columns. Read along a row for one item and down a column for one category. A total is the sum of a row or a column.
Method. Subtract the known values from the total to find the missing one.
- Look at the total. The total of all the pets is 14.total = 14
- Add the numbers we know. These are the values that are in the table.4 + 3 + 2 = 9
- Take the known total away from the total. The missing number is what is left over.14 − 9 = 5
- Write the answer. Cats = 5
Check. 9 + 5 = 14, so the total is right. ✓
Watch out. A missing value is not a total: work it out from the total and the other values.
Watch out
Watch out: a total at the bottom of a column adds up the numbers above it. Do not add the numbers in the total column when you are asked for the total of one column, and do not mix up rows and columns.
Exercise 11D Reading and completing tables
Non-calculator| Class | Races | Relay | Tug of war | Total points |
|---|---|---|---|---|
| 5A | 14 | 9 | 7 | 30 |
| 5B | 11 | 12 | 8 | 31 |
| 5C | 9 | 10 | 13 | 32 |
| 5D | 12 | 6 | 11 | 29 |
Key words. A table puts information in rows and columns. Read along a row for one item and down a column for one category. A total is the sum of a row or a column.
Method. Find the row for 5D, then read across to the races column.
- Find the row for 5D. Each row is one class.5D
- Find the Races column. The races column has the number of points from the races.Races
- Read the number where they meet. The number in that cell is the answer.12
- Write the answer. 12 points
Check. The table has 12 for 5D in the races column. ✓
Watch out. Use the Races column, not the Total column.
| Class | Races | Relay | Tug of war | Total points |
|---|---|---|---|---|
| 5A | 14 | 9 | 7 | 30 |
| 5B | 11 | 12 | 8 | 31 |
| 5C | 9 | 10 | 13 | 32 |
| 5D | 12 | 6 | 11 | 29 |
Key words. A table puts information in rows and columns. Read along a row for one item and down a column for one category. A total is the sum of a row or a column.
Method. Find the row for 5C, then read across to the relay column.
- Find the row for 5C. Each row is one class.5C
- Find the Relay column. The relay column has the points from the relay.Relay
- Read the number where they meet. The number in that cell is the answer.10
- Write the answer. 10 points
Check. 9 + 10 + 13 = 32 is the total for 5C, so 10 is one of its three events. ✓
Watch out. Read along the row for 5C only.
| Class | Races | Relay | Tug of war | Total points |
|---|---|---|---|---|
| 5A | 14 | 9 | 7 | 30 |
| 5B | 11 | 12 | 8 | 31 |
| 5C | 9 | 10 | 13 | 32 |
| 5D | 12 | 6 | 11 | 29 |
Key words. A table puts information in rows and columns. Read along a row for one item and down a column for one category. A total is the sum of a row or a column.
Method. Find the row for 5A, then read the number in the total column.
- Find the row for 5A. Each row is one class.5A
- Find the Total points column. The last column adds up all three events.Total points
- Read the number. The total is already in the table.30
- Write the answer. 30 points
Check. 14 + 9 + 7 = 30, which matches the table. ✓
Watch out. Read the total column, not one of the events.
| Class | Races | Relay | Tug of war | Total points |
|---|---|---|---|---|
| 5A | 14 | 9 | 7 | 30 |
| 5B | 11 | 12 | 8 | 31 |
| 5C | 9 | 10 | 13 | 32 |
| 5D | 12 | 6 | 11 | 29 |
Key words. A table puts information in rows and columns. Read along a row for one item and down a column for one category. A total is the sum of a row or a column.
Method. Look down the tug of war column for the biggest number.
- Find the tug of war column. Look at the points for the tug of war.Tug of war
- Find the biggest number. 5C has the biggest number, 13.biggest = 13
- Write the answer. 5C
Check. Every other class scored fewer than 13 in the tug of war. ✓
Watch out. Look for the biggest number in one column, not the biggest total.
| Class | Races | Relay | Tug of war | Total points |
|---|---|---|---|---|
| 5A | 14 | 9 | 7 | 30 |
| 5B | 11 | 12 | 8 | 31 |
| 5C | 9 | 10 | 13 | 32 |
| 5D | 12 | 6 | 11 | 29 |
Key words. A comparison says how much more or how much less one value is than another. The difference is found by subtracting the smaller value from the bigger one.
Method. Find the two totals, then subtract the smaller one from the bigger one.
- Read the total for 5B. Use the total points column.31
- Read the total for 5D. Use the total points column.29
- Subtract the smaller total from the bigger total. The difference is how many more points 5B scored.31 − 29 = 2
- Write the answer. 2 points
Check. 29 + 2 = 31. ✓
Watch out. Subtract the smaller total from the bigger one.
| Day | Lemon sales | Chocolate sales | Total sales |
|---|---|---|---|
| Monday | £36 | £48 | £84 |
| Tuesday | £42 | £39 | £81 |
| Wednesday | £30 | £51 | £81 |
| Thursday | £45 | £44 | £89 |
| Friday | £58 | £62 | £120 |
| Whole week | £211 | £244 | £455 |
Key words. A table puts information in rows and columns. Read along a row for one item and down a column for one category. A total is the sum of a row or a column.
Method. Read the Thursday row, then read the lemon column.
- Find the Thursday row. Each row is one day.Thursday
- Read the lemon sales. The lemon column is the second column.£45
- Write the answer. £45
Check. £45 is in the Thursday row and the lemon column. ✓
Watch out. Use the lemon column, not the chocolate column.
| Day | Lemon sales | Chocolate sales | Total sales |
|---|---|---|---|
| Monday | £36 | £48 | £84 |
| Tuesday | £42 | £39 | £81 |
| Wednesday | £30 | £51 | £81 |
| Thursday | £45 | £44 | £89 |
| Friday | £58 | £62 | £120 |
| Whole week | £211 | £244 | £455 |
Key words. A table puts information in rows and columns. Read along a row for one item and down a column for one category. A total is the sum of a row or a column.
Method. Add all five daily chocolate sales, reading down the chocolate column.
- Find the chocolate column. Chocolate sales are the third column.chocolate sales
- Read each day. Read the five numbers.£48, £39, £51, £44, £62
- Add the five numbers. The total is the sum of the column.48 + 39 + 51 + 44 + 62 = 244
- Write the answer. £244
Check. The whole-week row also shows £244 for chocolate. ✓
Watch out. Add the column, not the row.
| Day | Lemon sales | Chocolate sales | Total sales |
|---|---|---|---|
| Monday | £36 | £48 | £84 |
| Tuesday | £42 | £39 | £81 |
| Wednesday | £30 | £51 | £81 |
| Thursday | £45 | £44 | £89 |
| Friday | £58 | £62 | £120 |
| Whole week | £211 | £244 | £455 |
Key words. A table puts information in rows and columns. Read along a row for one item and down a column for one category. A total is the sum of a row or a column.
Method. Look down the total sales column for the biggest number.
- Read the total sales for each day. Each day total is the lemon and chocolate sales added together.Monday £84, Tuesday £81, Wednesday £81, Thursday £89, Friday £120
- Find the biggest total. Friday has the biggest total, £120.biggest = £120
- Write the answer. Friday
Check. Friday's total is £58 + £62 = £120. ✓
Watch out. Use the total sales column, not just the lemon column.
| Day | Lemon sales | Chocolate sales | Total sales |
|---|---|---|---|
| Monday | £36 | £48 | £84 |
| Tuesday | £42 | £39 | £81 |
| Wednesday | £30 | £51 | £81 |
| Thursday | £45 | £44 | £89 |
| Friday | £58 | £62 | £120 |
| Whole week | £211 | £244 | £455 |
Key words. A comparison says how much more or how much less one value is than another. The difference is found by subtracting the smaller value from the bigger one.
Method. Read the Wednesday row, then subtract the lemon sales from the chocolate sales.
- Find the Wednesday row. Each row is one day.Wednesday
- Read the two numbers. Chocolate sales are the third column, and lemon sales are the second column.chocolate £51, lemon £30
- Subtract the smaller number from the bigger one. The difference is how many more chocolate sales there were.£51 − £30 = £21
- Write the answer. £21
Check. £30 + £21 = £51. ✓
Watch out. Subtract the lemon sales from the chocolate sales, so the answer is positive.
| Class | Dogs | Cats | Fish | Rabbits | All pets |
|---|---|---|---|---|---|
| 5A | 3 | 5 | 8 | 2 | 18 |
| 5B | 4 | 6 | 3 | 1 | 14 |
| 5C | 2 | 7 | 6 | 4 | 19 |
| 5D | 5 | 4 | 9 | 3 | 21 |
| Whole school | 14 | 22 | 26 | 10 | 72 |
Key words. A table puts information in rows and columns. Read along a row for one item and down a column for one category. A total is the sum of a row or a column.
Method. Read the total cats row for the whole school, from the bottom row of the table.
- Find the bottom row. The bottom row is the total for the whole school.Whole school
- Find the Cats column. It is the third number column.Cats
- Read the number. The total for cats is already added up for you.22
- Write the answer. 22 cats
Check. 5 + 6 + 7 + 4 = 22, which matches the table. ✓
Watch out. Check the total with the four classes.
| Pet | Number |
|---|---|
| Dogs | ? |
| Cats | 6 |
| Fish | 2 |
| Rabbits | 5 |
| Total | 19 |
Key words. A table puts information in rows and columns. Read along a row for one item and down a column for one category. A total is the sum of a row or a column.
Method. Subtract the known values from the total to find the missing one.
- Look at the total. The total of all the pets is 19.total = 19
- Add the numbers we know. These are the values that are in the table.6 + 2 + 5 = 13
- Take the known total away from the total. The missing number is what is left over.19 − 13 = 6
- Write the answer. Dogs = 6
Check. 13 + 6 = 19, so the total is right. ✓
Watch out. A missing value is not a total: work it out from the total and the other values.
| Day | Lemon sales | Chocolate sales | Total sales |
|---|---|---|---|
| Monday | £36 | £48 | £84 |
| Tuesday | £42 | £39 | £81 |
| Wednesday | £30 | £51 | £81 |
| Thursday | £45 | £44 | £89 |
| Friday | £58 | £62 | £120 |
| Whole week | £211 | £244 | £455 |
Key words. A table puts information in rows and columns. Read along a row for one item and down a column for one category. A total is the sum of a row or a column.
Method. Compare the two columns in every row, then pick out the days where lemon is bigger.
- Compare lemon and chocolate on each day. Look for the days when the lemon number is bigger.Monday: 36 vs 48, Tuesday: 42 vs 39, Wednesday: 30 vs 51, Thursday: 45 vs 44, Friday: 58 vs 62
- Pick out the days where lemon is bigger. Lemon is bigger on Tuesday (42 is more than 39) and Thursday (45 is more than 44).Tuesday and Thursday
- Write the answer. Tuesday and Thursday
Check. On Monday, Wednesday and Friday chocolate sales were bigger. ✓
Watch out. Compare the two numbers in the same row.
Key words. A comparison says how much more or how much less one value is than another. The difference is found by subtracting the smaller value from the bigger one.
Method. Work out the difference between chocolate and lemon on each day, then pick the biggest.
- Find the difference on each day. Subtract lemon from chocolate in each row.Monday: 48 − 36 = 12, Tuesday: 39 − 42 = -3, Wednesday: 51 − 30 = 21, Thursday: 44 − 45 = -1, Friday: 62 − 58 = 4
- Find the biggest difference. Wednesday has the biggest difference, 21.biggest = 21
- Write the answer. Wednesday
Check. The other days have differences of 12, -3, -1, 4. ✓
Watch out. A negative difference means lemon was bigger. Look at the size of the difference.
| Class | Dogs | Cats | Fish | Rabbits | All pets |
|---|---|---|---|---|---|
| 5A | 3 | 5 | 8 | 2 | 18 |
| 5B | 4 | 6 | 3 | 1 | 14 |
| 5C | 2 | 7 | 6 | 4 | 19 |
| 5D | 5 | 4 | 9 | 3 | 21 |
| Whole school | 14 | 22 | 26 | 10 | 72 |
Key words. A table puts information in rows and columns. Read along a row for one item and down a column for one category. A total is the sum of a row or a column.
Method. Add the total pets for each class, then check whether each total is more than 15.
- Find the total for each class. Add the four animals in each row.5A 18, 5B 14, 5C 19, 5D 21
- Check each total against 15. Ali says every class has more than 15 pets.5B has 14, which is not more than 15
- Decide. Ali is not right, because one class has fewer than 15 pets.No
Check. 14 is less than 15, so the statement is false. ✓
Watch out. One class with fewer than 15 pets is enough to show the statement is false.