Download Excel File: https://excelisfun.net/files/EMT1818.xlsx
Learn about how to create a joint probability table from a cross tabulated frequency distribution, then five tricks for calculating probabilities. Everyone should know this – not just staticticians.
Topics:
1. (00:00) Introduction
2. (00:04) Calculate Joint Probability Table from Cross Tabulated Counts with Excel Formulas.
3. (02:55)Makes probability calculations from a Joint Probability Table.
4. (03:14) Single Conditional Probability
5. (03:27) AND Logical Test Probability (Joint)
6. (03:49) OR Logical Test Probability (Mutually Exclusive)
7. (04:20) OR Logical Test Probability (NOT Mutually Exclusive)
8. (05:02) Conditional Probability
9. (05:40) Closing, Video Links

#excel
#excelisfun
#excelformulas
#excelfunctions
#dynamicarrays
#array #arrayformula
#statistics
#excelsolutions
#joint
#probability
#probabilitytricks
#mikegirvin
#analytics
#analysis
#dataanalysis
#dataanalytics
#excelmvp