YoVDO

Excel Statistics Essential Training: 1

Offered By: LinkedIn Learning

Tags

Statistics & Probability Courses Data Analysis Courses Probability Courses Normal Distribution Courses Descriptive Statistics Courses Binomial Distribution Courses Histograms Courses

Course Description

Overview

Learn statistics with the help of Microsoft Excel.

Syllabus

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

Taught by

Joseph Schmuller

Related Courses

Introduction to Artificial Intelligence
Stanford 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