Before you can analyze your data, you’ll need to check for missing data and recode some variables.
Tutorials about cleaning data and recoding variables include:
Or, watch the entire cleaning and recoding playlist in YouTube.
How to use Count, Countblank, and Sum
First, you’ll need to see how much missing data you’re dealing with. Learn to use the count, countblank, and sum functions to quickly scan for missing data.
How to recode variables using the If formula: Example 1
Use =if to recode variables.
How to recode variables using the If formula: Example 2
Here’s a second video showing you how to use =if to recode variables.
Return to top