Manuals/calci/HYPGEOMDIST
HYPGEOMDIST (n1, n2, n3, n4)
n1- It is the number of successes in the sample
n2- It is size of the sample
n3-It is the number of successes in the population
n4- it is the size of the population
Calculate the hyper geometric distribution.
· All arguments are shortened to integers.
· HYPGEOMDIST calculates error value, when n1 is less than the larger of 0
· HYPGEOMDIST calculates error value, n2 is less than or equal to 0(zero) or n2 is grater than the n4.
· HYPGEOMDIST calculates the error value, when n3 is less than or equal to 0(zero) or n3 grater than n4
· HYPGEOMDIST calculates error value, when n4 is less than or equal to 0(zero).
Formulas:-
· The equation to calculate the hyper geometric distribution is:
Where, n1=x, n2=n, n3=M and n4=N
HYPGEOMDIST
HYPGEOMDIST (C1,C2,C3,C4)
HYPGEOMDIST (2,48,6,100)=0.2562
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | 2 | 48 | 6 | 100 |
| Row2 | 0.256178 | |||
| Row3 | ||||
| Row4 | ||||
| Row5 | ||||
| Row6 |