BINOM.DIST.RANGE function
Summary
Returns the probability of a trial result using a binomial distribution
Syntax
BINOM.DIST.RANGE(trials,probability_s,number_s,[number_s2])
The BINOM.DIST.RANGE function syntax has the following arguments.
• Trials Required. The number of independent trials. Must be greater than or equal to 0.
• Probability_s Required. The probability of success in each trial. Must be greater than or equal to 0 and less than or equal to 1.
• Number_s Required. The number of successes in trials. Must be greater than or equal to 0 and less than or equal to Trials.
• Number_s2 Optional. If provided, returns the probability that the number of successful trials will fall between Number_s and number_s2. Must be greater than or equal to Number_s and less than or equal to Trials.
• Trials Required. The number of independent trials. Must be greater than or equal to 0.
• Probability_s Required. The probability of success in each trial. Must be greater than or equal to 0 and less than or equal to 1.
• Number_s Required. The number of successes in trials. Must be greater than or equal to 0 and less than or equal to Trials.
• Number_s2 Optional. If provided, returns the probability that the number of successful trials will fall between Number_s and number_s2. Must be greater than or equal to Number_s and less than or equal to Trials.
Example
=BINOM.DIST.RANGE(60,0.75,48)
=BINOM.DIST.RANGE(60,0.75,45,50)
=BINOM.DIST.RANGE(60,0.75,45,50)