This function returns the hypergeometric distribution.
HYPGEOMDIST(x,n,M,N)
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 |
The equation for this function is:
Accepts numeric data for all arguments. Returns numeric data.
HYPGEOMDIST(A22,B23,62,1000)
HYPGEOMDIST(R22C11,R22C12,R34C14,R35C15)
HYPGEOMDIST(2,37,6,100) gives the result 0.3327981975