After doing these courses, I feel confident creating professional visualizations and dashboards
课程介绍
统计学是一门研究数据收集、分析和解释的科学。 拥有扎实的统计学基础将帮助你有效地处理数据,检验假设,并发现有助于解决问题的洞见。 本课程旨在为您打下统计学基础。 使用 Google Sheets 函数,你将深入学习平均值、分布、假设检验,并通过案例研究运用你新学到的知识来结束本课程。 一路上,你将处理各种各样的数据集,从 eBay 拍卖到火车客流量,再到历史总统支持率。 尽情享受!
全面课程体系
本课程提供全面的课程,涵盖统计分析的基本方面。 你将从数据收集的基础开始,逐步探索不同类型的数据及其特性。 我们将深入讲解描述性统计,教你如何使用均值、中位数和众数等指标来总结和解读数据。 你还将学习概率及其在统计学中的作用,包括概率分布和期望值等概念。
实践应用与案例研究
这门课程的独特之处之一在于强调实际应用。 你不仅会学习统计方法背后的理论,还会学习如何使用 Google 表格将其应用于真实世界场景。 这种实践导向的方法还通过一系列案例研究得到了进一步强化。 这些案例研究使用了多样化的数据集,例如 eBay 拍卖、列车客流量和历史总统支持率,将为您提供机会,将您的知识和技能应用于分析和解读真实数据。 课程结束时,你将能够独立开展分析,并从各种场景中的数据集得出有意义的结论。
先修要求
课程大纲
课程大纲
1
Getting To Know Your Data
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!50 经验值
- Don't be average!100 经验值
- Presidential approval rating averages100 经验值
- Difference between median and mean100 经验值
- Modal madness100 经验值
- How far from average?50 经验值
- Train variation100 经验值
- Calculating standard deviations100 经验值
- Playing quarters100 经验值
- Standardizing data50 经验值
- Comparing z-scores100 经验值
- Exploring eBay auctions100 经验值
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 Google Sheets using statistical plots such as the histogram, scatter plot, and bar plot.
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
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.
S
Google Sheets 统计学入门
课程完成

