HYPGEOMDIST
Name
Hypergeometric distribution
Description
Returns the hypergeometric distribution.
Syntax
HYPGEOMDIST(x,n,M,N)
Remarks
The arguments are truncated if not integers.
This function has the following arguments:
| 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:Data Type
Accepts numeric data for all arguments. Returns numeric data. For more information, see Data Type for Each Cell Type.
Example
HYPGEOMDIST(A22,B23,62,1000)
HYPGEOMDIST(R22C11,R22C12,R34C14,R35C15)
HYPGEOMDIST(2,37,6,100)=0.3327981975