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.
Search JabSto ::




Custom Search