Elementary Statistics

Excel Spreadsheets

Descriptive Statistics
Used Throughout - Sort Data First

p-Values
p-Values for All Tests

Chapter 6 - Confidence Intervals
All Confidence Intervals

Chapter 7 - One Sample Tests
All Single Sample Hypothesis Tests    Paired Sample Hypothesis Test

Chapter 8 - Two Sample Tests
Test for Two Proportions    Test for Two Means/Independent Samples

Chapter 9 - Correlation & Regression Tests
Correlation & Regression    Normal Quantile Plot Test for Normality    Quadratic Regression

Chapter 10 - Chi-Square Tests
Goodness of Fit    Contingency Table & Test for Independence

Chapter 11 - Analysis of Variance
One-Way ANOVA    F-Test for Two Variances or Standard Deviations