Statistical - NORM.DIST Function



Description

The NORM.DIST function returns the normal distribution for the specified mean and standard deviation. This function has a very wide range of applications in statistics, including hypothesis testing.

Syntax

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

Arguments

Argument Description Required/ Optional
X The value for which you want the distribution. Required
Mean The arithmetic mean of the distribution. Required
Standard_dev The standard deviation of the distribution. Required
Cumulative

A logical value that determines the form of the function.

If cumulative is TRUE, NORM.DIST returns the cumulative distribution function.

If cumulative is FALSE, NORM.DIST returns the probability mass function.

Required

Notes

  • The equation for the normal density function (cumulative = FALSE) is −

    $$f\left ( x:\mu ,\sigma \right )=\frac{1}{\sqrt{2 \pi }\sigma}e^-\left ( \frac{\left ( N-\mu \right )^2}{2\sigma ^2} \right )$$

  • When cumulative = TRUE, the formula is the integral from negative infinity to x of the given formula.

  • If mean = 0, standard_dev = 1 and cumulative = TRUE, NORM.DIST returns the standard normal distribution, NORM.S.DIST .

  • If any of the supplied arguments are non-numeric or non-logical values, NORM.DIST returns the #VALUE! error value.

  • If standard_dev ≤ 0, NORM.DIST returns the #NUM! error value.

Applicability

Excel 2010, Excel 2013, Excel 2016

Example

Norm.Dist Function
advanced_excel_statistical_functions.htm
Advertisements