title | keywords | f1_keywords | api_name | ms.assetid | ms.date | ms.localizationpriority | ||
---|---|---|---|---|---|---|---|---|
WorksheetFunction.Norm_Dist method (Excel) |
vbaxl10.chm137370 |
|
|
68208573-94ef-aab3-42d0-dee396b7504d |
05/24/2019 |
medium |
Returns the normal distribution for the specified mean and standard deviation. This function has a wide range of applications in statistics, including hypothesis testing.
expression.Norm_Dist (Arg1, Arg2, Arg3, Arg4)
expression A variable that represents a WorksheetFunction object.
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, Norm_Dist returns the cumulative distribution function; if False, it returns the probability mass function. |
Double
If mean or standard_dev is nonnumeric, Norm_Dist returns the #VALUE! error value.
If standard_dev ≤ 0, Norm_Dist returns the #NUM! error value.
If mean = 0, standard_dev = 1, and cumulative = TRUE, Norm_Dist returns the standard normal distribution, Norm_S_Dist.
The equation for the normal density function (cumulative = FALSE) is:
When cumulative = TRUE, the formula is the integral from negative infinity to x of the given formula.
[!includeSupport and feedback]