BINOM.DIST.RANGE
Returns the probability of a trial result using a binomial distribution
Syntax
BINOM.DIST.RANGE(trials, probability_s, number_s, [number_s2])
Parameters
- trials: Required. The number of independent trials
- probability_s: Required. The probability of success in each trial
- number_s: Required. The number of successes in trials
- number_s2: Optional. If provided, returns the probability that the number of successful trials falls between number_s and number_s2
Example
=BINOM.DIST.RANGE(60, 0.75, 48)