Central to Stats: Sampling!

Introduction to Statistics in Google Sheets

Ted Kwartler

Data Dude

Lesson Overview

  • Samples vs populations
  • Central Limit Theorem (CLT)
Introduction to Statistics in Google Sheets

So far, you have...

  • Calculated descriptive statistics

Screen Shot 2019-07-08 at 12.02.29 PM.png

Introduction to Statistics in Google Sheets

So far, you have...

  • Calculated descriptive statistics
  • Made data visualizations

Screen Shot 2019-07-08 at 12.02.29 PM.png

Screen Shot 2019-07-08 at 12.04.48 PM.png

Introduction to Statistics in Google Sheets

So far, you have...

  • Calculated descriptive statistics
  • Made data visualizations
  • Used all of the data

Screen Shot 2019-07-08 at 12.02.29 PM.png

Screen Shot 2019-07-08 at 12.04.48 PM.png

Introduction to Statistics in Google Sheets

So far, you have...

  • Calculated descriptive statistics
  • Made data visualizations
  • Used all of the data
  • Worked with "populations"

Screen Shot 2019-07-08 at 12.02.29 PM.png

Screen Shot 2019-07-08 at 12.04.48 PM.png

Introduction to Statistics in Google Sheets

What is a population?

  • An entire distribution of observations/events
  • Costly and time consuming to work with
  • Better to "sample" the population

Introduction to Statistics in Google Sheets

Sampling to the rescue

  • A subset from a population
  • Meant to represent the population
  • The larger the sample size, the closer the statistics of the sample will emulate the statistics of the population

Introduction to Statistics in Google Sheets

shutterstock_313879568.jpg

shutterstock_769146163.jpg

  • If a sample size from an independent, random variable is large enough, then the sampling distribution will be normal or nearly normal
Introduction to Statistics in Google Sheets

Central Limit Theorem (CLT)

  • "Large enough" is vague...
  • How accurate do you need to be? This affects the sample size needed
  • The more closely the population follows a normal distribution, the fewer samples will be required
  • Minimum number needed is between 30 and 40
Introduction to Statistics in Google Sheets

Off to do some sampling!

Introduction to Statistics in Google Sheets

Preparing Video For Download...