NORMDIST
Returns the normal cumulative distribution for the specified mean and standard deviation.
Syntax
expression.NORMDIST(arg1, arg2, arg3, arg4);
expression - A variable that represents a ApiWorksheetFunction class.
Parameters
| Name | Required/Optional | Data type | Default | Description |
|---|---|---|---|---|
| arg1 | Required | ApiRange | ApiName | number | The value for which the distribution will be returned. | |
| arg2 | Required | ApiRange | ApiName | number | The arithmetic mean of the distribution. | |
| arg3 | Required | ApiRange | ApiName | number | The standard deviation of the distribution, a positive number. | |
| arg4 | Required | ApiRange | ApiName | boolean | A logical value (true or false) that determines the function form. If it is true, the function returns the cumulative distribution function. If it is false, the function returns the probability mass function. |
Returns
number
Example
This example shows how to return the standard normal cumulative distribution (has a mean of zero and a standard deviation of one).
- Code
- Result
// How to calculate the standard normal cumulative distribution.
// Use a function to get the standard normal cumulative distribution.
let worksheet = Api.GetActiveSheet();
let func = Api.GetWorksheetFunction();
worksheet.GetRange("A1").SetValue(func.NORMDIST(36, 6, 7, false));