Returns the probability of a trial result using a binomial distribution.
Name | Type | Description |
arg1 | number | The number of independent trials. |
arg2 | number | The probability of success on each trial. |
arg3 | number | The minimum number of successes in the trials to calculate probability for, a numeric value greater than or equal to 0. |
arg4 | number | The maximum number of successes in the trials to calculate probability for, a numeric value greater than the minimum number of successes and less than or equal to trials. |
builder.CreateFile("xlsx"); var oWorksheet = Api.GetActiveSheet(); var oFunction = Api.GetWorksheetFunction(); oWorksheet.GetRange("A1").SetValue(oFunction.BINOM_DIST_RANGE(60, 0.75, 45, 50)); builder.SaveFile("xlsx", "BINOM_DIST_RANGE.xlsx"); builder.CloseFile();