Excel functions / Statistics
HYPGEOMDIST function
The chance of exactly a number of successes in a sample drawn without putting anything back. The older form of HYPGEOM.DIST.
Syntax
=HYPGEOMDIST(sample_s, number_sample, population_s, number_pop)
Arguments
sample_s: The number of successes in the sample.number_sample: The size of the sample.population_s: The number of successes in the whole population.number_pop: The size of the population.
When to use it
HYPGEOMDIST is the older form of HYPGEOM.DIST with FALSE: the chance of exactly a number of successes.
Examples
Exactly 1
A B C D E F 1 Found Sample Marked Total 2 1 4 8 20 0.3633 In F2:
=HYPGEOMDIST(A2, B2, C2, D2)→ 0.3633
Common mistakes
- Newer form. HYPGEOM.DIST also gives the cumulative chance.
HYPGEOMDIST in other languages
Excel shows function names in its own language. In these languages it also puts a semicolon between arguments where English has a comma.
- Czech: HYPGEOMDIST
- Danish: HYPGEOFORDELING
- Dutch: HYPERGEO.VERD
- Finnish: HYPERGEOM.JAKAUMA
- French: LOI.HYPERGEOMETRIQUE
- German: HYPGEOMVERT
- Hungarian: HIPERGEOM.ELOSZLÁS
- Italian: DISTRIB.IPERGEOM
- Norwegian: HYPGEOM.FORDELING
- Polish: ROZKŁAD.HIPERGEOM
- Portuguese (Brazil): DIST.HIPERGEOM
- Portuguese (Portugal): DIST.HIPERGEOM
- Russian: ГИПЕРГЕОМЕТ
- Spanish: DISTR.HIPERGEOM
- Swedish: HYPGEOMFÖRD
- Turkish: HİPERGEOMDAĞ
Try HYPGEOMDIST in the playground
Related functions
- HYPGEOM.DIST: The hypergeometric distribution: the chance of a number of successes in a sample drawn without putting anything back.