TRY NEW VERSION

Try now New API BETA

Try out the new view and capabilities of the API documentation

START

NORMDIST

NORMDIST(arg1, arg2, arg3, arg4) → { number }

Returns the normal cumulative distribution for the specified mean and standard deviation.

Parameters:

Name Type Description
arg1 number

The value for which the distribution will be returned.

arg2 number

The arithmetic mean of the distribution.

arg3 number

The standard deviation of the distribution, a positive number.

arg4 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.NORMDIST(36, 6, 7, false));
builder.SaveFile("xlsx", "NORMDIST.xlsx");
builder.CloseFile();

Resulting document