Name
NORMINV
Synopsis
Use NORMINV to find the inverse of the normal cumulative distribution for the specified mean and standard deviation.
To Calculate
=NORMINV(Probability
,Mean
,Standard_Dev
)
All three arguments must be specified for this function.
-
Mean
Indicates a numeric value that specifies the mean of the distribution.
-
Standard_Dev
Indicates a positive numeric value that specifies the standard deviation of the distribution.
Example
Figure 15-32 illustrates how to use NORMINV to find
the inverse of the normal cumulative distribution. You will notice in
this example the value returned by NORMINV is equal to the value
specified for the X
argument of NORMDIST.
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.