HYPGEOMDIST
Returns the hypergeometric probability of exactly sample_s successes (legacy name).
HYPGEOMDIST(sample_s, number_sample, population_s, number_pop) is the probability mass
form of HYPGEOM.DIST.
The Formualizer engine in this repository at 0.14.0 plus unreleased changes computes the example results. Known differences from Excel are listed on this page.
Syntax
=HYPGEOMDIST(sample_s, number_sample, population_s, number_pop)
Arguments
| Argument | Type | Required | Default |
|---|---|---|---|
sample_s | number | Required | — |
number_sample | number | Required | — |
population_s | number | Required | — |
number_pop | number | Required | — |
How it works
Maps to HYPGEOM.DIST with a final FALSE argument for point probability. With s successes in the population, the probability at k is the number of ways to pick k successes and the remaining failures divided by the number of possible samples. The counts must describe a sample drawn without replacement.
Remarks
- All arguments are truncated to integers.
Error cases
- Returns
#NUM!whensample_sis negative, aboveMIN(number_sample, population_s), or belowMAX(0, number_sample - number_pop + population_s). - Returns
#NUM!whennumber_sample <= 0,number_sample > number_pop,population_s <= 0,population_s > number_pop, ornumber_pop <= 0.
Examples
Find the probability of exactly two successes without replacement.
Formula =HYPGEOMDIST(2,5,8,20)
Expected result 0.397316821465427
Try this formula
This editor runs the published Formualizer 0.14.0 package, so the last digits can differ and functions newer than that release return #NAME?.
Compare the probability of exactly three successes in the same experiment.
Formula =HYPGEOMDIST(3,5,8,20)
Expected result 0.238390092879257
Try this formula
This editor runs the published Formualizer 0.14.0 package, so the last digits can differ and functions newer than that release return #NAME?.
Evaluate a sample with no successes.
Formula =HYPGEOMDIST(0,5,8,20)
Expected result 0.0510835913312692
Try this formula
This editor runs the published Formualizer 0.14.0 package, so the last digits can differ and functions newer than that release return #NAME?.
The successes in the sample cannot outnumber the sampled items.
Formula =HYPGEOMDIST(6,5,8,20)
Expected result #NUM!
Try this formula
This editor runs the published Formualizer 0.14.0 package, so the last digits can differ and functions newer than that release return #NAME?.
Find the chance of drawing exactly one success in four draws from 20 items with eight successes.
Formula =HYPGEOMDIST(1,4,8,20)
Expected result 0.363261093911247
Try this formula
This editor runs the published Formualizer 0.14.0 package, so the last digits can differ and functions newer than that release return #NAME?.