LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Betty
 
Posts: n/a
Default NORMDIST(x,mean, stdev,false) vs f(x)

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!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 07:27 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"