Excel - Hypergeometric Distribution

ISM Course Excel
Part 03.15
The corresponding playlist can be found here:
Excel (en): • Excel (en)
Additional Content on working with Excel can be found here:
Visual Basic for Applications: • Visual Basic for Appli...
Additional information on the International School of Management (ISM) and the offered study programs can be found at:
www.ism.de
#excel #microsoft #ism

[@dylanknox3317]

Extremely helpful, thank you for helping me pass stats

[@DivinePenguin00]

Great video, very informative and easy to understand. Does anyone know why this function doesn't work in Google Sheets?

[@jensk.perret6794]

I would guess one of two possibilities: a) Sheets is no perfect 1 to 1 Excel clone. So not every function is copied as is or at all. b) They might use a different name for the function.

[@bridparker8651]

Hi thank you for the video, when calculating hypergeometric distribution is a false value of 0 significant or does it simply mean the probability of getting that outcome is equal to 0?

[@jensk.perret6794]

Using FALSE or 0 means you are using the probability/density function P(X = a) instead of the cumulative distribution function P(X >= a) or P(X

[@azelya2319]

Thank you for the video! What if we have 3 categories, I mean like in the box we have 3 colors and we want to take 3 of them which are 1 red, 1 blue and 1 yellow, how do we enter the numbers?

[@jensk.perret6794]

In the context of either the Binomial or the Hypergeometrical distribution each time you focus on but one of the categories, so the overall number of categories does not matter. So if I focus on red all other categories are summarized as non-red. If you really need more cases, as in your example with a distinction with red, blue and yellow then you have to use a multivariate hypergeometric distribution. As far as I recall you would have to implement it on your own in Excel but considering that the probability function is rather straight forward it should easily be possible. You can find it for example in the corresponding paragraph in the Wikipedia entry on the hypergeometric distribution at: en.wikipedia.org/wiki/Hypergeometric_distribution

[@sakshi1480]

Wao its nice

[@justin2icy]

What if I wanted to find the average number of red balls in the sample size of 10?

[@jensk.perret6794]

In this case you are talking about an average calculation and can use the formula: Average = nK/N.

[@glrbrasil]

Would this also work on Google Sheets? I've tried the formula they recommend with their exact example and it just doesn't work, here's how they describe it: support.google.com/docs/answer/3094004?hl=en

[@jensk.perret6794]

In the video I used the formula with a point HYPGEOM.DIST This is the current version of the formula to use in Excel. At 2:50 you see also the older version of the formula HYPGEOMDIST without a point. In Google Docs you have to use this old type of the formula.

[@DivinePenguin00]

@@jensk.perret6794 This isn't necessarily true. Yes, HYPGEOMDIST works, but no function allows HYPGEOM.DIST. So Sheets is very limited in what you can do with hypergeometric distributions.