Normal cumulative distribution

Calculates the normal distribution of the mean and standard deviation of a set of values. Returns either the cumulative distribution or the probability density. This function is widely applied in statistics, including in the area of hypothesis testing.

Syntax

NormalDistribution <Cumulative> (x, Mean, Stdev)

Where:

x is the value for which the distribution is sought.

Mean is the arithmetic mean of the distribution.

StDev is the standard deviation of the distribution.

Cumulative is a logical value that determines the form of the function:

• If Cumulative=0 (default), it returns the cumulative distribution.
• If Cumulative=1 it returns the probability density.

Expression

In the expression that follows, z = x, mean = m, stdev = s.

Usage Notes

The following conditions are invalid:

• Either mean or stdev is nonnumeric
• Stdev £ 0

If mean = 0 and stdev = 1, the function returns the standard normal distribution.