Skip to main content

NORMDIST - script and chart function


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.


NORMDIST(value, mean, standard_dev)

Return data type: number


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


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