This function returns the hypergeometric distribution.
HYPGEOM.DIST(x,n,M,N,cumulative)
The arguments are as follows, and are truncated if not integers:
| Argument | Description |
|---|---|
| x | An integer representing the number of successes in the sample |
| n | An integer representing the size of the sample |
| M | An integer representing the number of successes in the population |
| N | An integer representing the size of the population |
| cumulative | A logical value that determines the form of the function. If cumulative is TRUE, then this function returns the cumulative distribution function; if this argument is FALSE, it returns the probability mass function |
If any argument is nonnumeric, the function returns the #VALUE! error value.
Accepts numeric data for all arguments except cumulative. Returns numeric data.
HYPGEOM.DIST(A22,B23,62,1000,C10)
HYPGEOM.DIST(R22C11,R22C12,R34C14,R35C15,R10C5)
HYPGEOM.DIST(2,37,6,100,200) gives the result 0.6079646750428083
This function is available in Spread for Windows Forms 11.0 or later.