Excel functions / Statistics
HYPGEOM.DIST function
The hypergeometric distribution: the chance of a number of successes in a sample drawn without putting anything back.
Syntax
=HYPGEOM.DIST(sample_s, number_sample, population_s, number_pop, cumulative)
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.cumulative: TRUE for the chance of sample_s successes or fewer; FALSE for exactly sample_s.
When to use it
HYPGEOM.DIST gives the chance of a number of successes in a sample drawn without putting anything back: defective items in a sample from a small batch, winners in a draw.
Examples
Exactly 1 of 8 marked items in a sample of 4 from 20
A B C D E F 1 Found Sample Marked Total 2 1 4 8 20 0.3633 In F2:
=HYPGEOM.DIST(A2, B2, C2, D2, FALSE)→ 0.3633
Common mistakes
- Large populations. When the population is large compared with the sample, BINOM.DIST gives nearly the same answer.
HYPGEOM.DIST 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: HYPGEOM.DIST
- Danish: HYPGEO.FORDELING
- Dutch: HYPGEOM.VERD
- Finnish: HYPERGEOM_JAKAUMA
- French: LOI.HYPERGEOMETRIQUE.N
- German: HYPGEOM.VERT
- Hungarian: HIPGEOM.ELOSZLÁS
- Italian: DISTRIB.IPERGEOM.N
- Norwegian: HYPGEOM.FORDELING.N
- Polish: ROZKŁ.HIPERGEOM
- Portuguese (Brazil): DIST.HIPERGEOM.N
- Portuguese (Portugal): DIST.HIPGEOM
- Russian: ГИПЕРГЕОМ.РАСП
- Spanish: DISTR.HIPERGEOM.N
- Swedish: HYPGEOM.FÖRD
- Turkish: HİPERGEOM.DAĞ
Try HYPGEOM.DIST in the playground
Related functions
- BINOM.DIST: The chance of a number of successes in a set number of tries, each with the same chance.
- COMBIN: How many ways to choose a number of items from a group, when the order does not matter.
- HYPGEOMDIST: The chance of exactly a number of successes in a sample drawn without putting anything back. The older form of HYPGEOM.DIST.