Channel: ExcelIsFun

Category: Education

Tags: business statistical analysisdata analysisfilter array functionaddition law of probabilitycountifs functionhighline collegeexcel statisticsmike girvinand logical testprobabilities from cross tabulated tableesa 18or logical testcross tabulated tablerows functionmicrosoft 365 excelpivottable probabilitybusn 210mike excelisfun girvinstatistical analysisexcelisfunexcel 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 Addition Law of Probability. See many examples of different situations where you use OR Logical tests and the Addition Law: Topics: 1. (00:00) Introduction 2. (00:41) Look at formulas for Addition Law of Probability 3. (02:55) OR Probability from Data Set. COUNTIFS, FILTER and ROWS functions. 4. (07:20) OR Probability from Frequency Distribution. Worksheet Formulas. 5. (09:00) OR Probability from Cross Tabulated Report. Worksheet Formulas. 6. (10:36) OR Probability from Given Pre-Calculated Probabilities for single events and an intersection event (AND event). Worksheet Formulas. 7. (12:04) PivotTable and formulas from a two column data set 8. (14:26) PivotTable and formulas from a one column data set 9. (16:39) Summary of video 10. (17:05) Closing and Video Links