WorksheetFunction.Binom_Dist_Range method (Excel)
Returns the probability of a trial result using a binomial distribution.
expression.Binom_Dist_Range (Arg1, Arg2, Arg3, Arg4)
expression A variable that represents a WorksheetFunction object.
Name | Required/Optional | Data type | Description |
---|---|---|---|
Arg1 | Required | Double | The number of independent trials. |
Arg2 | Required | Double | The probability of success on each trial. |
Arg3 | Required | Double | The number of successes in trials. |
Arg4 | Optional | Variant | If provided, this function returns the probability that the number of successful trials shall lie between Arg3 and Arg4. |
Double
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.