HYPGEOM_DIST
function HYPGEOM_DIST(
arg1: number = null,
arg2: number = null,
arg3: number = null,
arg4: number = null,
arg5: boolean = null,
): numberDescription
Returns the hypergeometric distribution.
Parameters
- arg1
numberdefault: null The number of successes in the sample.
- arg2
numberdefault: null The size of the sample.
- arg3
numberdefault: null The number of successes in the population.
- arg4
numberdefault: null The population size.
- arg5
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.HYPGEOM_DIST(2, 3, 3, 12, true));