BINOM.DIST.RANGE
Probability of a trial result range.
- Excel: Not checked yet
- Google Sheets: No equivalent
- Returns: Number
Examples
=BINOM.DIST.RANGE(10, 0.5, 3, 6) Result 0.7734374999999979
Syntax
BINOM.DIST.RANGE(trials, probability_s, number_s, [number_s2])trials- number required
probability_s- number required
number_s- number required
number_s2- number optional defaults to
3
Errors
#NUM!=BINOM.DIST.RANGE(2, 0.5, 3)