How to find NORMSDIST function of ms excel.It Returns the standard normal cumulative distribution function. The distribution has a mean of 0 (zero) and a standard deviation of one. Use this function in place of a table of standard normal curve areas.
Z is the value for which you want the distribution.
The two statements above are in contraddiction (unless sumit7034 and cpallini are the same person ).
BTW Now your question is clear, but is too broad and a bit lazy: what have you done so far? What are your troubles about? I mean, numerically computing the cumulative of the normal distribution isn't such a daunting task, I suppose.
If the Lord God Almighty had consulted me before embarking upon the Creation, I would have recommended something simpler. -- Alfonso the Wise, 13th Century King of Castile.
This is going on my arrogant assumptions. You may have a superb reason why I'm completely wrong. -- Iain Clarke
<pre>// returns the cumulative normal distribution function (CNDF)// for a standard normal: N(0,1)double CNDF(double x)
int neg = (x < 0);
if ( neg )
x *= -1;
y = 1.0 - 0.398942280401*exp(-0.5*x*x)*y;
return (1-neg)*y + neg*(1-y);
<pre>// another implementation of the CNDF// for a standard normal: N(0,1)double CumNorm(double x)
// protect against overflowif (x > 6.0)
if (x < -6.0)
double b1 = 0.31938153;
double b2 = -0.356563782;
double b3 = 1.781477937;
double b4 = -1.821255978;
double b5 = 1.330274429;
double p = 0.2316419;
double c2 = 0.3989423;
double a = fabs(x);
double t = 1.0 / (1.0 + a * p);
double b = c2*exp((-x)*(x/2.0));
double n = ((((b5*t+b4)*t+b3)*t+b2)*t+b1)*t;
n = 1.0-b*n;
if ( x < 0.0 )
n = 1.0 - n;