- Advanced Excel Functions Tutorial
- Advanced Excel Functions - Home
- Compatibility Functions
- Advanced Excel Functions - Cube
- Database Functions
- Date & Time Functions
- Engineering Functions
- Financial Functions
- Information Functions
- Advanced Excel Functions - Logical
- Lookup & Reference Functions
- Math & Trignometric Functions
- Statistical Functions
- Useful Resources
- Quick Guide
- Useful Resources
- Discussion
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