NORMDIST

Syntax:

NORMDIST ( x , mean , standard-deviation , cumulative-flag )

Description: Computes the normal distribution for the specified mean and standard deviation.

Mathematical Formula:

The equation for the normal density function (cumulative-flag = FALSE) is:

When cumulative-flag = TRUE, the formula is the integral from negative infinity to x of the given formula.

Arguments:

Name	Type	Description
x	number	The value for which the distribution is to be computed.
mean	number	The arithmetic mean of the distribution.
standard-deviation	number	The standard deviation of the distribution.
cumulative-flag	logical	Determines the form of the function. If `TRUE`, then the cumulative distribution function is returned; if `FALSE`, the probability mass function is returned.

Return Type and Value: number – The normal distribution for the specified mean and standard deviation.

However, if standard-deviation ≤ 0, #NUM! is returned.

example: