Organized Tables (for two facts) · Extra learning part 2
Explore, explain, practice and check your understanding.
Recover a missing row total
Compare the new example with the previous part and change the model.
Understand the idea
An empty cell marked A or B can stand for a row total, not a missing survey response. Read the table labels, then add all cells in that row to fill the total.
Worked example
Three classes borrow 11, 8, and 7 story books: the story-books total is 26.
Explore and observe
Change the matrix model at least once and notice how the answer responds.
What changed in the model? An empty cell marked A or B can stand for a row total, not a missing survey response.
A table row total is 26. Two cells are 11 and 8. What is the missing cell?
A table row total is 14. Two cells are 2 and 3. What is the missing cell?
Recover a missing column total
Compare the new example with the previous part and change the model.
Understand the idea
Add all categories within one class to get the class total. This is a vertical calculation and must not be confused with the horizontal total for one category.
Worked example
Class 2 has 8 story, 3 reference, and 7 other borrowers: 8 + 3 + 7 = 18.
Explore and observe
Change the matrix model at least once and notice how the answer responds.
What changed in the model? Add all categories within one class to get the class total.
For Class 3, the table cells are 7 Story, 9 Reference, and 6 Other books. What is the column total?
For a second survey, Class 1 has 10 Story, 4 Reference, and 6 Other book borrowers. What is its column total?
Check the grand total twice
Compare the new example with the previous part and change the model.
Understand the idea
The bottom-right grand total counts every observation once. You can add row totals or column totals. Matching answers give a valuable check against double counting or an omitted cell.
Worked example
Across categories 26 + 14 + 17 = 57; adding the three class totals must also give 57.
Explore and observe
Change the matrix model at least once and notice how the answer responds.
What changed in the model? The bottom-right grand total counts every observation once.
The three row totals are 26, 14, and 17. What is the grand total?
The three class totals are 17, 18, and 22. What is the grand total?
Answer a two-attribute question
Compare the new example with the previous part and change the model.
Understand the idea
A two-way table can ask for the boys in Class 3, the total girls across classes, or the difference between boys and girls in Class 2. Read the question to choose a cell, row sum, or subtraction.
Worked example
In the Story-books row, the Class 3 cell is 7, while the row total is 26.
Explore and observe
Change the matrix model at least once and notice how the answer responds.
What changed in the model? A two-way table can ask for the boys in Class 3, the total girls across classes, or the difference between boys and girls in Class 2.
Reference books have counts of 3 and 9 in two classes. How many more are in the class with 9?
The cell at the Story books/Class 3 intersection is 7; the row total is 26. What is the cell value?
Lesson final test
Answer each question. Your score and explanations appear at the end.