YoVDO

Excel Statistics Essential Training: 2

Offered By: LinkedIn Learning

Tags

Statistics & Probability Courses Hypothesis Testing Courses Confidence Intervals Courses Sampling Courses Monte Carlo Simulation Courses ANOVA Courses

Course Description

Overview

Learn more statistics fundamentals. Find out how to perform hypothesis tests, ANOVA, regression, and correlation testing and run simulations in Microsoft Excel.

Syllabus

Introduction
  • Using Excel for statistics
  • What you need to know
  • Exercise files
  • Tool pack
1. Sampling
  • Sample considerations
  • The central limit theorem
  • T-statistic vs. z-statistic
2. Confidence Intervals
  • Introduction to confidence intervals
  • Creating confidence intervals in Excel (proportions)
  • Creating confidence intervals in Excel (means)
3. Hypothesis Tests
  • How to test a hypothesis
  • Five steps of hypothesis testing
  • One-tailed vs. two-tailed tests
  • Hypothesis test exercise (means)
  • Hypothesis test exercise (proportions)
4. Comparing Two Populations
  • Explanation of two population comparisons
  • Comparing two populations (proportions)
  • Comparing two populations (means)
5. ANOVA: Analysis of Variance
  • ANOVA: What is analysis of variance?
  • Hypothesis test and the F-statistic
6. Regression
  • What is regression?
  • Regression terminology
  • Linear regressions
7. Simulation
  • What are simulations?
  • Monte Carlo simulation example
  • Business simulation example
Conclusion
  • Continue learning Excel statistics

Taught by

Joseph Schmuller

Related Courses

Statistics One
Princeton University via Coursera
Intro to Statistics
Stanford University via Udacity
Passion Driven Statistics
Wesleyan University via Coursera
Statistics
San Jose State University via Udacity
Introduction to Statistics: Inference
University of California, Berkeley via edX