The BINOM.DIST function

Share on facebook
Share on twitter
Share on linkedin
Share on telegram
Share on whatsapp


This function returns the individual term probability from the binomial distribution. The BINOM.DIST The function should be used in problems with a fixed number of tests or trials, when the results of any trial are just success or failure, when the trials are independent and when the probability of success is constant throughout the experiment. As an example, BINOM.DIST can calculate the probability that two of the next three babies born will be boys.

The BINOM.DIST The function uses the following syntax to operate:

BINOM.DIST (numbers, essays, probability_s, cumulative)

The BINOM.DIST The function has the following arguments:

  • numbers: this is necessary and represents the number of successes in trials
  • essays: this is also necessary. This is the number of independent trials
  • probability_s: again, required. This is the probability of success in each test.
  • cumulative: additionally required. This is a logical value that determines the shape of the function. And cumulative it is TRUE, subsequently BINOM.DIST returns the cumulative distribution function, which is the probability that there is at most numbers successes Yes cumulative it is FALSE, returns the probability mass function, what is the probability that there are numbers successes.

It should be noted at the same time that:

  • numbers Y trials they are truncated to integers
  • And numbers, trials, O probability_s it is / they are non-numeric, BINOM.DIST return the #VALUE! error value
  • And numbers <0 O numbers > trials, BINOM.DIST return the #ON ONE! error value
  • And probability_s <0 O probability_s > 1, BINOM.DIST return the #ON ONE! error value.

The binomial probability mass function is:

Subscribe to our Newsletter

We will not send you SPAM mail. We hate it as much as you.