A zero usually means the measured amount was none. A blank, dash or special code may mean the value was not collected, not reported or not applicable. When a system turns missing values into zeros, it changes the story the data tells.
Imagine a clinic recording the number of visits for each day. A true zero means the clinic was open and saw no patients. A blank may mean the form never arrived. Averaging both as zeros makes activity look lower than the available records support.
Missingness can also follow a pattern. People may skip an income question because it feels sensitive, or small organizations may be less able to file reports. If the missing cases differ from the recorded ones, deleting them can bias the result as surely as replacing them with zeros.
Read the data dictionary and methodology. Well-documented files explain codes such as 0, -1, N/A and suppressed. Suppression protects privacy or avoids publishing unstable estimates; it does not necessarily mean the underlying count is zero.
When reporting a result, state how much data is missing and how it was handled. Separate “no events recorded” from “no data available.” That small distinction prevents a technical placeholder from becoming a factual claim.
Original educational commentary by Breaking Click. This explainer is designed to help readers evaluate information more carefully.



