Should a missing measurement be entered as zero before we calculate the average?
EducationIn a made-up data exercise, two readings are 8 and 10 and the third was not obtained. My partner filled the empty cell with zero so the column would look complete. Our Excel average changed from 9 to 6.
Microsoft's AVERAGE documentation says empty cells in a referenced range are ignored while zero values are included. That explains the software, but not what we should do with the missing reading.
How should we present this exercise? We do not know that the unobserved value was zero, and I do not want a tidy column to turn that uncertainty into a measurement.