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.  

Welcome to the course!

Don't be average!

Presidential approval rating averages

Difference between median and mean

Modal madness

How far from average?

Train variation

Calculating standard deviations

Playing quarters

Standardizing data

Comparing z-scores

Exploring eBay auctions

Getting To Know Your Data

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 Google Sheets using statistical plots such as the histogram, scatter plot, and bar plot.

Visualizing Distributions

"Normal" views of money

Visualizing customer longevity

Visualizing customer donations

Is the data "normally" distributed?

Visualizing Correlations

Correlation between price and quantity sold

Correlation between seller rating and closing price

Adding a trend line

Bar charts

Bar chart of competitive counts

Visualizing categories

Statistical Data Visualization

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. 

Central to Stats: Sampling!

Sampling in Google Sheets

Does sampling size matter?

Central Limit Theorem in action

Hypothesis Testing

Comparing samples with a t-test

Paired t-test

Hypothesis Testing with the Z-test

Performing a Z-test

What changes in a two-tailed test?

Hypothesis Testing with the Chi-squared test

Performing a chi-squared test

Are bank loans getting worse?

Statistical Hypothesis Testing

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. 

Dating Data!

Understanding the distribution of ages

What's the drinking age?

Profile login behavior

Visuals & Distributions

Visualizing logins

How old do users look?

Tipping the scale to positive correlation

Investigating age and volunteering

More complex relationships

Are gender and number of roommates independent?

Getting old and rich

Multiple relationships!

Congratulations!

Case Study: Dating Profile Analysis

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 Google Sheets 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!

<p>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 Google Sheets 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!</p>

<h2>Comprehensive Curriculum</h2>
<p>This course offers a comprehensive curriculum covering the fundamental aspects of statistical analysis. You'll start with the basics of data collection and move on to exploring different types of data and their properties. We'll delve into descriptive statistics, teaching you how to summarize and interpret data using measures like mean, median, and mode. You'll also learn about probability and its role in statistics, including concepts such as probability distributions and expected values.</p>

<h2>Practical Application and Case Studies</h2>
<p>One of the unique aspects of this course is the emphasis on practical application. You'll not only learn the theory behind statistical methods but also how to apply them in real-world scenarios using Google Sheets. This hands-on approach is further enhanced by a series of case studies. These case studies, using diverse datasets such as eBay auctions, train ridership, and historical presidential approval ratings, will provide you with the opportunity to apply your knowledge and skills in analyzing and interpreting real data. By the end of the course, you'll be able to conduct your own analyses and draw meaningful conclusions from data sets in various contexts.</p>


Data Analysis in Google Sheets

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

Introduction to Statistics in Google Sheets

Planilhas Google intermediárias

Data Dude

Correlation tips from one to negative one

Lifeguards for Ice Cream

Correlation Visualized

Let's practice!

https://s3.amazonaws.com/assets.datacamp.com/production/course_14503/subtitles/course_14503_ad71df778761404898005e5f815a0a12.vtt

Case Study: Dating Profile Analysis - Tipping the scale to positive correlation

Tipping the scale to positive correlation

Create Your Free Account