Excel Statistics Essential Training: 1

Learn statistics with the help of Microsoft Excel.

Introduction

• Course introduction
• What you need to know
• Exercise files

1. Starting with Excel

• Excel basics
• Random number generator

2. Dataset Basics

• Sum, Count, Max, Min, and Range
• Means, medians, and modes

3. Looking at Data

• Frequency table
• Histogram

4. Dataset Variability

• Standard deviation
• Normal curve and normal distribution
• Skewness and kurtosis
• Empirical rule

5. Excel Descriptive Tools

• Descriptive tool
• Descriptive tool exercise

6. Basic Probability Concepts

• Probability explained
• Percentiles
• Permutations
• Combinations
• Addition rule of probability
• Multiplication rule of probability
• Conditional probability and probability trees

7. Discrete Probabilities

• Discrete probability explained
• Discrete: Mean
• Discrete: Standard deviation
• Discrete: Binomial distribution

8. Continuous Probabilities

• Continuous: Z-score tables
• Continuous: Creating a normal curve in Excel
• Continuous: Calculating normal distribution probabilities

Conclusion

• Next steps and additional resources