Description Computes the hypergeometric distribution. This is used in cases of sampling without replacement, and is especially important for determining the likelihood of finding defective parts in a production run.
For cases of sampling with replacement, use BINOMDIST.
Syntax HYPGEOMDIST ( x, n, M, N)
| Argument | Description |
|---|---|
| x | A positive integer indicating the number of successes in the sample. It must be smaller than n and M. Decimal values will be truncated to integers. |
| n | A positive integer indicating the size of the sample. It must be smaller than N. Decimal values will be truncated to integers. |
| M | A positive integer indicating the number of successes in the total population. It must be smaller than N. Decimal values will be truncated to integers. |
| N | A positive integer indicating the size of the total population. Decimal values will be truncated to integers. |
Equation
Examples Say 10 sweaters on a store rack have been inspected, and 2 of the sweaters have flaws. This function calculates the probability that, if you buy four sweaters, none of them will have flaws.
This function returns 0.33:
HYPGEOMDIST (0,4,2,10)
See Also BETADIST, BINOMDIST, CHIDIST, COMBIN, CRITBINOM, FDIST, NORMDIST, POISSON
