HYPGEOMDIST
Formulas / HYPGEOMDISTCalculate the hypergeometric distribution.
HYPGEOMDIST( sample_s, number_sample, population_s, number_pop )
- sample_s - required; number of successes in the sample
- number_sample - required; size of the sample
- population_s - required; number of successes in the population
- number_pop - required; size of the population
Examples
=HYPGEOMDIST(2, 10, 5, 2)This example will determine the hypergeometric distribution for when there are 2 successes in a population of 10, 5 trials and 2 successes in the sample. This example shows how the HYPGEOMDIST function can be used to determine the probability of getting a certain number of successes in a sample from a given population.
=HYPGEOMDIST(3, 20, 10, 7)This example will determine the hypergeometric distribution for when there are 3 successes in a population of 20, 10 trials and 7 successes in the sample. This example shows how the HYPGEOMDIST function can be used to calculate the probability of success in a given population when the sample size is larger than the population size.
=HYPGEOMDIST(4, 30, 15, 8)
Summary
The HYPGEOM.DIST function returns the probability of a given number of sample successes, given the number of successes in the population, the number of successes in the sample, and the size of the population. It is used for problems with a finite population size and each observation is either a success or a failure, with sampling done without replacement.
- The HYPGEOMDIST function returns the probability of a given number of successes in a sample of size k from a population of size N, when the population consists of both successes and failures.
- The HYPGEOMDIST function is used to sample without replacement from a finite population, meaning each item chosen is removed from the population, preventing it from being chosen again.
Frequently Asked Questions
What is the HYPGEOMDIST function?
Will the HYPGEOMDIST function be available in future versions of Excel?
What new functions will be used instead of HYPGEOMDIST?
