Special offers now — see discounted courses.
day
:
hour
:
min
:
sec
See special offers
Excel Statistics Essential Training: 1

Excel Statistics Essential Training: 1

3h 37mIntermediate2023-05-23

Authors

Eddie Davila

Eddie Davila

Associate Chair for the ASU Supply Chain Management program

Course details

Data isn’t valuable until you put it to good use. Statistics transforms data into meaningful information, enabling organizations to make better decisions and predictions. That’s why statistics—collecting, analyzing, and presenting data—is a valuable skill for anyone in business or academia. In this course, statistics and business analysis instructor Eddie Davila takes you on a nuanced, step-by-step journey to mastering statistics through Excel. Eddie first teaches the basic principles of statistics with a series of examples, then advances your understanding by extending those same examples into more complex applications of statistical theory—all while using Excel and Excel's statistics tools and functions.

Skills covered

StatisticsSpreadsheetsMicrosoft ExcelEssential TrainingData ScienceBusiness Software and ToolsMicrosoft

Concepts

0. Introduction

  • 01 - Course introduction
  • 02 - What you need to know
  • 03 - Exercise files

1. Starting with Excel

  • 04 - Excel basics
  • 05 - Random number generator

2. Dataset Basics

  • 06 - Sum, Count, Max, Min, and Range
  • 07 - Means, medians, and modes

3. Looking at Data

  • 08 - Frequency table
  • 09 - Histogram

4. Dataset Variability

  • 10 - Standard deviation
  • 11 - Normal curve and normal distribution
  • 12 - Skewness and kurtosis
  • 13 - Empirical rule

5. Excel Descriptive Tools

  • 14 - Descriptive tool
  • 15 - Descriptive tool exercise

6. Basic Probability Concepts

  • 16 - Probability explained
  • 17 - Percentiles
  • 18 - Permutations
  • 19 - Combinations
  • 20 - Addition rule of probability
  • 21 - Multiplication rule of probability
  • 22 - Conditional probability and probability trees

7. Discrete Probabilities

  • 23 - Discrete probability explained
  • 24 - Discrete - Mean
  • 25 - Discrete - Standard deviation
  • 26 - Discrete - Binomial distribution

8. Continuous Probabilities

  • 27 - Continuous - Z-score tables
  • 28 - Continuous - Creating a normal curve in Excel
  • 29 - Continuous - Calculating normal distribution probabilities

Conclusion

  • 30 - Next steps and additional resources

Related courses

Related learn paths

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