[Statistical functions] Function to return result from Z table?

[plh]

Here is what I am wondering, is there a statistical function in Excel that,
given a value of Z, returns the look up value from a Cumulative Standard Normal
Distribution table? That is, if Z = 0, returns .5, if Z = 1, returns .84134, if
2, .97725, etc.
Thanx,
-plh

 

[Mike Middleton]

plh -

Worksheet function NORMSINV returns the inverse of the standard normal
cumulative distribution.

- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel

 

[plh]

Mike,
Thank you for replying, but I want to do the reverse of what that function does.
Give NORMSINV 0.93822 and you get 1.54000145
I need a function that given 1.54000145 will return 0.93822 (etc.)
Thank You,
-plh

 

[Mike Middleton]

plh -

Worksheet function NORMSDIST(z) returns the standard normal cumulative
distribution function.

- Mike

 

[plh]

Mike,
Thank You!
-plh

plh -

Worksheet function NORMSDIST(z) returns the standard normal cumulative
distribution function.

- Mike