NORM_S_DIST
function NORM_S_DIST(arg1: number = null, arg2: boolean = null): numberDescription
Returns the standard normal distribution (has a mean of zero and a standard deviation of one).
Parameters
- arg1
numberdefault: null The value for which the distribution will be returned.
- arg2
booleandefault: null 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
numberTry It
var oWorksheet = Api.GetActiveSheet();
var oFunction = Api.GetWorksheetFunction();
oWorksheet.GetRange("A1").SetValue(oFunction.NORM_S_DIST(1.33, true));