Learn to harness the power of Excel for statistical analysis in this comprehensive 4.5-hour tutorial. Master techniques for data display, descriptive statistics calculation, probability computations, and working with various probability distributions. Explore the application of Excel in the normal model and Central Limit Theorem. Gain proficiency in constructing confidence intervals and performing hypothesis testing for both one and two sample means and proportions. Conclude by delving into linear and multiple regression analysis using Excel's robust features.
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
