Excel Statistics Essential Training: 2
3h 24mAdvanced2023-10-04
Authors

Eddie Davila
Associate Chair for the ASU Supply Chain Management program
Course details
Data isn’t valuable until you figure out what the data actually mean. Statistics transforms data into meaningful information, enabling organizations to make more informed decisions. That’s why statistics—collecting, analyzing, and presenting data—is a valuable skill for anyone in business or academia.
In this course, LinkedIn Learning statistics and business analysis instructor Eddie Davila takes you on a nuanced, step-by-step applied learning path to understanding statistics and statistical methods in Excel. Eddie first teaches the basic principles of statistical sampling, and then utilizes random samples to explore complex applications of statistical theory—all while using Excel statistics tools and functions. He covers topics like regression, hypothesis tests, analysis of variance (ANOVA), and Monte Carlo simulations, showing how Excel can help you tackle and interpret advanced statistical analyses.
In this course, LinkedIn Learning statistics and business analysis instructor Eddie Davila takes you on a nuanced, step-by-step applied learning path to understanding statistics and statistical methods in Excel. Eddie first teaches the basic principles of statistical sampling, and then utilizes random samples to explore complex applications of statistical theory—all while using Excel statistics tools and functions. He covers topics like regression, hypothesis tests, analysis of variance (ANOVA), and Monte Carlo simulations, showing how Excel can help you tackle and interpret advanced statistical analyses.
Skills covered
SpreadsheetsMicrosoft ExcelData AnalysisEssential TrainingData ScienceBusiness Analysis and StrategyBusiness Software and ToolsMicrosoft
Concepts
0. Introduction
- 01 - Using Excel for statistics
- 02 - What you need to know
- 03 - Exercise files
- 04 - Tool pack
1. Sampling
- 05 - Sample considerations
- 06 - The central limit theorem
- 07 - T-statistic vs. z-statistic
2. Confidence Intervals
- 08 - Introduction to confidence intervals
- 09 - Creating confidence intervals in Excel (proportions)
- 10 - Creating confidence intervals in Excel (means)
3. Hypothesis Tests
- 11 - How to test a hypothesis
- 12 - Five steps of hypothesis testing
- 13 - One-tailed vs. two-tailed tests
- 14 - Hypothesis test exercise (means)
- 15 - Hypothesis test exercise (proportions)
4. Comparing Two Populations
- 16 - Explanation of two population comparisons
- 17 - Comparing two populations (proportions)
- 18 - Comparing two populations (means)
5. ANOVA - Analysis of Variance
- 19 - ANOVA - What is analysis of variance
- 20 - Hypothesis test and the F-statistic
6. Regression
- 21 - What is regression
- 22 - Regression terminology
- 23 - Linear regressions
7. Simulation
- 24 - What are simulations
- 25 - Monte Carlo simulation example
- 26 - Business simulation example
Conclusion
- 27 - Continue learning Excel statistics