Name
NORMSINV
Synopsis
Use NORMSINV to find the inverse of the standard normal cumulative distribution for a value with a mean of 0 and a standard deviation of 1.
To Calculate
=NORMSINV(Probability
)
The Probability
argument is required for
this function.
Example
Figure 15-33 illustrates how to use NORMSINV to find
the inverse of the standard normal cumulative distribution for a
value. The inverse value returned by the function is equal to the
value of the Z
argument used by the
NORMSDIST function.
Get Excel 2000 in a Nutshell now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.