TRY NEW VERSION

NORM_S_DIST

NORM_S_DIST(arg1, arg2) → { number }

Returns the standard normal distribution (has a mean of zero and a standard deviation of one).

Parameters:

Name Type Description
arg1 number

The value for which the distribution will be returned.

arg2 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:

Type
number

Example

Copy code
builder.CreateFile("xlsx");
var oWorksheet = Api.GetActiveSheet();
var oFunction = Api.GetWorksheetFunction();
oWorksheet.GetRange("A1").SetValue(oFunction.NORM_S_DIST(1.33, true));
builder.SaveFile("xlsx", "NORM_S_DIST.xlsx");
builder.CloseFile();

Resulting document