BINOM.DIST.RANGE function

BINOM.DIST.RANGE (TrialCount, Probability, SuccessCount1, SuccessCount2?) BINOM.DIST.RANGE (TrialCount; Probability; SuccessCount1; SuccessCount2?)

TrialCount

Number Number

The number of trials.

Probability

Number Number

The probability of success in each trial.

SuccessCount1

Number Number

The number of successes in trials.

SuccessCount2

Number Number (optional)

A number enabling this function to return the probability that the number of successful trials will be between the SuccessCount1 parameter and the SuccessCount2 parameter. If omitted, it is assumed to be equal to the SuccessCount1 parameter.

Returns

Number Number

A probability for a binomial distribution over an interval.

Returns the probability that the number of successes in a binomial experiment falls within a specified range. This is equivalent to summing individual BINOM.DIST probabilities over the range.

Example

BINOM.DIST.RANGE (20, 30 % , 5, 8)

BINOM.DIST.RANGE (20; 30 % ; 5; 8)

Returns roughly 0.6492 (about 64.9%), the probability of getting between 5 and 8 successes (inclusive) in 20 trials where each trial has a 30% chance of success.