GAMMADIST

Returns the gamma distribution.

Syntax

expression.GAMMADIST(arg1, arg2, arg3, arg4);

expression - A variable that represents an ApiWorksheetFunction class.

Parameters

Name	Required/Optional	Data type	Default	Description
arg1	Required	ApiRange | ApiName | number		The value at which the distribution will be calculated, a nonnegative number.
arg2	Required	ApiRange | ApiName | number		The alpha parameter of the distribution, a positive number.
arg3	Required	ApiRange | ApiName | number		The beta parameter of the distribution, a positive number. If this parameter is equal to 1, the function returns the standard gamma distribution.
arg4	Required	ApiRange | ApiName | 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 density function.

Returns

number

Example

Return the gamma distribution.

// Calculate the probability distribution for gamma-distributed values.

// Determine gamma distribution using GAMMADIST with shape and scale parameters.

let worksheet = Api.GetActiveSheet();
let func = Api.WorksheetFunction;
let ans = func.GAMMADIST(10, 9, 2, false);
worksheet.GetRange("B2").SetValue(ans);