BINOM.DIST.RANGE function
numberOfTrials
The number of trials.
probability
The probability of success in each trial.
numberOfSuccesses1
The number of successes in trials.
numberOfSuccesses2
A number enabling this function to return the probability that the
number of successful trials will be between the
numberOfSuccesses1 parameter and the
numberOfSuccesses2 parameter. If omitted, it is assumed to
be equal to the numberOfSuccesses1 parameter.
Returns
A probability for a binomial distribution over an interval.
Returns the probability for a binomial distribution over an interval.
Example
Returns roughly 0.05 (5%), the binomial distribution based on the probability of 50 successes in 70 trials and a 78% probability of success.