NORMDIST( ) function

Returns the probability that a random variable from a normally distributed data set is less than or equal to a specified value, or exactly equal to a specified value.

Syntax

NORMDIST(x, mean, standard_deviation, cumulative)

Parameters

Name Type Description
x numeric

The value for which you want to calculate the probability.

mean numeric The mean value of the data set.
standard_deviation numeric

The standard deviation of the data set. The standard_deviation value must be greater than 0.

cumulative logical

Specify T to calculate the probability that a random variable is less than or equal to x (cumulative probability), or F to calculate the probability that a random variable is exactly equal to x (simple probability).

Output

Numeric.

Examples

Basic examples

Returns 0.908788780274132:

NORMDIST(42, 40, 1.5, T) 

Returns 0.109340049783996:

NORMDIST(42, 40, 1.5, F) 
ACL Scripting Guide 14.1