Using Excel to Construct One Sample Confidence Intervals for Means and Proportions
8
Using Excel to Construct Two Sample Confidence Intervals for Means and Proportions
9
Using Excel to Perform One Sample Hypothesis Testing for Means and Proportions
10
Using Excel to Perform Two Sample Hypothesis Testing for Means and Proportions
11
Using Excel in Linear and Multiple Regression
Description:
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.