Download Excel File: https://excelisfun.net/files/Ch05-ESA.xlsm PDF notes file: https://excelisfun.net/files/Ch05-ESA.pdf
Learn about Hypergeometric Distribution and HYPGEOM.DIST Function to calculate AND Logical Test probabilities for when you have Conditional Probabilities Across a Fixed Number of Trials.
Topics:
1. (00:00) Introduction
2. (00:30) AND Logical Test with Conditional Probabilities for Pulling Two Straight Queens in Two Tries. Long Hand Formula
3. (04:55) HYPGEOM.DIST Function to calculate AND Logical Test probabilities for when you have Conditional Probabilities Across a Fixed Number of Trials. For Hypergeometric Distribution
4. (06:35) Pulling 2 Queen Cards in Five Tries Probability from sample points and with HYPGEOM.DIST function
5. (09:01) HYPGEOM.DIST Function to list all probabilities in a Hypergeometric Experiment
6. (10:11) HYPGEOM.DIST Function with cumulative argument set to TRUE or 1 to add cumulatively the probabilities from low x to given x
7. (11:11) Economic Banking Example with HYPGEOM.DIST function
8. (15:30) Summary of video
9. (16:35) Closing and Video Links