Lesson 3: Percentaged two-way tables
Percentage a table with the explanatory variable in the columns
SkillsPercentaging two-way tablesExplanatory and response variables
Worked example
A Queensland council surveyed 300 residents about a proposed off-leash dog park, recording each resident's age group and opinion.
| Opinion | 18–39 | 40–59 | 60 and over | Total |
|---|---|---|---|---|
| Support | 72 | 48 | 24 | 144 |
| Oppose | 30 | 38 | 44 | 112 |
| Unsure | 18 | 14 | 12 | 44 |
| Total | 120 | 100 | 80 | 300 |
(a) Identify the explanatory variable.
(b) Construct an appropriately percentaged table.
Step 1: Identify the explanatory variable
A resident's age group may explain their opinion, not the other way round, so age group is the explanatory variable and opinion is the response variable.
Step 2: Find where the explanatory variable is
The age groups are the columns, so percentage down each column, dividing by the column sums 120, 100 and 80.
Step 3: Calculate the 18–39 column
, and .
Step 4: Calculate the other two columns
40–59: , and .
60 and over: , and .
Step 5: Check each column adds to 100%
, and .
Answer
(a) Age group.
(b) Column percentages:
| Opinion | 18–39 | 40–59 | 60 and over |
|---|---|---|---|
| Support | 60% | 48% | 30% |
| Oppose | 25% | 38% | 55% |
| Unsure | 15% | 14% | 15% |
| Total | 100% | 100% | 100% |
Try a similar one
A fresh question of the same kind, checked as you answer, with hints and a full solution.
Method
Identify the explanatory variable and whether its categories are the rows or the columns.
Divide each count by its category's total (here, the column sum) and multiply by 100%.
Check each category adds to 100%.
Watch out for
Dividing by the row sums, e.g. . That is the percentage of supporters who are aged 18–39, which depends on how many residents of each age group were surveyed.