Lesson 2: Two-way frequency tables
Build a two-way frequency table from raw data
SkillTwo-way frequency tables
Worked example
Twenty senior students were asked their year level and where they do most of their study: home (H), library (L) or school (S). Their responses were
11H, 12L, 11H, 11S, 12H, 11L, 12L, 11H, 12S, 11H, 12L, 11L, 11H, 12H, 11S, 12L, 11H, 12S, 11L, 12H.
Construct a two-way frequency table with row and column sums.
Step 1: Set up the table
Put one variable down the side (year level) and the other across the top (study location). Add a Total column and a Total row.
Either variable can go down the side. Putting the explanatory variable (year level) in the rows makes the next lesson's percentages easier to read.
Step 2: Tally each response into its cell
Work through the list once, making a tally mark in the cell for each response. Counting the tallies:
- Year 11: home 6, library 3, school 2
- Year 12: home 3, library 4, school 2.
Step 3: Find the row sums
Year 11: . Year 12: .
Step 4: Find the column sums and check the grand total
Home: . Library: . School: .
The row sums give and the column sums give . Both match the 20 students surveyed.
If the two grand totals disagree, or don't match the number surveyed, a response was missed or counted twice.
Answer
| Year level | Home | Library | School | Total |
|---|---|---|---|---|
| Year 11 | 6 | 3 | 2 | 11 |
| Year 12 | 3 | 4 | 2 | 9 |
| Total | 9 | 7 | 4 | 20 |
Try a similar one
A fresh question of the same kind, checked as you answer, with hints and a full solution.
Method
Put one variable's categories down the side and the other's across the top, with Total row and column.
Tally each individual into exactly one cell.
Add across for row sums and down for column sums.
Check both routes give the same grand total, equal to the number surveyed.
Watch out for
Skipping a response or counting one twice. Cross each response off as you tally it.