Back to Main Page

Free Textbook developed by Rice University,
University of Houston Clear Lake, and Tufts University

(This takes time to download... please be patient!)


Class 1 Materials

PowerPoint: Population, Sample, Parameter, Statistic

Handout: Population, Sample, Parameter, Statistic

In-Class Practice Spreadsheet:
     Population, Sample, Parameter, Statistic - Beads and Hair Color

Homework: Summary Tables and Graphs in Excel - Eye Color

Document: How to Enter Formulas in Excel


Class 2 Materials

PowerPoint: Type of Data

PowerPoint: Graphs

Handout: Type of Data and Graphs


Class 3 Materials

PowerPoint: Frequencies
     (does not include cumulative frequencies)

Handout: Frequencies

In-Class Practice Spreadsheet: Frequencies - Internet Usage

Document: How to Do Graphs in Excel


Class 4 Materials

PowerPoint: Fractiles (includes cumulative frequencies)

Handout: Fractiles

PowerPoint: Boxplots

Document: How to Do IQR in Excel


Class 5 Materials

PowerPoint: Central Tendency (Averages)

Handout: Central Tendency (Averages)

Homework: Descriptive Statistics in Excel - Cocoa Products

Document: How to Do Descriptive Statistics in Excel


Class 6 Materials

PowerPoint: Variability

Handout: Variability

In-Class Practice Spreadsheet: Descriptive Statistics and
     Multiple Comparison Graphs in Excel - Salary Comparison

Homework: Multiple Comparison Graphs in Excel - Tea Imports

Document: How to Do a Multiple Comparison Graph in Excel


Class 7 Materials

PowerPoint: Sampling

PowerPoint: Experimental Design


Class 8 Materials

PowerPoint: Correlation

PowerPoint: Regression

In-Class Practice Spreadsheet: Regression in Excel - Hubble Data

Handout: Regression and Correlation


Class 9 Materials

PowerPoint: Time Series Forecasting

Handout: Time Series

Document: How to Do Time Series Forecasts in Excel

In-Class Practice Spreadsheet: Time Series Forecasting in Excel -
     Annual Profits

PowerPoint: Non-Linear Time Series Forecasting
     Including Cyclical Forecasting

Handout: Nonlinear Time Series Forecasting

In-Class Practice Spreadsheet: Non-Linear Forecasting in Excel -
     Atmospheric CO2 Levels

In-Class Practice Spreadsheet: Non-Linear Forecasting in Excel -
     Home Prices

In-Class Practice Spreadsheet: Cyclical Forecasting in Excel -
     Quarterly Income

In-Class Practice Spreadsheet: Cyclical Forecasting in Excel -
     Monthly Travel

Homework: Cyclical Forecasting in Excel - Electricity Consumption

Document: How to Do Nonlinear Time Series Forecasts in Excel


Class 10 Materials

PowerPoint: Moving Averages


Class 11 Materials

PowerPoint: Probability (includes combinatorics)

PowerPoint: Discrete Random Variables (Binomial)


Class 12 Materials

PowerPoint: Normal Probability

Handout: Normal Probability

PowerPoint: Sampling Distributions

PowerPoint: Confidence Intervals

Handout: Sampling Distributions and Confidence Intervals

Document: How to Graph Confidence Intervals in Excel


Class 13 Materials

PowerPoint: Hypothesis Tesing

Handout: Hypothesis Testing


Class 14 Materials

PowerPoint: t-Tests

Document: How to Do a t-Test in Excel

PowerPoint: ANOVA

Handout: t-Tests and ANOVA

Document: How to Do ANOVA in Excel


Class 15 Materials

PowerPoint: Chi-Square

In-Class Practice Spreadsheet: Chi-Square Tests in Excel -
     Siblings vs Theory

In-Class Practice Spreadsheet: Chi-Square Tests in Excel -
     Heart Surgery

In-Class Practice Spreadsheet: Chi-Square Tests in Excel -
     Antarctic Cyclones

In-Class Practice Spreadsheet: Chi-Square Tests in Excel -
     Hair and Eye Color

Homework Spreadsheet: Chi-Square Tests in Excel -
     Footbridge Collapse

Data for Homework Spreadsheet: Chi-Square Tests in Excel -
     Footbridge Collapse Data

PowerPoint: Process Control

Handout: Chi-Square and Process Control

Handout: How to Do Chi-Square in Excel


Project Materials

Data for projects generated in class:

     Hand Measurements

     Favorite Diamond Simulants

     Favorite White Gemstones

     Height vs Reach

     Cephalic Index

Master's Level Example Projects:

     Multiple Comparison Project - spreadsheet
     Multiple Comparison Project - PowerPoint
     Thanks to Sara Mohamed!

     Curvilinear Regression: US Inflation vs. Civil Service Pay Raises
         Thanks to Robert Cooper!

     Curvilinear Regression: Denver Rental Prices
         Thanks to Narantungalag Bat-Erdene!

     Multiple Comparison Graphs: Education Level vs. Denver Salary
         Thanks to Joshua Harris!

Undergraduate Example Projects:

     Time Series Forecast Project - spreadsheet
     Time Series Forecast Project - PowerPoint
     Thanks to Chad Clyburn!

     Regression Project
     Thanks to Layne Proctor!

     ANOVA Project
     Thanks to Virginia Tallmadge!

     Chi-Sq Project
     Thanks to Derrik Echevarria!

     Confidence Interval Project


Back to Main Page