Returns the normal cumulative distribution for the specified mean and standard deviation.
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. |
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();