TRY NEW VERSION

Try now New API BETA

Try out the new view and capabilities of the API documentation

START

BINOMDIST

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

Returns the individual term binomial distribution probability.

Parameters:

Name Type Description
arg1 number

The number of successes in trials.

arg2 number

The number of independent trials.

arg3 number

The probability of success on each trial.

arg4 boolean

Specifies if this is the cumulative distribution function (true) or the probability mass function (false).

Returns:

Type
number

Example

Copy code
builder.CreateFile("xlsx");
var oWorksheet = Api.GetActiveSheet();
var oFunction = Api.GetWorksheetFunction();
oWorksheet.GetRange("A1").SetValue(oFunction.BINOMDIST(50, 67, 0.45, false));
builder.SaveFile("xlsx", "BINOMDIST.xlsx");
builder.CloseFile();

Resulting document