Author:
lenore desilets, Barbara Illowsky
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
Language:
English
Media Formats:

## 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

Normal Distribution

Central Limit Theorem

Hyporhesis Test - Single Mean

Hyporhesis Test - Single Proportion

Goodness of Fit

Linear Regression

# 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:

# Normal Distribution

## Learning Objective:

Compare the distribution of empirical data to the Normal Distribution.

For Student

# 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

# Hypothesis Test - Single Mean

## Learning Objective:

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

For Students

# Hypothesis Test - Single Proportion

## Learning Objective:

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

For Students

# 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

# 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: