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

Design of Computer Programs
Stanford University via Udacity
Intro to Statistics
Stanford University via Udacity
Health in Numbers: Quantitative Methods in Clinical & Public Health Research
Harvard University via edX
Mathematical Biostatistics Boot Camp 1
Johns Hopkins University via Coursera
Statistics
San Jose State University via Udacity