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]
- 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:
you’ll learn how to make calculations on your data
you’ll learn how to create composite variables
you’ll learn how to convert numerical data to categories
you’ll learn how to code your data to make it easier to work with in stats programs
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
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
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
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
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
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...