Microsoft Office Tutorials and References
In Depth Information
While the NEGBINOMDIST
returns failures, see the
BINOMDIST function for
NORMDIST returns the normal cumulative distribution for the specified mean and standard
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.
Is the arithmetic mean of the distribution.
Is the standard deviation of the distribution.
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.