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 O’Reilly online learning.

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