Excel Statistical Analysis 18: Addition Law of Probability, OR Logical Test: Formulas & PivotTables
ExcelIsFun ExcelIsFun
991K subscribers
7,116 views
0

 Published On Feb 21, 2022

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

show more

Share/Embed