Distinguishing missing from zero

33357235340_2387d0dc73_z
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

Advertisements

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