Resource Library

This tutorial explains in detail how to find a confidence interval using Excel.

This tutorial explains in detail how to make a scatterplot in Excel.

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.

The applet allows users to sample from a normal distribution or from a uniform distribution. It shows the expected values and the observed values and computes the deviation. Then, a chi-square test shows if the deviations are significant for both the normal and uniform distributions.

This applet simulates experiments using 2 x 2 contingency tables. You specify the population proportions and the sample size and examine the effects on the probability of rejecting the null hypothesis.