sheets.wiki

BINOM.DIST.RANGE

1 min read

Returns the probability of drawing a specific number of successes or range of successes given a probability and number of tries.

Parts of a BINOM.DIST.RANGE function

BINOM.DIST.RANGE(num_trials, prob_success, num_successes, max_num_successes)
PartDescription
num_trialsThe number of independent trials. Must be greater than or equal to 0.
prob_successThe probability of success in any given trial. Must be between 0 and 1, both exclusive.
num_successesThe number of successes for which to calculate the probability in num\_trials trials. Must be between 0 and num_trials, both exclusive.
max_num_successesOptional: The maximum number of successes for which to calculate the  probability in num\_trials trials. If omitted, then we compute the probability of  just num\_successes. Must be between num_successes and num_trials, both exclusive.

Notes

  • If any arguments does not meet its constraints, this function returns a #NUM! error value.
  • If any argument is non-numeric, this functions returns a #VALUE! error value.
  • Except for prob_success, this function truncates any numerical argument to an integer.

Examples

AB
1Function input
2=BINOM.DIST.RANGE(100, 0.5, 45)
3=BINOM.DIST.RANGE(100, 0.5, 30, 45)
4=BINOM.DIST.RANGE(100, 0.5, 30)
  • BINOM.DIST/BINOMDIST

Graph View