WorksheetFunction.NormDist Method
| Excel Developer Reference |
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
expression.NormDist(Arg1, Arg2, Arg3, Arg4)
expression A variable that represents a WorksheetFunction object.
Parameters
| Name | Required/Optional | Data Type | Description |
|---|---|---|---|
| Arg1 | Required | Double | X - the value for which you want the distribution. |
| Arg2 | Required | Double | Mean - the arithmetic mean of the distribution. |
| Arg3 | Required | Double | Standard_dev - the standard deviation of the distribution. |
| Arg4 | Required | Boolean | Cumulative - a logical value that determines the form of the function. If cumulative is TRUE, NORMDIST returns the cumulative distribution function; if FALSE, it returns the probability mass function. |
Return Value
Double
Remarks
If mean or standard_dev is nonnumeric, NORMDIST returns the #VALUE! error value.
If standard_dev ≤ 0, NORMDIST returns the #NUM! error value.
If mean = 0, standard_dev = 1, and cumulative = TRUE, NORMDIST returns the standard normal distribution, NORMSDIST.
The equation for the normal density function (cumulative = FALSE) is:
.gif "Equation")
When cumulative = TRUE, the formula is the integral from negative infinity to x of the given formula.
See Also