- Author:
- Barbara Illowsky, lenore desilets
- Subject:
- Statistics and Probability
- Material Type:
- Module
- Level:
- Community College / Lower Division
- Tags:
- License:
- Creative Commons Attribution 4.0
- Language:
- English
- Media Formats:
- Downloadable docs
Goodness of Fit
Hypothesis Test - Single Mean
Hypothesis Test - Single Proportion
Linear Regression
Normal Distribution
Univariate Data
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.
Hyporhesis Test - Single Proportion
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: