HYPGEOMDIST Function Explained
The HYPGEOMDIST 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 of a given size containing a given number of successes. It takes four arguments: sample_s, number_sample, population_s, and number_pop.
HYPGEOMDIST Function Syntax
HYPGEOMDIST(sample_s, number_sample, population_s, number_pop)
- 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.