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

  • Simple familiar
  • Technology active

A Queensland council surveyed 300 residents about a proposed off-leash dog park, recording each resident's age group and opinion.

Opinion18–3940–5960 and overTotal
Support724824144
Oppose303844112
Unsure18141244
Total12010080300

(a) Identify the explanatory variable.

(b) Construct an appropriately percentaged table.

1 of 5 steps
  1. 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.

Try a similar one

A fresh question of the same kind, checked as you answer, with hints and a full solution.

Method

  1. Identify the explanatory variable and whether its categories are the rows or the columns.

  2. Divide each count by its category's total (here, the column sum) and multiply by 100%.

  3. Check each category adds to 100%.

Watch out for

  • Dividing by the row sums, e.g. 72144×100%=50%\frac{72}{144} \times 100\% = 50\%. That is the percentage of supporters who are aged 18–39, which depends on how many residents of each age group were surveyed.

Save your progress with a free account