Files To Download for Chapter 04:
Excel file: Excel2013StatisticsChapter04.xlsm (Excel File to use while watching video)
PDF File: Ch04PDFBusn210.pdf (PDF File to use while watching video)
No Data Sets for Homework Problems for this chapter.
Videos To Watch:
Excel 2013 Statistical Analysis #25: Probability Basics: Sample Points, Events & Event Probabilities (31:06 mins)
Excel 2013 Statistical Analysis #26: Combinations & Permutations and Listing Sample Points (07:35 Mins)
Excel 2013 Statistical Analysis #27: Adding Law of Probability for OR Events (12 Examples) (25:26 mins)
Excel 2013 Statistical Analysis #28: Multiplication Law of Probability for AND Events (16 Examples) (33:17 mins)
Excel 2013 Statistical Analysis #29: Create Joint Probability Table from Raw Data & Calc Event Probs (6:30 mins)
Excel 2013 Statistical Analysis #30: Bayes’ Theorem to Calculate Posterior Probabilities (16:40 mins)
Extra Video:
Excel
Magic Trick 1178: Conditional / AND Percentage: PivotTable Slicer, COUNTIFS or
DCOUNTA? (14:13 min)
Extra Workbook that goes with video #1178:
EMT1178.xlsx