NORMDIST Function Explained
The NORMDIST
function in Microsoft Excel calculates the normal distribution for a given set of parameters. It takes three arguments: the value for which you want to calculate the distribution, the arithmetic mean of the distribution, and the standard deviation of the distribution. It returns the cumulative probability associated with the given value.
NORMDIST Function Syntax
NORMDIST(x, mean, standard_dev, cumulative)
x
: The value for which you want the distribution.mean
: The arithmetic mean of the distribution.standard_dev
: The standard deviation of the distribution.cumulative
: A logical value that determines the form of the function. If cumulative is TRUE, NORMDIST returns the cumulative distribution function; if FALSE, it returns the probability density function.