BINOM.DIST.RANGE

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)

Part

Description

num_trials

The number of independent trials. Must be greater than or equal to 0.

prob_success

The probability of success in any given trial. Must be between 0 and 1, both

exclusive.

num_successes

The number of successes for which to calculate the probability in `num_trials`

trials. Must be between 0 and num_trials, both exclusive.

max_num_successes

Optional: 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

 

A

B

1

Function input

Function output

2

=BINOM.DIST.RANGE(100, 0.5, 45)

0.04847429663

3

=BINOM.DIST.RANGE(100, 0.5, 30, 45)

0.1840847287

4

=BINOM.DIST.RANGE(100, 0.5, 30)

0.00002317069058

 Related functions

  • BINOM.DIST/BINOMDIST
Was this helpful?
How can we improve it?
Search
Clear search
Close search
Google apps
Main menu
Search Help Center
false
false
true
true
35
false
false