NORM_DIST
Returns the normal distribution for the specified mean and standard deviation.
Syntax
expression.NORM_DIST(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 normal distribution for the specified mean and standard deviation.
- Code
- Result
// How to calculate the normal distribution.
// Use a function to get the normal distribution knowing the mean and standard deviation.
const worksheet = Api.GetActiveSheet();
let valueArr = [36, 6, 7, false];
// Place the numbers in cells
for (let i = 0; i < valueArr.length; i++) {
worksheet.GetRange("A" + (i + 1)).SetValue(valueArr[i]);
}
//method params
let x = worksheet.GetRange("A1").GetValue();
let mean = worksheet.GetRange("A2").GetValue();
let standardDeviation = worksheet.GetRange("A3").GetValue();
let cumulative = worksheet.GetRange("A4").GetValue();
let func = Api.GetWorksheetFunction();
let normalDist = func.NORM_DIST(x, mean, standardDeviation, cumulative);
worksheet.GetRange("C1").SetValue(normalDist);