Procedure
Totalling the rows or columns of a data table
Statistics • Data Interpretation • Table
Statement
In a table whose rows and columns are two classifications of the same quantity, the total for one category of either classification is the sum of the entries along its row or column; comparisons between categories, differences between them and percentage changes are then made on those totals, or on sums of selected entries where the question names them.
How to use it
- 1Decide first whether the question is about rows or about columns, and total only those the options name.
- 2Add the totals the other way as a check: the sum of the row totals must equal the sum of the column totals.
- 3For a difference between two totals, subtract entry by entry and add the differences; it avoids two long sums.
- 4When the options are close, compute each total exactly; a single slip reverses the order.
Worked example
A shop's sales (in units) are: Pens and Pencils in the months Jan, Feb, Mar. Which month had the larger total sales, Jan or Mar, and by how much?
Step-by-step
- 1Jan: ; Mar:
Why: A month's total is the sum of its column across both products.
- 2
- 3Check entry by entry:
Why: The difference of totals equals the sum of the entry differences.
Answer
March, by units
Watch out
Totalling the wrong direction — rows when the question asks about columns — gives a plausible-looking answer to a different question. A percentage change between totals is taken on the earlier or named base total, not on the sum of the percentage changes of the entries.