The Hive - Learn, Help, Connect
Dirty Data Dojo - Data Preparation

Excel

Python

R

Preparing your data for analysis means understanding your data, knowing what you can and can't do with it, and knowing how to work with it to get it in the shape you need.

In this course you're going to learn how to understand and prepare your data for analysis - in Excel, Python and R - quickly and effectively!

I’ll teach you how to transform data from what you have into what you need, and show you how to create new variables.

I'll also teach you how to use knowledge of the different data types to plan your entire study - from beginning to end.

The steps you’ll learn in this course are very simple to follow, but are extremely effective, so you’ll know that you’re getting the best start possible, saving you weeks of misery!


Video lessons

Articles

Downloadable resources

Certificate of completion

Interactive experience

Perfect for beginners


[wpc_button]

  • Description
  • Content
  • Excel
  • Python & R
  • Outcomes
  • FORUM
  • CertificatE
  • 14D2C2

This course is about teaching you how to prepare your data and transform it from what you have into what you need to get your analyses done.

Here’s a quick rundown of what you’re going to learn:

Here's what you'll learn:

1.

you’ll learn how to make calculations on your data

2.

you’ll learn how to create composite variables

3.

you’ll learn how to convert numerical data to categories

4.

you’ll learn how to code your data to make it easier to work with in stats programs

5.

you’ll learn the data type of each of your variables, helping you to decide which analyses are appropriate

Your Curriculum

1

Introduction to Data Preparation

An introduction to this course and to the 14 Day Data Cleaning Challenge!

Open Access

CHAPTER HIGHLIGHTS

Introduction to Data Preparation

2

Making Data Calculations

In this chapter you'll learn how to 'work' with your data to get it into the right shape for your analyses. You'll also learn how to convert numerical data to categories

Free Plan

Premium

CHAPTER HIGHLIGHTS

Creating Composite Variables

Converting Numerical Data to Categories

Rounding Your Data

3

How to Code Your Data

The focus in this chapter is on how to code your data for use in statistics programs - how to convert your data from text to integers

Premium

CHAPTER HIGHLIGHTS

Converting Text Data to Integers

How to Code Using If-Then-Else

How to use VLOOKUP

4

Knowing Your Data Types

The focus in this chapter is on knowing and understand the 4 types of data in statistics - so you can plan your entire study from beginning to end!

Premium

CHAPTER HIGHLIGHTS

Knowing and Understand the 4 Data Types - Ratio, Interval, Ordinal, Nominal

5

Course Recap

In this chapter you'll recap all the techniques you've learned

Premium

CHAPTER HIGHLIGHTS

A Recap of Everything in This Course

Get Started

It's free to get started, with no obligation to buy or register.

Try it now, decide later!

Just click the link on the right to go to the first lesson...

How to analyse categorical survey data in Excel and in R
Remember Me
Success message!
Warning message!
Error message!