1) Download files:
Excel File that goes with Videos: Section05-ESA.xlsm
Excel Data Source Fie that goes along with video #25:
MonclaireGolf.xlsx
PDF Notes that go along with Videos:
Section05-ESA.pdf
Excel Homework for Section 5: Section05-HW.xlsx
, Coldstream12.xlsx
2) Click below links to watch class videos at YouTube:
Excel Statistical Analysis 23: Discrete Probability Distributions: Terms and Definitions (13:23 min)
Excel Statistical Analysis 24: Build Discrete Probability Distributions with Worksheet Formulas (28:43 min)
Excel Statistical Analysis 25: Import Excel data: Build PivotTable Discrete Probability Distribution (12:49 min)
Excel Statistical Analysis 26: Accounting & Finance Discrete Probability Distribution Examples (09:37 min)
Excel Statistical Analysis 27: Binomial Probability Distributions. BINOM.DIST.RANGE Function & Chart (32:03 min)
Excel Statistical Analysis 28: Poisson Distribution, POISSON.DIST function and Poisson Column Chart (21:54 min)
Excel Statistical Analysis 29: HYPGEOM.DIST Function for Conditional Probabilities Across # Trials (16:56 min)
Extra Video (not required, but if you really enjoy Excel, you should watch for fun): DROP, TAKE & VSTACK: How They Are Useful! Spilled Frequency Distribution with Total Row. EMT 1788 (12:13 min)
3) When you are done studying the videos and completing the examples from the video for practice, then you download homework Excel File and complete homework problems for practice.