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

Digital Signal Processing
École Polytechnique Fédérale de Lausanne via Coursera
Preparing for the AP* Statistics Exam
University of Houston System via Coursera
Solid Science: Research Methods
University of Amsterdam via Coursera
Preparing for the AP* Statistics Exam
Tennessee Board of Regents via edX
Processamento Digital de Sinais - Amostragem
Universidade Estadual de Campinas via Coursera