| Lesson 1: Introduction to Statistics and Excel | What is statistics?
Introduction to Excel |
| Lesson 2: Graphical Descriptive Techniques | Displaying and Describing Data
Quantitative Data in Excel
Frequency Distribution in Excel
Stem and Leaf Plot in Excel |
| Lesson 3: Measures of Central Location and Variability | Summarizing Quantitative Data and Interquartile Range
Mean and Median Basics
Measures of the Spread |
| Lesson 4: Covariance and Coefficients of Correlation | Correlation and Correlation Coefficient in Excel
|
| Lesson 5: Least Squares Method and Regression | Simple Linear Regression in Excel |
| Lesson 6: Assigning Probabilities to Events; Probability Rules | Basic Probability, Definitions and Venn Diagrams
Properties of Probability, the Addition Rule |
| Lesson 7: Experiments Having Equally Likely Outcomes | Counting Principles, Permutations and Combinations
Experiments with Equally Likely Outcomes |
| Lesson 8: Conditional Probability and Independence | Conditional Probability and Independence |
| Lesson 9: Relative Frequency Distribution and z-scores | Relative Frequency Distribution
Z-score |
| Lesson 10: Random Variables, Probability Distributions | Random Variables
Constructing Probability Distributions |
| Lesson 11: Expected Value and Variance | Expected Value
Expected Value and Variance of a Discrete Random Variable |
| Lesson 12: Binomial Distribution | Binomial Probability Distribution
Creating a Binomial Probability Distribution in Excel |
| Lesson 13: Poisson Distribution | Poisson Distribution |
| Lesson 14: Continuous Random Variables | Discrete and Continuous Random Variables
Probability Density Function of a Continuous Random Variable
Uniform Probability Distribution |
| Lesson 15: Normal Random Variables | An Introduction to the Normal Distribution |
| Lesson 16: Finding Normal Probabilities | Using Excel to Find Normal Probabilities |
| Lesson 17: Sample Mean | Sampling Distribution of Sample Means |
| Lesson 18: Distribution of the Sample Mean | |
| Lesson 19: Distribution of the Sample Variance of a Normal Population | Chi Square Distribution
Chi Square Distribution in Excel |
| Lesson 20: Estimating Population Means | Confidence Intervals for Population Means |
| Lesson 21: Hypothesis Testing with Known Standard Deviation | Hypothesis Testing and p-values |
| Lesson 22: Inference about a Population Mean with Unknown Standard Deviation | Hypothesis Testing with Sigma Unknown |
| Lesson 23: Chi-Squared Goodness of Fit Test | Introduction to the Chi-Square Distribution
Chi-Square Goodness of Fit Test |
| Lesson 24: Chi-Squared Test for Independence Contingency Table | Chi-Squared Test for Independence with Contingency Table |
