Files To Download for Chapter 05:
Excel file 1: Excel2013StatisticsChapter05.xlsm
Excel file 2: Excel2013StatisticsChapter05SecondFile.xlsm
Excel file 3: Excel2013StatisticsChapter05ThirdFile.xlsm
PDF file: Ch05PDFBusn210.pdf
No Data Sets for Homework Problems for this chapter.
Videos To Watch:
Excel 2013 Statistical Analysis #31: Create Discrete Probability Distribution, Calculate Mean and SD (32:07 min)
Excel 2013 Statistical Analysis #32: Expected Value Standard & Deviation Discrete Prob. Distribution (9:39 min)
Excel 2013 Statistical Analysis #33: Binomial Probability Distributions: Tables, Charts, Functions (37:50 min)
Excel 2013 Statistical Analysis #34: POSSION Distribution and POISSON.DIST Function (23:44 min)
Excel 2013 Statistical Analysis #35: Hypergeometric Distribution and HYPGEOM.DIST Function (7:50 min)
Not required for class, but you can watch it if you want: Excel 2013 Statistical Analysis #36: Dynamic Binomial Probability Charts (3 Examples) (19:40 min)
Extra Videos:
Excel Magic Trick
1209: BINOM.DIST.RANGE Function for Calculating Binomial Probabilities
(06:11 min)
Extra Workbook that goes with video #1209:
EMT1206-1209.xlsx