Back to topics

How can a spreadsheet leave whole countries out of a result?

A spreadsheet formula can look ordinary while quietly skipping entire countries. In a 2013 reanalysis of debt and growth, an omitted range was one problem among several, alongside choices about data and weighting.

5–7 min

Questions you could explore

  • How can an innocent-looking range change a result?
  • Which disagreements remain after a spreadsheet error is fixed?

Start reading

Ready to try your ideas aloud?

Your topic carries over. Record up to 2½ minutes, depending on your plan.

Maths and statistics

When one long wait changes the average

An average wait can sound straightforward until one person waits much longer than everyone else. The mean and median offer two ways to summarize that same group. Their different responses to an unusually large value raise a practical question: what do we want an average to tell us?

5–7 min
Maths and statistics

How is random sampling different from random assignment?

A study can choose people at random, assign them to groups at random, do both, or do neither. Those choices answer different problems: who the findings may describe, and how fairly the study compares conditions.

3–5 min
How can a spreadsheet leave whole countries out of a result? | Speech Topic | speaking.app