Microsoft Office Tutorials and References

In Depth Information

**NORMSDIST**

Figure 11.32

The
NORMINV
function

returns the inverse of

the normal cumulative

distribution. You can

see the inverse of the

standard normal

distribution function by

using the
NORMSINV

function.

NORMSDIST

NORMSDIST
returns the standard normal cumulative distribution function.

=NORMSDIST(z)

The standard distribution always has a mean of zero (0) and a standard deviation of one (1).

This function is used in lieu of the statistical tables published for standard normal cur ves. If

z (the value of the continuous random variable) is .6, then
NORMSDIST(.6)= 0.725746935
.

Is the value for which you want the distribution.

Z

NORMSINV

NORMSINV
returns the inverse of the standard normal cumulative distribution.

=NORMSINV(probability)

Given the probability, the
NORMSINV
function returns the x value for that probability. If the

probability is 0.815939908, then
NORMSINV(0.815939908)
returns 0.9.

Is the probability corresponding to the normal distribution.

PROBABILITY

PEARSON

PEARSON
returns the Pearson product moment correlation coefficient,
r, a dimensionless

index that ranges from –1.0 to 1.0 inclusive and reflects the extent of a linear relationship

between two data sets.

=PEARSON(array1,array2)

The
PEARSON
function is illustrated in Figure 11.33.