Two-Way Tables
On this page
How to read and complete two-way tables, check that the rows and columns add up, and use a table to find probabilities, percentages and the answers to longer problems.
What a two-way table shows
A two-way table sorts one group of people or things in two ways at once. One way runs down the side, in the rows. The other runs across the top, in the columns.
Each cell counts the people or things that fit both its row and its column. In a table of ice creams, the cell in the Tub row and the Mint column counts the ice creams that are mint and in a tub.
The Total column adds along each row. The Total row adds down each column. The number in the bottom right corner is the total of everyone in the table.
In the exam you are usually asked to complete a two-way table using information written in words, for 3 marks. A second part may ask for a probability from the table, for 1 or 2 marks. Some longer problems don't mention a table at all, but drawing one is the clearest way in.
Worked example 1: Reading a cell and a total
The two-way table shows the ice creams a shop sold one afternoon.
(a) How many mint ice creams in a tub were sold?
(b) How many vanilla ice creams were sold altogether?
- (a) Go along the Tub row to the Mint column: the cell is 19
- (b) “Altogether” means a total, so look at the bottom of the Vanilla column.
-
Your turn. How many vanilla ice creams were sold altogether?
The Vanilla column total is 14 + 8 = 22
- Answer: (a) 19 (b) 22
Rows and columns add up
Every row adds up to its row total, and every column adds up to its column total. So a two-way table can always be checked in two directions.
To find a missing number, choose a row or column with only one gap. Take the numbers you know away from its total:
\text{missing number} = \text{total} - \text{the numbers you know}
Only add or subtract numbers that are in the same row or the same column. Adding numbers from different rows and columns gives a number that means nothing.
Worked example 2: Finding missing values
The two-way table shows the bus tickets sold on one journey. Work out the values of x, y and z.
- In the Adult row, 26 + x = 40, so x = 40 - 26 = 14
-
Your turn. In the Single column, 26 + y = 58. Work out y.
y = 58 - 26 = 32
- In the Child row, z = 32 + 15 = 47
- Check: 40 + 47 = 87 and 14 + 15 = 29, so the totals agree.
- Answer: x = 14, y = 32, z = 47
Turning words into a table
- Look at which labels go down the side and which go across the top.
- Put each given number in its cell. A fact such as “12 of the 28 students who chose kayaking are in Year 10” gives two numbers: a total of 28 and a cell of 12.
- Tick off each fact in the question as you use it.
- Find a row or column with only one gap, and fill it by subtraction. Repeat until the table is full.
- Check that every row and every column adds up, and that the total in the bottom right corner is filled in.
Worked example 3: Completing a table from information
There are 72 students on a school trip. Each student chose one activity: climbing, kayaking or archery.
40 of the students are in Year 9 and the rest are in Year 10.
12 of the 28 students who chose kayaking are in Year 10.
20 students chose archery, and 9 of these are in Year 9.
Use this information to complete a two-way table with a row for each activity and a column for each year.
- Put in the given numbers: the total of 72 in the bottom right corner, Year 9 total 40, Kayaking total 28 with 12 in Year 10, and Archery total 20 with 9 in Year 9.
- Year 10 total: 72 - 40 = 32
- Year 9 kayaking: 28 - 12 = 16. Year 10 archery: 20 - 9 = 11
-
Your turn. The Year 9 column has 16 and 9 in it, and its total is 40. How many Year 9 students chose climbing?
40 - 16 - 9 = 15
- Year 10 climbing: 32 - 12 - 11 = 9, so the Climbing total is 15 + 9 = 24
- Answer: the completed table is below. Check: 24 + 28 + 20 = 72
Probability from a table
When one person is chosen at random from a group, each person in that group is equally likely to be picked. Then:
\text{probability} = \frac{\text{number who fit the description}}{\text{number in the group you choose from}}
Read the question carefully to see who can be chosen. “One of these people” means everyone, so divide by the total in the bottom right corner. “One of the women” means only the women, so divide by the women’s total.
Give a probability as a fraction, a decimal or a percentage, never as a ratio such as 1 : 4
Worked example 4: Choosing the right total
The two-way table shows the sandwiches a cafe sold one day.
(a) One of these sandwiches is chosen at random. Find the probability that it is a ham sandwich on brown bread.
(b) One of the sandwiches on brown bread is chosen at random. Find the probability that it is a ham sandwich.
- (a) Any of the sandwiches could be chosen, so divide by the total in the bottom right corner, 80
- There are 20 ham sandwiches on brown bread: \frac{20}{80} = \frac{1}{4}
-
Your turn. (b) Only sandwiches on brown bread can be chosen. How many sandwiches on brown bread are there?
The Brown column total is 48, so divide by 48
- 20 of these are ham: \frac{20}{48} = \frac{5}{12}
- Answer: (a) \frac{1}{4} (b) \frac{5}{12}
Fractions and percentages of a group
To find what percentage of a group fit a description, divide by that group’s total, then multiply by 100. If 18 of the 24 Year 10 students walk to school: \frac{18}{24} \times 100 = 75\%
To compare groups of different sizes, compare percentages, not counts. If 21 of the 35 Year 11 students walk, that is \frac{21}{35} \times 100 = 60\%. More Year 11 students walk, but a smaller percentage of them do.
Some questions give facts as percentages or fractions of a group. Work out each count first, then put it in the table. Check which group each percentage is of: 60\% of the boys is a percentage of the boys’ total, not of everyone.
Worked example 5: Fractions and percentages of groups
A gym has 250 members. Each member goes to the gym in the morning or in the evening.
\frac{2}{5} of the members are men.
30\% of the men go in the evening.
105 women go in the morning.
What percentage of the members who go in the morning are women?
- Men: \frac{2}{5} \times 250 = 100. Women: 250 - 100 = 150
- The 30\% is of the men, not of everyone. Men in the evening: 30\% of 100 = 30
-
Your turn. How many men go in the morning?
100 - 30 = 70 men go in the morning.
- Morning total: 105 + 70 = 175
- Women out of the morning group: \frac{105}{175} \times 100 = 60\%
- Answer: 60\%
When the question gives no table
Some longer questions sort a group in two ways but show no table. Draw your own two-way table. Examiners report that students who did this did better than those who wrote numbers all over the page.
Label the rows and columns, fill in what you are told, then work from a row or column with one gap. You may be told that two cells are equal. If they are the only two gaps in a row or column, work out what they add up to, then halve it.
Worked example 6: A problem with no table given
There are 90 people at a sports centre. Each person chose one class: yoga, spin or boxing.
50 of the people are women. The rest are men.
12 of the 30 people who chose spin are men.
8 women chose boxing.
Equal numbers of men chose yoga and boxing.
Work out the total number of people who chose yoga.
- Draw a two-way table with the classes down the side, Women and Men across the top, and totals.
- Men: 90 - 50 = 40. Women who chose spin: 30 - 12 = 18
- Women who chose yoga: 50 - 18 - 8 = 24
- Men who chose yoga or boxing: 40 - 12 = 28
-
Your turn. These 28 men are split equally between yoga and boxing. How many men chose yoga?
28 \div 2 = 14 men chose yoga.
- Answer: 24 + 14 = 38 people chose yoga.
Common mistakes
- Putting a number in the wrong cell. Find its row and its column before you write it in, and tick off each fact as you use it.
- Not checking the totals. Check that every row and every column adds up; if one doesn’t, find the slip.
- Leaving the bottom right corner blank. Fill in the total there too.
- Adding numbers from different rows and columns. Only add or subtract numbers in the same row or column.
- Dividing by the wrong total. For a probability, divide by the number in the group that can be chosen.
- Writing a probability as a ratio. Give it as a fraction, a decimal or a percentage.
More on this topic: Two-Way Tables worksheet with full solutions