The BINOMDIST function part 2


You're probably thinking you're seeing double if you read the post last time. This function also returns the individual term probability from the binomial distribution. The BINOMDIST 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, BINOMDIST can calculate the probability that two of the next three babies born will be boys.

The BINOMDIST The function uses the following syntax to operate:

BINOMDIST (numbers, essays, probability_s, cumulative)

The BINOMDIST 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 BINOMDIST 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, BINOMDIST return the #VALUE! error value
  • And numbers <0 O numbers > trials, BINOMDIST return the #ON ONE! error value
  • And probability_s <0 O probability_s > 1, BINOMDIST 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.