Skip to content
IGCSE·Tuition
Global Perspectives · Lessons

Communicate missing data without inventing values

A blank cell in a table is awkward, and filling it with a guess is tempting.

On this page
  1. What should you do with a gap?
  2. Worked example (fictional)
  3. What is the common mistake?
  4. Check yourself
  5. Where does this lead next?

When a table has gaps, you report what the data show, mark exactly what is missing and limit your claims to what remains. This comes up whenever a source says “no data”, “not reported” or leaves a cell blank.

It completes the module on data interpretation and limitations and builds on justified causal claims. Every figure below is invented.

What should you do with a gap?

  1. Find it. Scan every row and column. Note which cells are blank or marked “n/a”.
  2. Ask why. Was nothing collected, was it withheld, or did it truly equal zero? A zero and a blank are different.
  3. Keep it visible. Show the gap as “not reported”, never as a made-up number.
  4. Limit the comparison to rows and years where the data exist.
  5. Say what changes. Explain how the gap weakens or limits the conclusion.

Worked example (fictional)

A made-up table gives tonnes of recycled waste collected.

District (fictional)202120222023
A120130140
B9095100
C60not reported75

Question: Did recycling rise in every district?

What the data show: A rose from 120 to 140 and B from 90 to 100. C rose from 60 (2021) to 75 (2023).

What is missing: C’s 2022 figure.

What you can say: “Between 2021 and 2023 recycling was higher in all three districts. District C did not report 2022, so its year-by-year trend is unknown.”

What you cannot say: that C rose steadily. The missing year could have been higher or lower than both neighbours.

What is the common mistake?

Mistaken answer: “C probably collected 67 tonnes in 2022, so the total for 2022 was 292 tonnes.”

The student filled the gap with the average of 60 and 75 (67.5, rounded) and then added it to the reported figures as though it were real. The correction is to report the 2022 total for A and B only, which is 130 + 95 = 225 tonnes, and state that C is excluded.

Check yourself

All data are fictional.

1. For 2021, what is the total for districts A, B and C in the table above?

Show answer

120 + 90 + 60 = 270 tonnes. All three districts reported for 2021, so this total is complete.

2. Write one sentence reporting the 2022 total honestly.

Show answer

“In 2022 districts A and B collected 225 tonnes in total (130 + 95); District C did not report, so a three-district total is not available.”

3. A survey table shows “0” for one question and a blank for another. How should you treat them?

Show answer

“0” is a recorded value (nobody chose it). A blank means no information. Do not treat the blank as zero. Report it as missing and ask why if possible.

Where does this lead next?

You now have four tools: rates, sample questions, cautious causal wording and honest gaps. Combine them in the integrated practice set, or go back to the module overview to plan revision.

A teacher can help you practise writing limitation sentences that are short and exact, which is part of online one-to-one Global Perspectives tuition.

Questions people ask

Why should I not fill in a missing value?

A guessed value looks like a measurement but is not one. Readers cannot tell it apart from real data, so errors spread into your totals and comparisons. Showing the gap keeps your work honest and lets the reader judge for themselves.

Can I estimate if I clearly say so?

Sometimes an estimate is reasonable, but only if you label it as an estimate, give the method and keep it separate from reported figures. In small exercises, the safer choice is to report what exists and say what is missing.

How do I write about a gap without sounding unsure of everything?

Use one precise sentence: what is missing, why it matters and what you can still say. For example: 'District C reported no figure for 2022, so the trend is shown for A and B only.' Precision sounds confident.

Updated:

Your next step

If gaps in data make you nervous about drawing any conclusion, a one-to-one teacher can show how to say exactly what remains supportable.

Paid one-hour trial at your assigned teacher’s confirmed rate, starting from RM80. Other fees, schedules and ongoing arrangements are confirmed directly with your teacher after the trial class.

Tuition is arranged with a parent or guardian. Send them this page on WhatsApp and they can enquire for you.

Parent or guardian? Enquire here

9,000+ students helped through our service