Channel: ExcelIsFun

Category: Education

Tags: statistics conditional probability rulebusiness statistical analysisdata analysishighline collegeexcel statisticsmike girvinesa 19countifs functionscalculate conditional probabilitymicrosoft 365 excelconditional probabilitybusn 210mike excelisfun girvinconditional probability rulestatistical analysiscross tabulated frequency tableexcelisfunexcel statistical analysisjoint probability tablechapter 4excel conditional probability

Description: Download Excel File: excelisfun.net/files/Ch04-ESA.xlsm pdf notes: excelisfun.net/files/Ch04-ESA.pdf Learn about: Topics: 1. (00:00) Introduction 2. (00:40) Define Conditional Probability 3. (02:58) Calculate Conditional Probability From a Cross Tabulated Frequency Table using worksheet formulas 4. (05:38) Two ways to phrase a Conditional Probability statement. 5. (05:54) Key to understanding Conditional Probability calculations from a Cross Tabulated Table or from the Statistics Conditional Probability Rule 6. (06:46) Calculate Conditional Probability from a Joint Probability Table using worksheet formulas 7. (08:30) Statistics Conditional Probability Rule 8. (09:25) Calculate Conditional Probability from the “Given That” Probability and the AND Probability using worksheet formulas. 9. (10:19) Calculate Conditional Probability from a Data Set using COUNTIFS functions. 10. (14:32) Summary of video 11. (15:07) Closing and Video Links