Excel Statistics Essential Training: 2
Offered By: LinkedIn Learning
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
- Sample considerations
- The central limit theorem
- T-statistic vs. z-statistic
- Introduction to confidence intervals
- Creating confidence intervals in Excel (proportions)
- Creating confidence intervals in Excel (means)
- How to test a hypothesis
- Five steps of hypothesis testing
- One-tailed vs. two-tailed tests
- Hypothesis test exercise (means)
- Hypothesis test exercise (proportions)
- Explanation of two population comparisons
- Comparing two populations (proportions)
- Comparing two populations (means)
- ANOVA: What is analysis of variance?
- Hypothesis test and the F-statistic
- What is regression?
- Regression terminology
- Linear regressions
- What are simulations?
- Monte Carlo simulation example
- Business simulation example
- Continue learning Excel statistics
Taught by
Joseph Schmuller
Related Courses
Statistics OnePrinceton 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