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 books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
