Distinguishing missing from zero

Zero by Mecklenburg County, Attribution-NonCommercial License

Last year we talked about the importance of not ignoring missing data. This means we have to be careful how we record data so that we know when data is really missing and can distinguish that from a result of zero. Jonathan Callahan gives some good examples of the difference in this post and shows you how you should handle each in Excel.

Zero vs. Missing. http://mazamascience.com/WorkingWithData/?p=343


Leave a comment

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s