GAMMA_DIST
function GAMMA_DIST(
arg1: number = null,
arg2: number = null,
arg3: number = null,
arg4: boolean = null,
): numberDescription
Returns the gamma distribution.
Parameters
- arg1
numberdefault: null The value at which the distribution will be calculated, a nonnegative number.
- arg2
numberdefault: null The alpha parameter of the distribution, a positive number.
- arg3
numberdefault: null The beta parameter of the distribution, a positive number. If this parameter is equal to 1, the function returns the standard gamma distribution.
- 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 density function.
Returns
numberTry It
var oWorksheet = Api.GetActiveSheet();
var oFunction = Api.GetWorksheetFunction();
var ans = oFunction.GAMMA_DIST(10, 9, 2, false);
oWorksheet.GetRange("B2").SetValue(ans);