BINOMDIST
function BINOMDIST(
arg1: number = null,
arg2: number = null,
arg3: number = null,
arg4: boolean = null,
): numberDescription
Returns the individual term binomial distribution probability.
Parameters
- arg1
numberdefault: null The number of successes in trials.
- arg2
numberdefault: null The number of independent trials.
- arg3
numberdefault: null The probability of success on each trial.
- arg4
booleandefault: null Specifies if this is the cumulative distribution function (true) or the probability mass function (false).
Returns
numberTry It
var oWorksheet = Api.GetActiveSheet();
var oFunction = Api.GetWorksheetFunction();
oWorksheet.GetRange("A1").SetValue(oFunction.BINOMDIST(50, 67, 0.45, false));