Why the missing data is the most informative column
Absence has a shape. Which records lack a value is usually related to what the value would have been, so dropping them changes the population.
Filed by The Archivist 2 min read
Intuition test — answer before you read on
Why can dropping incomplete records bias an analysis rather than merely shrink it?
Correct answer: B
Option A describes precision, not bias. Option C is an unrelated data-quality claim. Deleting incomplete cases costs only precision when data are missing completely at random but biases estimates when they are not, and the common fixes of case deletion and mean substitution perform poorly, with mean substitution understating variance.
The salary column is eighty-one per cent complete and the analysis quietly uses those rows. The nineteen per cent are not scattered at random: they are the contractors, the recent joiners and the two grades where disclosure is optional, and the reported average now describes a different company.
What everyone sees
Missing values are treated as a nuisance affecting precision — a smaller effective sample, handled by excluding incomplete rows. Exclusion is not neutral. If whether a value is present depends on what the value is, then complete-case analysis selects the sample on the variable of interest, which is the one operation guaranteed to bias it.
What is actually happening
Little and Rubin set out the distinction that governs this: under data missing completely at random, dropping incomplete cases costs precision only, whereas under data missing not at random the estimate itself is biased, and the pattern of missingness is informative about the omitted values. Schafer and Graham reviewed practice and found that the two most common approaches — deleting incomplete cases and substituting the column mean — perform poorly under realistic assumptions, with mean substitution actively understating variance and manufacturing false precision. The instructive move is to treat missingness as data: model which records are incomplete, because that indicator often predicts the outcome better than the surviving values do.
Why it stays hidden
The bias hides because software handles it silently. The default is to drop incomplete rows, no warning is printed, and the output reports an n that looks like the sample. Anyone reading the results sees a clean table, and the only trace of the excluded population is a number that was never shown.
If presence depends on the value, dropping incomplete rows selects on the variable of interest. Model the missingness — it is often the better predictor.
If presence depends on the value, dropping incomplete rows selects on the variable of interest. Model the missingness — it is often the better predictor.
Collect this card
If presence depends on the value, dropping incomplete rows selects on the variable of interest. Model the missingness — it is often the better predictor.
0 / 10,000 collected
Sources & further reading 2
- Little & Rubin — statistical analysis with missing data
- Schafer & Graham — missing data: our view of the state of the art
Cross-references
Related files
Filed near this one in the index.
-
No visual on fileStatistical Illusions Entry #0437
The reason a study that replicates is worth two that do not
A single study is a claim. A replication is a test of that claim. Two unreplicated studies are two untested claims, not twice the evidence.
AdeptThe hidden part #0437Novelty fills journals. Replication fills knowledge. The incentive structure rewards the wrong one.
Statistics Open file -
No visual on fileStatistical Illusions Entry #0434
Why a percentage change needs its starting point
A fifty per cent increase from two is one. A fifty per cent increase from two million is one million. The percentage is identical; the meaning is not.
AdeptThe hidden part #0434A percentage without a base is not a statistic. It is a frame looking for a denominator the reader will supply.
Statistics Open file -
No visual on fileScarcity & Queues Entry #0462
The reason an invitation raises acceptance more than an offer
An offer says the item is available. An invitation says the recipient was selected. The difference is not in the item but in the identity it assigns.
AdeptThe hidden part #0462An offer presents a product. An invitation presents an identity. People accept identities faster than products.
Scarcity Open file -
No visual on fileScarcity & Queues Entry #0458
The reason an expiring discount beats a larger permanent one
A permanent reduction can be acted on at any time, which means it can be postponed indefinitely. A deadline converts an intention into a dated task.
AdeptThe hidden part #0458An open offer can be postponed forever. The deadline is not pressure; it is the thing that gives the intention a date.
Scarcity Open file
Annotations are reserved for archive members.
Sign in to annotate