How often do you get data that needs to be charted or graphed only to find out some of the data’s missing? We see it all the time. However, just because it’s missing, doesn’t mean you can ignore it. You need to know how to make it consistent, how to deal with it if it is missing, or sometimes even how to recover it. In this 9:12 video, the fourth in our series on well-formed data for charts & graphs, we cover:
- types of missing data
- differences between incomplete, space, blank/null, and 0 data
- dealing with missing text
- dealing with missing numbers
- dealing with implied data
Let me know what you think!
Also, be sure to check out the other 3 videos in this series:
Part 1: Consistency (9:43)
Part 2: Concatenation & Extraction (9:57)
Part 3: Normalization (8:52)
Part 4: Missing Data (9:12)
Next up, more tips on using PowerPoint to create a visual impact.