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