Microsoft Office Tutorials and References
In Depth Information
NORMINV
Figure 11.31
This figure shows the
results (the cumulative
distribution) when the
cumulative argument
is TRUE. Change the
cumulative argument to
FALSE to see the
probability mass function.
NORMINV
NORMINV returns the inverse of the normal cumulative distribution for the specified mean and
standard deviation.
=NORMINV(probability,mean,standard_dev)
The NORMDIST function returns a probability, the NORMINV function returns x, the value that
corresponds to the given probability, mean, and standard deviation. There is also an inverse
for the standard normal distribution function ( NORMSINV ) discussed later in this chapter.
NORMINV uses an iterative technique for calculating the function. The default maximum
number of iterations is 100. If a result is not reached within those iterations, the #N/A value is
returned. You can change the number of iterations under Tools, Options, Calculation tab.
Figure 11.32 shows an example of the NORMINV function.
Is the probability corresponding to the normal distribution.
PROBABILITY
Is the arithmetic mean of the distribution.
MEAN
Is the standard deviation of the distribution.
STANDARD_DEV
Search JabSto ::




Custom Search