Marginal Totals in Two-Way Tables

Why Marginal Totals Matter

A two-way table organizes counts according to two categorical variables. Each interior cell records the number of cases in one combination of categories. But questions often ask about just one variable: How many respondents chose the bus, regardless of their class year? How many chose morning appointments, regardless of their reminder type? Adding the relevant cells gives an overall category count, also called a marginal total.

The word “marginal” refers to the totals placed along the outer edge, or margin, of a table. These totals make the table easier to summarize and provide a basic arithmetic check. They do not show how the cases in a category are distributed across the other variable; that detail remains in the interior cells.

Calculating the Margins

To calculate a row total, add the counts across that row, including every column category. To calculate a column total, add the counts down that column, including every row category. The grand total can be found by adding all the interior cells or by summing either set of marginal totals. A complete table places row totals beside the rows, column totals below the columns, and the grand total in the lower-right corner.

Suppose \(n_{ij}\) denotes the count in row \(i\) and column \(j\), with \(r\) row categories and \(c\) column categories. Then the total for row \(i\) is the sum of its cell counts, and the total for column \(j\) is the sum of its cell counts. The grand total is the sum over all cells.

Here \(N\) is the grand total. A row total answers how many cases fall in that row category across all column categories; a column total answers how many fall in that column category across all row categories. Neither is the count in just one interior cell.

Why the Two Grand Totals Must Agree

The equality between the two ways of calculating the grand total is not a coincidence. Each case in the table contributes exactly once to the total for its row and exactly once to the total for its column. Summing all row totals therefore counts every interior cell once. Summing all column totals also counts every interior cell once. Both procedures add the same set of cell counts.

For a table with \(r\) rows and \(c\) columns, write the row total for row \(i\) as \(\sum_{j=1}^{c} n_{ij}\). Adding all row totals gives:

The middle expression adds every cell in the table. The first expression groups those cells by row; the last groups them by column. Since addition does not depend on the order in which the same counts are grouped, both margin sums equal the grand total \(N\). If the row totals and column totals do not sum to the same number, at least one count or calculation needs checking.

Assumptions Behind the Totals

The arithmetic is simple, but interpreting the margins correctly depends on how the table was defined. For a count table to summarize its stated cases, each case should contribute to exactly one cell: it belongs to one category of the row variable and one category of the column variable. The categories must cover the cases being counted, and a case should not be counted twice. If a table is intended to include all cases in a defined group, the grand total should match the number of cases in that group.

Sometimes a table deliberately describes only a subset of cases. For example, it may include only completed visits, rather than every scheduled visit. Then its grand total is the number of included visits, not necessarily the number originally scheduled. The table’s scope needs to be clear before a grand total is interpreted.

What Margins Preserve—and What They Leave Out

Margins are useful because they answer questions about each variable separately. In the study-location example, the row margins report the overall counts for each location, while the column margins report the overall counts for each class year. These summaries are often exactly what is needed when the question concerns a single category without regard to the other variable.

However, margins alone discard the details of how categories overlap. The three row totals and three column totals do not tell us the count in every location-by-year combination. Different interior tables can have the same margins. When the question concerns combinations of categories, use the relevant interior cell rather than a margin. When the question asks about overall counts for one variable, use the corresponding row or column margin.

Marginal totals are counts, measured in cases such as students, visits, or people. They are not percentages. A margin can serve as the count needed for later calculations, but a proportion requires a specified denominator and a division step. The choice of denominator depends on the question, so an overall category count should not be described as a proportion.

Common Mistakes

• Using one cell as the overall category count. A cell describes a combination of two categories. To count everyone in one row or column category, add all cells along that row or column.
• Adding only part of a row or column. A marginal total includes every category of the other variable in the table. Leaving out a column or row produces an incomplete total.
• Adding the row totals and column totals together. Each set separately sums to the grand total. Adding both sets together counts every case twice.
• Ignoring a mismatch. If the row margins and column margins have different sums, or if they disagree with the stated number of cases, check the cells and the scope rather than forcing the numbers to agree.
• Calling a count a percentage. A total such as 26 visits is a count. It is not a percentage unless it has been divided by an appropriate denominator and expressed as a proportion or percent.