Cleaning and Recoding

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

Jump to: Excel for Evaluation homepage | Housekeeping | Cleaning and Recoding | Exploring | Descriptives | Pivot Tables | Charts and Graphs | Extras | Putting It All Together

Leave a Reply

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s