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

When to use it

HYPGEOMDIST is the older form of HYPGEOM.DIST with FALSE: the chance of exactly a number of successes.

Examples

  1. Exactly 1

    ABCDEF
    1FoundSampleMarkedTotal
    2148200.3633

    In F2: =HYPGEOMDIST(A2, B2, C2, D2) → 0.3633

    Try this example

Common mistakes

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.

Translate a whole formula

Try HYPGEOMDIST in the playground

Related functions