Channel: ExcelIsFun

Category: Education

Tags: business statistical analysiscross tabulated frequency distributiondata analysisexcel bayes’ theoremcountifs functionhighline collegetabular methodexcel statisticsmike girvinstolen out of garagebayes’ theoremcpa scoremicrosoft 365 excelesa 22busn 210mike excelisfun girvinsumproduct functionstatistical analysisprobability treeexcelisfunexcel statistical analysisjoint probability tablechapter 4pivottable

Description: Download Excel File: excelisfun.net/files/Ch04-ESA.xlsm pdf notes: 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