Resource Library

This module contains discussions on t-test, ANOVA, correlation, two-way factorial ANOVA, regression, chi-squared, and distributions and provides links to a variety of activities relevant to the discussions.

The Journal of Statistics Education has published this collection of datasets and related articles describing their use, submitted by faculty members from numerous institutions. Data is in .dat format.

This collection is organized as discussions and activities in the subjects of descriptive statistics, inferential statistics, graphical analysis, and TI-83 and Excel guides. It also includes a section of quizzes. Key Words: Mean; Median; Mode; Normal Distribution; Skewed Distribution; Range; Standard Deviation; Confidence Interval; T-Test; ANOVA; Correlation; Regression; Chi-Square; Probability Distributions; Histograms; Scatterplots; Boxplot.

In this activity, students will perform a t-test to see if fecal coliform counts collected from Blackwater Creek in Lynchburg, Virginia differ before and after rain showers. Questions about the exercise and links to Excel and TI-83 instructions are given. The data exist in Excel, TI-83, and text formats.

In this activity, students will perform an ANOVA to determine if the longevity of male fruitflies is related to their reproductive cycle. The dataset contains longevity (in days) of male fruitflies in 5 groups: Alone, 1 Interested Female, 8 Interested Females, 1 Uninterested Female, 8 Uninterested Females. Questions about the exercise and links to Excel and TI-83 instructions are given. The data exist in Excel, TI-83, and text formats.

In this activity, students will calculate the correlation between college enrollment at University of New Mexico and unemployment data in the state of New Mexico. They will also generate a scatterplot of the data. Questions about the exercise and links to Excel and TI-83 instructions are given. The data exist in Excel, TI-83, and text formats.

In this activity, students will perform a one sample t-test to see if the pH level of rain collected by the EPA is less than the pH standard for acid rain (5.6). Questions about the exercise and links to a t-test applet and TI-83 instructions are given. The data exist in Excel, TI-83, and text formats.

In this activity, students will calculate the correlation and generate a scatterplot of the number of passengers flying and the number of performed departures from 135 airports in the US. Questions about the exercise and links to Excel and TI-83 instructions are given. The data exist in Excel, TI-83, and text formats.

This tutorial explains in detail how to perform an ANOVA in Excel.

This tutorial explains in detail how to make a 3-D graph using the Chart Wizard in Excel.