Excel Statistics Essential Training: 2

Excel Statistics Essential Training: 2

3h 24mAdvanced2023-10-04

Authors

Eddie Davila

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.

Skills covered

SpreadsheetsMicrosoft ExcelData AnalysisEssential TrainingData ScienceBusiness Analysis and StrategyBusiness Software and ToolsMicrosoft

Concepts

Introduction

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

Sampling

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

Confidence Intervals

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

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)

Comparing Two Populations

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

ANOVA - Analysis of Variance

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

Regression

  • What is regression
  • Regression terminology
  • Linear regressions

Simulation

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

Conclusion

  • Continue learning Excel statistics
80,000 Toman