Microsoft Office Tutorials and References
In Depth Information
NORMDIST
Figure 11.30
While the NEGBINOMDIST
returns failures, see the
BINOMDIST function for
testing successes.
NORMDIST
NORMDIST returns the normal cumulative distribution for the specified mean and standard
deviation.
=NORMDIST(x,mean,standard_dev,cumulative)
The NORMDIST function is frequently used in statistics and hypothesis testing. There is also
the standard normal distribution function ( NORMSDIST ) discussed later in this chapter. In
Figure 11.31 the mean and standard deviation have been calculated for the data set, and are
then fed into the NORMDIST function.
Is the value for which you want the distribution.
X
Is the arithmetic mean of the distribution.
MEAN
Is the standard deviation of the distribution.
STANDARD_DEV
Is a logical value that determines the form of the function. If TRUE,
the cumulative distribution is returned. If FALSE, the probability
mass function is returned.
CUMULATIVE
Search JabSto ::




Custom Search