Channel: ExcelIsFun

Category: Education

Tags: business statistical analysisdata analysisprobability in excelhypgeom.dist functionhighline collegehypergeometric distributionexcel statisticsmike girvinconditional probabilities across a fixed number of trialsesa 29excel statistics functionmicrosoft 365 excelbusn 210mike excelisfun girvinstatistical analysischapter 5excelisfunexcel statistical analysisand logical test probabilities

Description: Download Excel File: excelisfun.net/files/Ch05-ESA.xlsm PDF notes file: 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