In this article
HYPGEOM.DIST gives the chance of k successes when you draw a sample without putting items back, e.g. defective units found in an inspection sample.
Advertisement
Syntax
=HYPGEOM.DIST(sample_s, number_sample, population_s, number_pop, cumulative)| Argument | What it means |
|---|---|
sample_s |
Successes in the sample |
number_sample |
Sample size |
population_s |
Successes in the population |
number_pop |
Population size |
cumulative |
TRUE/FALSE |
Examples
Example 1
=ROUND(HYPGEOM.DIST(A2,B2,C2,D2,FALSE),4)Result: 0.8147. See the worked example table below for more cases.
HYPGEOM.DIST in practice
Where you will use it
- Acceptance sampling in incoming goods inspection
- Audit sampling
- Card and lottery odds
Worked example
| k | Sample | Defects in lot | Lot size | Formula | Result |
|---|---|---|---|---|---|
| 0 | 20 | 5 | 500 | =ROUND(HYPGEOM.DIST(A2,B2,C2,D2,FALSE),4) | 0.8147 |
| 1 | 20 | 5 | 500 | =ROUND(HYPGEOM.DIST(A3,B3,C3,D3,FALSE),4) | 0.1712 |
| 2 | 50 | 10 | 1000 | =ROUND(HYPGEOM.DIST(A4,B4,C4,D4,FALSE),4) | 0.0743 |
Results calculated in Excel.
Mistakes people make
| Mistake | What to do instead |
|---|---|
| Using BINOM for small lots | Without replacement in small populations needs HYPGEOM |
| Sample larger than population | #NUM! |
Related functions
📚 Part of the free Excel course: Beginner → Expert · Try it in the Formula Lab or ask the AI Helper.
Advertisement
✨ Ask AI about this article
Stuck on a step? Ask a question and the AI answers using this article.
Free · AI can be wrong