- 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
Compatibility - NORMDIST Function
The NORMDIST function replaces the NORM.DIST function in Excel 2010.
Description
The 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
NORMDIST(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, NORMDIST returns the cumulative distribution function. If cumulative is FALSE, NORMDIST returns the probability mass function. |
Required |
Notes
The equation for the normal density function (cumulative = FALSE) is −
$$f(x;\mu,\sigma) = \frac{1}{\sqrt{2 \pi \sigma}}e^{-(\frac{(n-\mu)^2}{2 \sigma^2})}$$
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, NORMDIST returns the standard normal distribution, NORMSDIST
If mean or standard_dev is nonnumeric, NORMDIST returns the #VALUE! error value.
If standard_dev ≤ 0, NORMDIST returns the #NUM! error value.