NORM.DIST()/NORMDIST()

Syntax. NORM.DIST(x,mean,standard_dev,cumulative)

Definition. This function returns the normal distribution for an average value and a standard variance. This function has a very wide range of applications in statistics, including hypothesis testing.

Arguments

  • x (required). The distribution value (quantile) for which you want to calculate the probability.

  • mean (required). The arithmetic mean of the distribution.

  • standard_dev (required). The standard deviation of the distribution.

  • cumulative (required). The logical value that represents the type of the function. If cumulative is TRUE, the NORM.DIST() function returns the value of the distribution function (cumulative density function). If cumulative is FALSE, the NORM.DIST() function ...

Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.