Download Excel File: https://excelisfun.net/files/EMT1719.xlsx
Learn all about joint probability tables, including how to use an Excel PivotTable to create them in 20 seconds.
Topics:
1. (00:00) Introduction.
2. (00:36) What is a Joint Probability Table?
3. (00:59) What is a Joint Probability?
4. (01:26) What is a Marginal Probability?
5. (01:43) Using Joint Probability Table to calculate Joint Probability.
6. (01:54) Using Joint Probability Table to calculate Marginal Probability.
7. (02:03) Using Joint Probability Table to calculate Conditional Probability.
8. (02:53) Use PivotTable to create Joint Probability Table from data set with pre-made number categories with the Show Values As % of Grand Total feature.
9. (03:58) More about how Conditional Probability Calculations works in a Joint Probability Table.
10. (04:48) Use PivotTable to create Joint Probability Table from data set with numbers that require we use Group By feature in PivotTable.
11. (06:00) Bonus Trick: Create a Conditional Probability Table with the Show Values As % of Column Total or % of Row Total feature.
12. (06:45) Summary, Closing and Video Links