TRY NEW VERSION

Try now New API BETA

Try out the new view and capabilities of the API documentation

START

HYPGEOMDIST

HYPGEOMDIST(arg1, arg2, arg3, arg4) → { number }

Returns the hypergeometric distribution.

Parameters:

Name Type Description
arg1 number

The number of successes in the sample.

arg2 number

The size of the sample.

arg3 number

The number of successes in the population.

arg4 number

The population size.

Returns:

Type
number

Example

Copy code
builder.CreateFile("xlsx");
var oWorksheet = Api.GetActiveSheet();
var oFunction = Api.GetWorksheetFunction();
oWorksheet.GetRange("A1").SetValue(oFunction.HYPGEOMDIST(2, 3, 3, 12));
builder.SaveFile("xlsx", "HYPGEOMDIST.xlsx");
builder.CloseFile();

Resulting document