Recent chats

How can a table’s total be checked against its entries?

Quick answer

Add the entries that are supposed to account for the displayed total, then compare your sum with that total. For example, if the entries are 12, 7, and 9, their sum is 28; a displayed total of 30 does not match. Report both figures plainly. The mismatch shows an inconsistency, but it does not by itself reveal its cause.

LET’S WORK THROUGH IT

The question, the details, the next step.

Question

What’s a straightforward way to check whether a table’s total agrees with the entries? I don’t want to overcomplicate it.

Geez

First check what the total is meant to represent. If it is meant to be the sum of the listed entries, add those entries and compare your result with the displayed total. For a frequency table, the entries may be counts that together account for all responses; OpenStax describes checking such tables by adding the frequencies and comparing their sum with the known response count. [S1]

Use a small invented example:

  • Item A: 12
  • Item B: 7
  • Item C: 9
  • Displayed total: 30

Add the three counts: 12 + 7 + 9 = 28. Since 28 is not 30, the entries and displayed total do not match. This arithmetic check identifies a mismatch; it does not explain why one appears.

Follow-up question

How do I know which numbers to add? A table can have labels, percentages, and a total in it.

Geez

Follow the table’s layout and labels, and add only the values that are supposed to contribute to the particular total you are checking. If the total is for one column of counts, add the counts in that column—not the labels, a separate percentage column, or another total. If the headings do not make clear which entries belong together, pause and ask what the displayed total covers instead of choosing a group by guesswork.

Also check whether the entries are intended to account for the whole total. A total of all responses is not necessarily meant to equal a subtotal for just one category. The check described for frequency tables applies when the frequencies should account for a known number of responses; it does not mean every kind of table should be checked by adding every visible number. [S1]

Follow-up question

Could you walk through the arithmetic and show how to describe a mismatch without claiming to know what caused it?

Geez

For the example, write the calculation before interpreting it:

  1. Entries being checked: 12, 7, and 9.
  2. Computed sum: 12 + 7 + 9 = 28.
  3. Displayed total: 30.
  4. Comparison: 28 does not equal 30; the difference is 2.

A careful report would be: “The listed counts add to 28, while the table displays a total of 30. These figures do not match.” You can mention the difference, but avoid saying that a row was omitted, a value was typed incorrectly, or a formula failed unless you have separate evidence. The arithmetic check supports identifying the discrepancy, not determining its cause. [S1]

Follow-up question

What if I get the same total, or I’m not sure whether I copied a number correctly?

Geez

If your sum matches, say that the entries you checked add to the displayed total. That confirms this particular arithmetic comparison, not every feature or meaning of the table. If you are unsure about a copied value, check it against the original table and redo the addition; keep the entries and displayed total visible in your notes so another reader can follow the check.

Reusable note:

“Entries checked: [list]. Computed sum: [sum]. Displayed total: [total]. Result: [matches / does not match].”

If it does not match, report the two figures and leave the explanation open until someone checks the underlying table or calculation.

A practical checklist

  • Identify the displayed total you want to check.

  • Confirm which entries are intended to make up that total.

  • Copy those entries carefully, keeping labels beside them.

  • Add the entries and write down the computed sum.

  • Compare the computed sum with the displayed total.

  • Report both figures and whether they match; do not guess at a cause.

A few more useful answers

If the numbers match, does that prove the whole table is correct?

No. It shows that the entries you added agree with that displayed total. It does not establish that the labels, source data, or other parts of the table are correct.

Should I add percentages to check a count total?

Not unless the total is specifically meant to combine those percentages. Check the table’s labels and determine which entries belong to the total before adding.

What should I say if the sum is different?

State the entries’ computed sum and the displayed total, then say they do not match. The difference alone does not tell you why.

Sources

References used for this guide.

  1. [S1] OpenStax Contemporary Mathematics: Gathering and Organizing Data
    openstax.org · Checked

YOUR QUESTION. YOUR DETAILS.

Let’s work through your situation.

Get a tailored answer or help with your next task. Starts at $1, with a quote before you pay.

Ask your own question
← Back to Geez at Work