HYPGEOMDIST

Formulas / HYPGEOMDIST
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

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?
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.
Will the HYPGEOMDIST function be available in future versions of Excel?
No, the HYPGEOMDIST function may not be available in future versions of Excel.
What new functions will be used instead of HYPGEOMDIST?
New functions that provide improved accuracy and are better named and related to their usage will be used instead of HYPGEOMDIST.

Related Functions

Sourcetable Logo

Work smarter

Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.

Drop CSV