Microsoft Office Tutorials and References
In Depth Information
This figure shows the
results (the cumulative
distribution) when the
is TRUE. Change the
cumulative argument to
FALSE to see the
probability mass function.
NORMINV returns the inverse of the normal cumulative distribution for the specified mean and
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.
Is the arithmetic mean of the distribution.
Is the standard deviation of the distribution.