Formualizer Docs

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

ArgumentTypeRequiredDefault
sample_snumberRequired—
number_samplenumberRequired—
population_snumberRequired—
number_popnumberRequired—

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! when sample_s is negative, above MIN(number_sample, population_s), or below MAX(0, number_sample - number_pop + population_s).
  • Returns #NUM! when number_sample <= 0, number_sample > number_pop, population_s <= 0, population_s > number_pop, or number_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?.

Implementation

Engine source

On this page