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
This example shows how to return the standard normal distribution (has a mean of zero and a standard deviation of one).
- Code
- Result
// How to calculate the standard normal distribution.
// Use a function to get the standard normal distribution with a mean = 0 and standard deviation = 1.
let worksheet = Api.GetActiveSheet();
let func = Api.GetWorksheetFunction();
worksheet.GetRange("A1").SetValue(func.NORM_S_DIST(1.33, true));