HYPGEOMDIST
function HYPGEOMDIST(
arg1: number = null,
arg2: number = null,
arg3: number = null,
arg4: number = 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.
Returns
numberTry It
var oWorksheet = Api.GetActiveSheet();
var oFunction = Api.GetWorksheetFunction();
oWorksheet.GetRange("A1").SetValue(oFunction.HYPGEOMDIST(2, 3, 3, 12));