Wauvel

Excel like a finance pro.

← The library

Compatibility function

HYPGEOMDIST

Returns the hypergeometric distribution; replaced by HYPGEOM.DIST.

Rarely usedDifficulty 1500 · AdvancedUsage rank #471 of 520
Practice · 2 questions →

When to use it

The hypergeometric probability mass. Replaced by HYPGEOM.DIST, which adds a cumulative flag.

The shape of it

Syntax
=HYPGEOMDIST(sample_s, number_sample, population_s, number_pop)

Worked examples

  • Exactly one

    =HYPGEOMDIST(1,4,8,20) → 0.363261

    Exactly 1 of 4 sampled from 20 with 8 successes.

  • No aces

    =HYPGEOMDIST(0,5,4,52) → 0.658842

    No aces in a five-card hand.

  • Exactly two

    =HYPGEOMDIST(2,4,8,20) → 0.381424

    Exactly 2.

Worth knowing

  • HYPGEOM.DIST(...,FALSE) is identical; TRUE adds the cumulative form.
  • Sampling without replacement.
  • Argument order: sample successes, sample size, population successes, population size.

Where it goes wrong

  • #NUM! for inconsistent counts.
  • Flagged by the Compatibility Checker.

Related

FORECASTMODEPERCENTILEQUARTILERANKSTDEV

Learn the moves here — or let Wauvel run them on your numbers.

Meet your AI CFO →

One CFO-grade Excel tip a week

A short, practical email for finance operators — functions, shortcuts, and the moves that save an afternoon. Free, unsubscribe anytime.