Imagine you have six tickets entered into a drawing with 100 total entries. A person will draw ten winners for the contest…what are the odds none of your tickets will be drawn? What about all six? In this movie, I’ll show you how to calculate the probability that specific outcomes occur for this type of scenario using the hypergeometric distribution in Excel. So if you’ve ever wondered what the HYPEGEOM.DIST function was for, here is your change to find out!

You can download the sample file for this movie from http://www.curtisfrye.com/Hypergeomet...

If you’d like to support my work here, please buy me a coffee or two through Ko-fi!
https://ko-fi.com/technologyandsociety