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

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.



(C) 2015 ACL Services Ltd. All Rights Reserved.