The formula for NORMSDIST is wrong?

nI tried using the equation from the help menu to verify NORMSDIST(1.3333),
as follows:

(EXP(-POWER(1.3333,2)/2))/SQRT(2*PI())

but I don't get the same answer. Instead, I get 0.164017.

What am I doing wrong?

normSdist always returns the cumulative value (ie the area under the curve
up to value of z)
normdist lets you choose cumulative or not.
Also the first is set for mean = 0, stdev=1 while the second allows you to
specify these values.
The formula =NORMDIST(1.3333,0,1,0) returns 0.164017 since the last argument
of 0 specifies non-cumulative.
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"SyBorg" <SyBorg@discussions.microsoft.com> wrote in message
news:ADFA0946-2708-405F-A99D-B798FE2DE653@microsoft.com...
> nI tried using the equation from the help menu to verify
> NORMSDIST(1.3333),
> as follows:
>
> (EXP(-POWER(1.3333,2)/2))/SQRT(2*PI())
>
> but I don't get the same answer. Instead, I get 0.164017.
>
> What am I doing wrong?

"SyBorg" <SyBorg@discussions.microsoft.com> wrote in message
news:ADFA0946-2708-405F-A99D-B798FE2DE653@microsoft.com...
> nI tried using the equation from the help menu to verify
> NORMSDIST(1.3333),
> as follows:
>
> (EXP(-POWER(1.3333,2)/2))/SQRT(2*PI())
>
> but I don't get the same answer. Instead, I get 0.164017.
>
> What am I doing wrong?

Doesn't the help say that NORMSDIST is the *cumulative* function, whereas
the (EXP(-POWER(z,2)/2))/SQRT(2*PI()) is the *density* function?
Plot each against z.
Integrate the density from z = - infinity and compare that with the
cumulative.
--
David Biddulph

David Biddulph - Thank you. Although I read the excel help on this function many times trying to figure out the same problem as SyBorg, I failed to read it carefully enough. It doesn't help that the monograph I was following incorrectly equated NORMSDIST with the density function.