Functions
HYPGEOM.DIST
Hypergeometric distribution
Try it
When to use it
When should I use HYPGEOM.DIST?
Use HYPGEOM.DIST to calculate the probability of a specific number of successes in a sample drawn without replacement from a finite population, such as quality control sampling or card-draw problems.
Used in
Syntax
HYPGEOM.DIST(x,n,k,pop,cumulative)Examples
=HYPGEOM.DIST(4,12,20,40,FALSE) // => 0.1092430027357725
=HYPGEOM.DIST(4,12,20,40,TRUE) // => 0.15042239124552811
=HYPGEOM.DIST(2,5,8,20,FALSE) // => 0.3973168214654283