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: