This course aims to teach students how to utilize Excel for statistical analysis. By the end of the course, learners will be able to display data, calculate descriptive statistics, probabilities, work with probability distributions, the normal model, and the Central Limit Theorem. They will also learn to construct confidence intervals and perform hypothesis testing for means and proportions, as well as delve into linear and multiple regression analysis. The course is designed for individuals interested in applying Excel for statistical purposes.
Overview
Syllabus
Using Excel to Display Data.
Using Excel to Calculate Descriptive Statistics.
Using Excel to Calculate Probabilities.
Using Excel in Probability Distributions.
Using Excel in the Normal Model.
Using Excel with the Central Limit Theorem.
Using Excel to Construct One Sample Confidence Intervals for Means and Proportions.
Using Excel to Construct Two Sample Confidence Intervals for Means and Proportions.
Using Excel to Perform One Sample Hypothesis Testing for Means and Proportions.
Using Excel to Perform Two Sample Hypothesis Testing for Means and Proportions.
Using Excel in Linear and Multiple Regression.
Taught by
Kimberly Brehm
