Skip to main content

NORMDIST - script and chart function

ON THIS PAGE

NORMDIST - script and chart function

NORMDIST() returns the cumulative normal distribution for the specified mean and standard deviation. If mean = 0 and standard_dev = 1, the function returns the standard normal distribution.

Syntax:  

NORMDIST(value, mean, standard_dev)

Return data type: number

Arguments:  

NORMDIST arguments
Argument Description
value The value at which you want to evaluate the distribution.
mean A value stating the arithmetic mean for the distribution.
standard_dev A positive value stating the standard deviation of the distribution.

This function is related to the NORMINV function in the following way:
If prob = NORMDIST(value, m, sd), then NORMINV(prob, m, sd) = value

Limitations:  

All arguments must be numeric, else NULL will be returned.

Examples and results:  

Examples and results
Example Result
NORMDIST( 0.5, 0, 1) Returns 0.6915