HYPGEOM.DIST Function
Returns the probability of a number of successes when sampling without replacement.
Category
Statistical
Available in
Excel 2010+, Microsoft 365
Returns
A number
Overview
HYPGEOM.DIST is for drawing a sample from a small, fixed group without putting items back — inspecting part of a shipment, picking names from a list. Each pick changes the odds of the next one, so BINOM.DIST would be slightly off.
With cumulative FALSE it's exactly sample_s successes in the sample; with TRUE, at most sample_s.
Syntax
Arguments
| Argument | Required? | What it does |
|---|---|---|
| sample_s | Yes | Successes in the sample. |
| number_sample | Yes | Size of the sample. |
| population_s | Yes | Successes in the whole population. |
| number_pop | Yes | Size of the population. |
| cumulative | Yes | TRUE for the chance of at most this many; FALSE for exactly this many. |
Examples
Example 1 — Will inspection catch a faulty unit?
A shipment of 50 units contains 4 faulty ones. The inspector checks 10.
| A | B | |
|---|---|---|
| 1 | Measure | Value |
| 2 | Shipment | 50 |
| 3 | Faulty in shipment | 4 |
| 4 | Units checked | 10 |
| 5 | Finds none | 0.3968 |
| 6 | Finds at least one | 0.6032 |
There's about a 40% chance the inspection misses every faulty unit.
Example 2 — Exactly two faulty units found
The same shipment and sample.
Returns about 0.152.
Common mistakes
- Argument order. Sample figures come first, then population figures.
- #NUM! A count is negative, sample_s is more than number_sample or population_s, or the sample is bigger than the population.
Notes
- HYPGEOM.DIST replaces the older HYPGEOMDIST function.
- Related functions: BINOM.DIST, COMBIN.

Author
Kyle Stott
Certified Microsoft Excel Expert
Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.