Microsoft Office Tutorials and References
In Depth Information
The NORMINV function
returns the inverse of
the normal cumulative
distribution. You can
see the inverse of the
distribution function by
using the NORMSINV
NORMSDIST returns the standard normal cumulative distribution function.
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.
NORMSINV returns the inverse of the standard normal cumulative distribution.
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.
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.
The PEARSON function is illustrated in Figure 11.33.