Excel Statistics Essential Training: 1
Offered By: LinkedIn Learning
Course Description
Overview
Learn statistics with the help of Microsoft Excel.
Syllabus
Introduction
- Course introduction
- What you need to know
- Exercise files
- Excel basics
- Random number generator
- Sum, Count, Max, Min, and Range
- Means, medians, and modes
- Frequency table
- Histogram
- Standard deviation
- Normal curve and normal distribution
- Skewness and kurtosis
- Empirical rule
- Descriptive tool
- Descriptive tool exercise
- Probability explained
- Percentiles
- Permutations
- Combinations
- Addition rule of probability
- Multiplication rule of probability
- Conditional probability and probability trees
- Discrete probability explained
- Discrete: Mean
- Discrete: Standard deviation
- Discrete: Binomial distribution
- Continuous: Z-score tables
- Continuous: Creating a normal curve in Excel
- Continuous: Calculating normal distribution probabilities
- Next steps and additional resources
Taught by
Joseph Schmuller
Related Courses
Introduction to Artificial IntelligenceStanford University via Udacity Probabilistic Graphical Models 1: Representation
Stanford University via Coursera Statistics One
Princeton University via Coursera Intro to Statistics
Stanford University via Udacity Passion Driven Statistics
Wesleyan University via Coursera