HYPGEOMDIST

Definition: HYPGEOMDIST is a function that returns the hypergeometric distribution for a specified set of parameters.

Syntax: =HYPGEOMDIST(sample_s, number_sample, population_s, number_pop, [cumulative])

Situation: This formula is suitable when you need to find the hypergeometric distribution for a specified set of parameters.

Example: If you have a population of 1000 with 200 successes, and take a sample of 50 with 10 successes, the probability of drawing exactly 2 successes can be found using the formula =HYPGEOMDIST(2, 50, 200, 1000, FALSE), which returns 0.0014.