Calculate 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

`=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)`

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.

The HYPGEOMDIST function returns the hypergeometric distribution. It is used to sample without replacement from a finite population and calculates the probability of a given number of sample successes.

No, the HYPGEOMDIST function may not be available in future versions of Excel.

New functions that provide improved accuracy and are better named and related to their usage will be used instead of HYPGEOMDIST.