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 Sheets 在真實情境中加以應用。 這種實作導向的方法，透過一系列案例研究進一步強化學習效果。 這些案例研究運用多元資料集，例如 eBay 拍賣、火車乘客量以及歷屆總統支持率，讓您有機會實際應用所學知識與技能，分析並解讀真實數據。 在本課程結束時，您將能夠自行進行分析，並從各種情境中的資料集得出有意義的結論。</p>


Data Analysis in Google Sheets

學習如何利用統計技術和試算表更有效地處理數據並提取見解。

Google Sheets 統計學入門

掌握如何運用統計技術與試算表，有效分析並洞察資料。

中階 Google Sheets

Data Dude

Introduction to statistics

Sometimes it's ok to be mean (average)!

What it takes to be mean (average)?

Let's calculate an average

Let's calculate another average

Median averages

Modal average

Mean average in Google Sheets

Median and Mode in Google Sheets

Let's practice some averages!

Introduction to Statistics in Google Sheets

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

Getting To Know Your Data - Welcome to the course!

Welcome to the course!

Create Your Free Account