Download Excel File: https://excelisfun.net/files/Ch04-ESA.xlsm pdf notes: https://excelisfun.net/files/Ch04-ESA.pdf
Learn about 6 different methods for calculating probabilities using Bayes Theorem.
Topics:
1. (00:00) Introduction
2. (00:16) Introduction to Baye’s Theorem with a CPA Test Score Example
3. (03:17) Probabilities from Table of Data using Worksheet Formulas and COUNTIFS function
4. (07:22)Probabilities from a Cross Tabulated Frequency Distribution created with a PivotTable, then worksheet formulas
5. (09:55)Probabilities from a Joint Probability created with a PivotTable, then worksheet formulas
6. (12:06) Bayes Theorem using Tabular Approach – CPA Score example
7. (12:50) Close Look at Baye’s Theorem Formula
8. (16:18) Bayes Theorem using SUMPRODUCT Function Approach – CPA Score example
9. (17:21) Bayes Theorem using Probability Tree – CPA Score example
10. (17:50) Bayes Theorem using Tabular Approach – Stolen Items From Garage example
11. (21:07) Summary of video
12. (12:37) Closing and Video Links