Two-way tables (Edexcel GCSE Statistics): Revision Notes
Two-way tables
What is a two-way table?
A two-way table is a mathematical tool that displays information about two different categories of data simultaneously. These tables are particularly useful when you want to compare how two variables relate to each other. The data shown in two-way tables is called bivariate data because it involves two variables.
In a two-way table, one category is typically shown across the top (columns) whilst the other category runs down the side (rows). Each cell in the table shows how many items belong to both categories at once.
Two-way tables are also known as contingency tables or cross-tabulation tables in statistics. They provide a clear visual way to analyse the relationship between two categorical variables.
Understanding the structure
Two-way tables always include several essential components that work together to present the complete picture:
- Rows representing one category (e.g., age groups like Adult/Child)
- Columns representing another category (e.g., preferences like custard/cream)
- Individual cells showing the count for each combination
- Row totals showing the total for each row
- Column totals showing the total for each column
- Grand total showing the overall total in the bottom-right corner
When you look at any two-way table, some values will be provided whilst others need to be calculated using addition or subtraction.
The grand total is crucial for checking your work - it can be calculated by adding either all row totals OR all column totals. If these don't match, you've made an error somewhere.
Reading and interpreting two-way tables
Understanding how to extract information from two-way tables is a fundamental skill that requires careful attention to what the question is asking.
When interpreting the data, you can extract specific information such as:
- How many people chose a particular option (look at individual cells)
- How many people were in each category (look at totals)
- Which option was more popular overall (compare column totals)
The key is to always read carefully what the question is asking and locate the correct cell or total in the table.
Completing missing values in two-way tables
The most common exam questions involve filling in missing numbers. Here's the systematic approach that will help you tackle any two-way table problem:
Step 1: Start with what you know
Begin by identifying all the values that are already given in the table. Write these down clearly - this prevents confusion and helps you see what's missing.
Step 2: Look for easy calculations
Find rows or columns that have only one missing value. These can be completed using simple addition or subtraction:
- If you know the total and all but one value, subtract to find the missing number
- If you know some values but need the total, add them up
Step 3: Use the relationships between totals
Remember that:
- Row totals must equal the sum of all values in that row
- Column totals must equal the sum of all values in that column
- All row totals added together must equal the grand total
- All column totals added together must equal the grand total
Step 4: Work systematically
Don't try to solve everything at once. Complete one missing value, then use that to help find the next one. This methodical approach prevents errors and builds confidence.
Worked example walkthrough
Worked Example: Completing a News Source Survey Table
Problem: A group of 53 students were asked about their main source of news - TV or internet. There were 32 boys and 21 girls in the group. Of all students, 18 boys said TV was their main source.
Step 1: Set up the basic structure Create your table with the given totals. We know there are 53 students total, 32 boys, and 21 girls.
Step 2: Fill in the known values Place the value 18 in the "Boys/TV" cell since we're told 18 boys prefer TV.
Step 3: Calculate missing values in the boys row Since there are 32 boys total and 18 prefer TV, then 32 - 18 = 14 boys prefer internet.
Step 4: Calculate missing values in the girls row We know there are 21 girls total. We need to find how many prefer TV and how many prefer internet.
Step 5: Use column totals Calculate the totals for each news source by adding up the completed values.
Step 6: Verify your answer Check that all your totals add up correctly - this is crucial for avoiding errors.
Problem-solving strategies
Always check your work
After completing a two-way table, verify that:
- Each row total equals the sum of values in that row
- Each column total equals the sum of values in that column
- The grand total can be calculated by adding either all row totals or all column totals
This verification step catches most arithmetic errors before you submit your answer.
Work with the easiest calculations first
Look for rows or columns where only one value is missing - these are your starting points. Building momentum with easy calculations gives you confidence and provides values you can use in more complex calculations.
Use logic and elimination
Sometimes you can work backwards from totals to find missing values, especially when multiple values are unknown. If you know three out of four values in a calculation, the fourth is always determinable.
Common exam tips and traps
Understanding common mistakes can help you avoid them and maximise your marks in examinations.
Exam tip 1: Read the question carefully
Make sure you understand what categories are being compared and what the question is actually asking for. Many students lose marks by providing correct calculations but answering the wrong question.
Exam tip 2: Show your working
Always show how you calculated missing values - this can earn you marks even if your final answer is incorrect. Examiners can award partial credit for correct methods.
Exam tip 3: Give context in your answers
When answering questions about the data, don't just give a number. Explain what that number represents in the context of the problem.
Common trap: Forgetting to check totals
Students often make arithmetic errors when completing tables. Always verify that your totals are consistent - this simple check can save you from losing easy marks.
Common trap: Misreading the table
Make sure you're looking at the correct row and column intersection when extracting information. A common error is reading from the wrong cell, especially in larger tables.
Key Points to Remember:
- Two-way tables show relationships between two categories of data (bivariate data)
- Always start with the values you know and work systematically through missing numbers
- Use addition and subtraction with row and column totals to find missing values
- Check that all your totals are consistent - row totals should add to the grand total, and so should column totals
- Give your answers in context and show your working clearly in exams
- Work with the easiest calculations first to build momentum
- Verify your completed table by checking that all totals are mathematically consistent