Cleaning and Recoding

Before you can analyze your data, you’ll need to check for missing data and recode some variables.

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.