BINOM.DIST.RANGE function
BINOM.DIST.RANGE(TrialCount, Probability, SuccessCount1,
SuccessCount2?) BINOM.DIST.RANGE(TrialCount; Probability; SuccessCount1;
SuccessCount2?)
TrialCount
Number or { Number }
The number of trials.
Probability
Number or { Number }
The probability of success in each trial.
SuccessCount1
Number or { Number }
The number of successes in trials.
SuccessCount2
Number or { 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 or { Number }
A probability for a binomial distribution over an interval.
Returns the probability for a binomial distribution over an interval.
Example
BINOM.DIST.RANGE(70, 0.78,
50)BINOM.DIST.RANGE(70;
0,78; 50)
Returns roughly 0.05 (5%), the binomial distribution based on the probability of 50 successes in 70 trials and a 78% probability of success.
Partly derived from the OpenOffice.org documentation, licensed
under the Apache License 2.0.