Author:
Barbara Illowsky, lenore desilets
Subject:
Statistics and Probability
Material Type:
Module
Level:
Community College / Lower Division
Tags:
De Anza College, Descriptive Statistics, Open Educational Resources, OpenStax, Spreadsheet-based Statistics Labs, Statistics, Statistics Labs, de-anza-college, descriptive-statistics, open-educational-resources, openstax, statistics, statistics-labs
License:
Creative Commons Attribution 4.0
Language:
English
Media Formats:
Downloadable docs

Spreadsheet-based Statistics Labs

Module Overview

This collection of spreadsheet-based labs was funded as part of the Digital Learning Research Network (dLRN) made possible by a grant from the Bill and Melinda Gates Foundation. The labs were adapted from the Statistics book, “Introduction to Statistics,” published by OpenStax College. The original labs used graphing calculators and were found within the book after each chapter. These interactive spreadsheet-based labs are effective for online and face-face courses. They may also be used with the book (see Resource: Lab Mapping to Book Chapters) or stand-alone.

Authors: Barbara Illowsky PhD, Foothill-De Anza Community College District; Larry Green PhD, Lake Tahoe Community College; James Sullivan, Sierra College; Lena Feinman,College of San Mateo; Cindy Moss, Skyline College; Sharon Bober, Pasadena Community College; Lenore Desilets, De Anza Community College.

Lab Mapping to Book Chapters

Grading Rubric

Labs
Univariarate Data

Normal Distribution

Central Limit Theorem

Hyporhesis Test - Single Mean

Hyporhesis Test - Single Proportion

Goodness of Fit

Linear Regression

 

Section 1: Univariarate Data

Learning Objective:

  • The students will design and carry out a survey.

  • The students will analyze and graphically display the results of the survey.

For Student:

Section 2: Normal Distribution

Learning Objective:

Compare the distribution of empirical data to the Normal Distribution.

For Student

Section 3: Central Limit Theorem

Learning Objective

Students will examine properties of the Central Limit Theorem by randomly selecting 10 groups of 5 colleges and analyzing the distributions of the means of the student enrollment. Four students will collaborate on this lab. The group should be divided into two teams

For Students

Section 4: Hypothesis Test - Single Mean

Learning Objective:

Conduct a hypothesis test for a single mean and interpret the results.

For Students

Section 5: Hypothesis Test - Single Proportion

Learning Objective:

Conduct a hypothesis test for a single proportion and interpret the results.

For Students

Section 6: Goodness of Fit

Learning Objective

Students will collect and evaluate birth Day data to determine if they fit a Uniform Distribution. Four students will collaborate on this lab.

For Students

Section 7: Linear Regression

Learning Objective:

  • Evaluate the relationship between two variables to determine the significance of the linear correlation.

  • If linear correlation exists, determine and construct the linear regression equation between two variables.

For Students: