The equation for the normal density function (cumulative = FALSE) is: If mean = 0, standard_dev = 1, and cumulative = TRUE, NORM.DIST returns the standard normal distribution, NORM.S.DIST. If standard_dev ≤ 0, NORM.DIST returns the #NUM! error value. If mean or standard_dev is nonnumeric, NORM.DIST returns the #VALUE! error value. If cumulative is TRUE, NORM.DIST returns the cumulative distribution function if FALSE, it returns the probability density function. A logical value that determines the form of the function. The standard deviation of the distribution.Ĭumulative Required. The value for which you want the distribution. The NORM.DIST function syntax has the following arguments:
NORM.DIST(x,mean,standard_dev,cumulative) This function has a very wide range of applications in statistics, including hypothesis testing. Returns the normal distribution for the specified mean and standard deviation.
