NEGBINOM_DIST
function NEGBINOM_DIST(
arg1: number = null,
arg2: number = null,
arg3: number = null,
arg4: boolean = null,
): numberDescription
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
- arg1
numberdefault: null The number of failures.
- arg2
numberdefault: null The threshold number of successes.
- arg3
numberdefault: null The probability of a success; a number between 0 and 1.
- arg4
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 density function.
Returns
numberTry It
var oWorksheet = Api.GetActiveSheet();
var oFunction = Api.GetWorksheetFunction();
oWorksheet.GetRange("A1").SetValue(oFunction.NEGBINOM_DIST(6, 32, 0.7, true));