Home

SPSX

Find Hyper geometric Distribution Using formula on Ms Excel

Posted by Muhammad Taheir | On: , |
Hyper Geometric Distribution:

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
k =  pop. sample
N = Population

To explain this look at the example below 

Example:

N=12 ,n=4 , k=4
Then

Find Hyper geometric Distribution Using formula on Ms Excel
Hyper geometric Dist: on excel