1) Download files:
Excel File that goes with Videos: Ch05-ESA.xlsm
Excel Data Source Fie that goes along with video #24:
MonclaireGolf.xlsx
PDF Notes that go along with Videos:
Ch05-ESA.pdf
Excel Data Source Fie that goes along with Textbook Homework Problem #17:
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, then you download homework templates from Canvas, read the textbook, and complete textbook homework problems for practice.
4) After you are done studying the above videos and textbook work, download the Test #5 file and the test csv file to the Busn 210 class folder you created in video #1.
Here are the
files:
Test05
Excel data file
need for test
After you have completed your test, then upload to the Home Area of Canvas.