# Introduction to Statistics in Spreadsheets

4.3+
12 reviews
Beginner

Learn how to leverage statistical techniques using spreadsheets to more effectively work with and extract insights from your data.

4 Hours15 Videos51 Exercises

or

## Course Description

Statistics is the science that deals with the collection, analysis, and interpretation of data. Having a solid foundation in statistics will help you effectively work with your data to test hypotheses and uncover insights that can help solve your problems. This course is designed to give you that foundation in statistics. Using Spreadsheets functions, you'll dive into averages, distributions, hypothesis testing, and conclude the course by applying your newfound knowledge in a case study. Along the way, you'll work with a variety of datasets ranging from eBay auctions to train ridership to historical presidential approval ratings. Enjoy!
1. 1

### Getting To Know Your Data

Free

Begin your journey by learning why and how to summarize your data using statistics such as the mean, median, and mode. While working with a variety of datasets ranging from Amazon revenue to U.S Presidential ratings, you'll learn about the differences between each of these fundamental statistics and most importantly, when to use each.

Play Chapter Now
Welcome to the course!
50 xp
Don't be average!
100 xp
Presidential approval rating averages
100 xp
Difference between median and mean
100 xp
100 xp
How far from average?
50 xp
Train variation
100 xp
Calculating standard deviations
100 xp
Playing quarters
100 xp
Standardizing data
50 xp
Comparing z-scores
100 xp
Exploring eBay auctions
100 xp
2. 2

### Statistical Data Visualization

Data visualization is one of the most important parts of any data science workflow. It leads to a deeper understanding of your dataset which in turn allows you to more effectively communicate results to stakeholders. In this chapter, you'll learn how to visualize your data in Spreadsheets using statistical plots such as the histogram, scatter plot, and bar plot.

3. 3

### Statistical Hypothesis Testing

This chapter introduces you to statistical hypothesis testing. You'll learn how to construct a hypothesis, test it using different statistical tests, and properly interpret the results.

4. 4

### Case Study: Dating Profile Analysis

The final stretch! Apply all of your newfound statistical knowledge and solidify everything you have learned by working through a case study consisting of online dating profile data.

In the following tracks

Collaborators

Ted Kwartler

Ted Kwartler is the VP, Trusted AI at DataRobot. At DataRobot, Ted sets product strategy for explainable and ethical uses of data technology in the company's application. Ted brings unique insights and experience utilizing data, business acumen and ethics to his current and previous positions at Liberty Mutual Insurance and Amazon. In addition to having 4 DataCamp courses he teaches graduate courses at the Harvard Extension School and is the author of Text Mining in Practice with R.
See More

## Don’t just take our word for it

*4.3
from 12 reviews
58%
17%
25%
0%
0%
Sort by
• Natthawit J.
6 months

Good for beginner learning

• Albert F.
11 months

It is a complex subject that requires more than one reading and understanding.

• Jonathan V.
12 months

I love it! Very clear and too easy to understand.

• Kamil M.

I love how easy it is to learn with DataCamp. Great content and plenty of paths and courses to choose from. Thanks Guys!

• Hugo P.

Good course. The exercises were great!

"Good for beginner learning"

Natthawit J.

"It is a complex subject that requires more than one reading and understanding."

Albert F.

"I love it! Very clear and too easy to understand."

Jonathan V.