Channel: ExcelIsFun

Category: Education

Tags: business statistical analysisdata analysishighline collegeexcel statisticsmike girvinand logical testand logical test probabilityconditional probabilitiesmultiplication law of probabilityesa 21microsoft 365 exceljoint probabilitymarginal probabilitiesbusn 210mike excelisfun girvinstatistical analysisprobability treeexcelisfunexcel statistical analysisconditional probabilities times marginal probabilitieschapter 4

Description: Download Excel File: excelisfun.net/files/Ch04-ESA.xlsm pdf notes: excelisfun.net/files/Ch04-ESA.pdf Learn about the Multiplication Law of Probability to calculate AND Logical Test Probabilities. Learn how to build a probability tree too. Topics: 1. (00:00) Introduction 2. (00:17) Look back at Conditional Formatting Probability Rule and how it related to the Multiplication Law of Probability 3. (01:27) Multiplication Law of Probability for Dependent and Independent Events 4. (02:52) Define Independent Events 5. (03:38) Rule of Independence 6. (05:21) Use Multiplication Rule to calculate Probability that two stocks with both go up 7. (05:58) Use Multiplication Rule to calculate Probability that you can pull two Queen Cards in Succession 8. (06:51) Use Multiplication Rule to calculate Probability that you can make sales, back to back, in two sales call 9. (07:35) Create Probability Tree on Paper 10. (09:28) Create Probability Tree in Excel 11. (10:12) Heart Attack and Smoking Probability Tree Example 12. (10:42) Summary of video 13. (11:08) Closing and Video Links