Using Excel in Statistics
Offered By: Kimberly Brehm via YouTube
Course Description
Overview
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.
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
Related Courses
Introduction to Computational Finance and Financial EconometricsUniversity of Washington via Coursera Excel 2010
Miríadax The Finance of Retirement & Pensions
Stanford Graduate School of Business via NovoEd Einführung in die Wahrscheinlichkeitstheorie
Johannes Gutenberg University Mainz via iversity Introduction to VBA/Excel Programming
Cal Poly Pomona via Open Education by Blackboard