A to Z of Excel Functions: the BINOM.DIST.RANGE Function
23 January 2017
Welcome back to our regular A to Z of Excel Functions blog. Today we look at the BINOM.DIST.RANGE function.
The BINOM.DIST.RANGE function
In probability theory and statistics, the binomial distribution with parameters n and p is the discrete probability distribution of the number of successes in a sequence of n independent success / failure experiments, each of which yields success with probability p. For the record, a success / failure experiment is also called a Bernoulli experiment or Bernoulli trial. The binomial distribution is frequently used to model the number of successes in a sample of size n drawn with replacement from a population of size N.
This function returns the probability of a trial result using a binomial distribution.
The BINOM.DIST.RANGE function employs the following syntax to operate:
BINOM.DIST.RANGE(trials, probability_s, number_s, [number_s2])
The BINOM.DIST.RANGE function has the following arguments:
- trials: this is required and represents the number of independent trials. The value must be greater than or equal to 0
- probability_s: this is also required. This is the probability of success in each trial. This must be greater than or equal to 0 and less than or equal to 1, just like every probability
- number_s: again, required. This is the number of successes in trials. This must be greater than or equal to 0 and less than or equal to trials
- number_s2: this argument is optional. If it is provided, this returns the probability that the number of successful trials will fall between number_s and number_s2. Must be greater than or equal to number_s and less than or equal to trials.
It should be further noted that:
- if any arguments are outside of their constraints, BINOM.DIST.RANGE returns the #NUM! error value
- if any arguments are non-numeric values, BINOM.DIST.RANGE returns the #VALUE! error value
- the following equation is used:
- in the equation above, N is trials, p is probability_s, s is number_s, s2 is number_s2, and k is the iteration variable
- numeric arguments are truncated to integers.
Please see my example below:
We’ll continue our A to Z of Excel Functions soon. Keep checking back – there’s a new blog post every other business day.