NORMDIST
function NORMDIST(
arg1: number = null,
arg2: number = null,
arg3: number = null,
arg4: boolean = null,
): numberDescription
Returns the normal cumulative distribution for the specified mean and standard deviation.
Parameters
- arg1
numberdefault: null The value for which the distribution will be returned.
- arg2
numberdefault: null The arithmetic mean of the distribution.
- arg3
numberdefault: null The standard deviation of the distribution, a positive number.
- arg4
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.NORMDIST(36, 6, 7, false));