Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I demonstrate that the Normal distribution is a good approximation of the
binomial in Excel but I found there was a diference in entering the formula f(x)=1/(stdev*sqrt(2*PI()))*exp(-(x-mean)^2/(2*stdev^2)) and NORMDIST(x, mean, stdev, false) For example, for the binomial n=25, p=0.25 binomdist(6,25,0.25,false)=0.182820 normdist(6, np, sqrt(npq),false)=0.183039 f(6)=0.184116 Could someone explain where the difference between NORMDIST and f(x) comes from? Thanks! |