Excel Statistics Essential Training: 2

Learn more statistics fundamentals. Find out how to perform hypothesis tests, ANOVA, regression, and correlation testing and run simulations in Microsoft Excel.

Introduction

• Using Excel for statistics
• What you need to know
• Exercise files
• Tool pack

1. Sampling

• Sample considerations
• The central limit theorem
• T-statistic vs. z-statistic

2. Confidence Intervals

• Introduction to confidence intervals
• Creating confidence intervals in Excel (proportions)
• Creating confidence intervals in Excel (means)

3. Hypothesis Tests

• How to test a hypothesis
• Five steps of hypothesis testing
• One-tailed vs. two-tailed tests
• Hypothesis test exercise (means)
• Hypothesis test exercise (proportions)

4. Comparing Two Populations

• Explanation of two population comparisons
• Comparing two populations (proportions)
• Comparing two populations (means)

5. ANOVA: Analysis of Variance

• ANOVA: What is analysis of variance?
• Hypothesis test and the F-statistic

6. Regression

• What is regression?
• Regression terminology
• Linear regressions

7. Simulation

• What are simulations?
• Monte Carlo simulation example
• Business simulation example

Conclusion

• Continue learning Excel statistics