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

统计学是一门研究数据的收集、分析与解释的科学。扎实的统计基础将帮助您更高效地处理数据，用以检验假设并挖掘可用于解决问题的洞见。本课程旨在为您打下统计学基础。借助 Google Sheets 的函数，您将学习均值、分布、假设检验等主题，并在课程末通过一个案例研究应用新学到的知识。在此过程中，您将接触多种数据集，从 eBay 拍卖到火车客流量，再到历任美国总统的支持率。祝学习顺利！

<p>统计学是一门研究数据收集、分析和解释的科学。 拥有扎实的统计学基础将帮助你有效地处理数据，检验假设，并发现有助于解决问题的洞见。 本课程旨在为您打下统计学基础。 使用 Google Sheets 函数，你将深入学习平均值、分布、假设检验，并通过案例研究运用你新学到的知识来结束本课程。 一路上，你将处理各种各样的数据集，从 eBay 拍卖到火车客流量，再到历史总统支持率。 尽情享受！</p>

<h2>全面课程体系</h2>
<p>本课程提供全面的课程，涵盖统计分析的基本方面。 你将从数据收集的基础开始，逐步探索不同类型的数据及其特性。 我们将深入讲解描述性统计，教你如何使用均值、中位数和众数等指标来总结和解读数据。 你还将学习概率及其在统计学中的作用，包括概率分布和期望值等概念。</p>

<h2>实践应用与案例研究</h2>
<p>这门课程的独特之处之一在于强调实际应用。 你不仅会学习统计方法背后的理论，还会学习如何使用 Google 表格将其应用于真实世界场景。 这种实践导向的方法还通过一系列案例研究得到了进一步强化。 这些案例研究使用了多样化的数据集，例如 eBay 拍卖、列车客流量和历史总统支持率，将为您提供机会，将您的知识和技能应用于分析和解读真实数据。 课程结束时，你将能够独立开展分析，并从各种场景中的数据集得出有意义的结论。</p>


Data Analysis in Google Sheets

学习如何利用电子表格中的统计技术更有效地处理数据并提取见解。

Google Sheets 统计学入门

学习如何利用电子表格中的统计技术，更有效地处理数据并提取洞察。

中级 Google 表格

Data Dude

Correlation tips from one to negative one

Lifeguards for Ice Cream

Correlation Visualized

Let's practice!

Introduction to Statistics in Google Sheets

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