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