NORM_S_DIST
Returns the standard normal distribution (has a mean of zero and a standard deviation of one).
Syntax
expression.NORM_S_DIST(arg1, arg2);
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 | 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
Calculate the standard normal distribution for a given value in a spreadsheet.
// How do I compute the standard normal distribution in a spreadsheet?
// Find the probability of a value in a standard normal distribution in a spreadsheet.
let worksheet = Api.GetActiveSheet();
let func = Api.WorksheetFunction;
worksheet.GetRange("A1").SetValue(func.NORM_S_DIST(1.33, true));