HYPGEOM.DIST Function Explained
The HYPGEOM.DIST Function in Microsoft Excel calculates the hypergeometric distribution, which is the probability of a given number of successes in a sample of a given size from a population without replacement. It takes four arguments: sample_s, number_sample, population_s, and number_pop. The function returns the probability of number_sample successes in a sample of size sample_s from a population of size population_s with number_pop successes.
HYPGEOM.DIST Function Syntax
HYPGEOM.DIST(sample_s, number_sample, population_s, number_pop, cumulative)
- sample_s: The number of successes in the sample.
- number_sample: The size of the sample.
- population_s: The number of successes in the population.
- number_pop: The size of the population.
- cumulative: A logical value that determines the form of the function. If cumulative is TRUE, HYPGEOM.DIST returns the cumulative distribution function; if FALSE, it returns the probability mass function.