Cleaning and Recoding

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

Checking for Missing Data: Color-Coding Your Empty Cells
Collecting and using data is hard work! You’re bound to run into some situations where you are missing data. Maybe the program participants skipped a survey question because they didn’t understand the wording, or maybe the program staff forgot to enter the information into your nonprofit’s database. Either way, you need to know how much missing data you’re dealing with so you can find a solution. In this tutorial, you’ll learn how to automatically color-code your blank cells to visualize how much missing data you’re dealing with.

Checking for Missing Data: Tallying How Many Cells Are Empty

You’ll need to determine exactly how many people are in your dataset (and much missing data you’re dealing with). I teach you how to use three formulas to scan for missing data:

  • =count() tells you how many cells contain numeric data
  • =countblank() tells you how many of those cells are empty
  • Then, use =sum() to make sure the =count() and =countblank() add up

Checking for Duplicate Values

Another important data cleaning step is to determine whether your dataset contains any duplicate entries. I teach you two strategies to scan for duplicate ID numbers:

  • Pivot table tallies
  • Color-coding (a conditional formatting feature)
Free Download Bonus! Download the spreadsheet used in this video.

Recoding Variables (Example 1)
Use =if to recode variables.

Recoding Variables (Example 2)
Here’s a second video showing you how to use =if to recode variables.

Agen Togel Resmi dengan Hadiah 4D 10 Juta di Tahun 2024

Kumpulan agen togel terbaik dengan hadiah-hadiah terbesar yang jarang anda temukan. kami menyediakan permainan togel online yang memiliki hadiah 4D Terbesar di tahun 2024, dimana anda kan merasakan hadiah 4d 10 juta. bagi anda pemain togel jangan ragu karena Situs Togel ini sudah resmi terpercaya dengan pembayaran yang super cepat dan pastinya aman. selain itu situs ini juga memberikan bocoran bocoran angka keluar yang akan membantu anda mendapatkan hadiah terbesar yang kami sediakan. daftar sekarang juga dan rasakan kemenangan yang menakjubkan.

Related Links:

Togel178

Pedetogel

Sabatoto

Togel279

Togel158

Colok178

Novaslot88

Lain-Lain

Partner Links