Here is the formula by using that you can find binomial distribution in excel
The formula to find binomial distribution in excel is:
= hypgeomdist (x,n,k,N)
Where
X=numbers
n = No. of Samples
X=numbers
n = No. of Samples
k = pop. sample
N = Population
To explain this look at the example below
Example:
N=12 ,n=4 , k=4
Then
|