Two-way tables organize data from two categorical variables so patterns can be compared clearly. They are also called contingency tables because they show how the count in one category depends on the category of another variable. These tables matter because they turn raw survey or experiment results into counts, totals, and percentages that are easy to interpret.
They are common in biology, social science, medicine, business, and classroom data projects.
A two-way table has interior cells for joint counts, row totals and column totals for marginal counts, and a grand total for the whole data set. Conditional percentages compare part of a row or column to that row or column total, which helps answer questions like what percent of students who play a sport also study music. Joint percentages compare a cell to the grand total, while marginal percentages compare a row or column total to the grand total.
Reading the table carefully helps separate overall patterns from patterns within a subgroup.
Key Facts
- A joint count is an interior cell count that belongs to one row category and one column category.
- A marginal count is a row total or column total found on the edge of a two-way table.
- Grand total = sum of all joint counts = sum of row totals = sum of column totals.
- Joint percentage = joint count / grand total × 100%.
- Row conditional percentage = cell count / row total × 100%.
- Column conditional percentage = cell count / column total × 100%.
Vocabulary
- Two-way table
- A table that displays counts for two categorical variables by arranging one variable in rows and the other in columns.
- Contingency table
- Another name for a two-way table, often used when studying whether two categorical variables are related.
- Joint count
- The count in an interior cell showing how many observations fall into both a specific row category and a specific column category.
- Marginal count
- A row total or column total that summarizes one category of a single variable.
- Conditional percentage
- A percentage found by dividing a cell count by a specific row total or column total.
Common Mistakes to Avoid
- Using the grand total for every percentage is wrong because conditional percentages require a row total or column total as the denominator.
- Mixing up row percentages and column percentages is wrong because they answer different questions about different subgroups.
- Adding percentages from different denominators is wrong because the percentages are based on different totals and are not directly combinable.
- Treating a large count as a strong relationship is wrong because the row or column total may also be large, so percentages must be compared.
Practice Questions
- 1 A survey of 100 students records sport participation and music participation. The table counts are: Sport and Music = 18, Sport and No Music = 22, No Sport and Music = 12, No Sport and No Music = 48. Find the row totals, column totals, and grand total.
- 2 Using the same table, find the percentage of students who play a sport given that they study music, and the percentage of students who study music given that they play a sport.
- 3 In the survey table, 45% of students who study music play a sport, while 31.4% of students who do not study music play a sport. Explain whether sport participation and music participation appear related, and support your answer with conditional percentages.