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
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