TRY NEW VERSION

Try now New API BETA

Try out the new view and capabilities of the API documentation

START

NEGBINOM_DIST

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

Returns the negative binomial distribution, the probability that there will be the specified number of failures before the last success, with the specified probability of a success.

Parameters:

Name Type Description
arg1 number

The number of failures.

arg2 number

The threshold number of successes.

arg3 number

The probability of a success; a number between 0 and 1.

arg4 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:

Type
number

Example

Copy code
builder.CreateFile("xlsx");
var oWorksheet = Api.GetActiveSheet();
var oFunction = Api.GetWorksheetFunction();
oWorksheet.GetRange("A1").SetValue(oFunction.NEGBINOM_DIST(6, 32, 0.7, true));
builder.SaveFile("xlsx", "NEGBINOM_DIST.xlsx");
builder.CloseFile();

Resulting document