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

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

  1. Exactly 1 of 8 marked items in a sample of 4 from 20

    ABCDEF
    1FoundSampleMarkedTotal
    2148200.3633

    In F2: =HYPGEOM.DIST(A2, B2, C2, D2, FALSE) → 0.3633

    Try this example

Common mistakes

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.

Translate a whole formula

Try HYPGEOM.DIST in the playground

Related functions