Special offers now — see discounted courses.
day
:
hour
:
min
:
sec
See special offers
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

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

About us

LyndaKade is a leading learning platform that helps people learn business, software, technology, and creative skills to achieve personal and professional goals.

Phone numberAparat ChannelTelegram SupportTelegram ChannelInstagram Page

All rights to this site belong to LyndaKade.

Terms of Service|Privacy Policy

نماد الکترونیک enamad در صورت اتصال با آی‌پی داخل کشور، نمایش داده خواهد شد.
logo-samandehi - لوگو ساماندهی
Zarinpal
Zibal