The BINOM.DIST function returns the individual term binomial distribution probability.

BINOM.DIST takes 4 required arguments and no optional arguments:

Syntax: BINOM.DIST(number_s, trials, probability_s, cumulative)

#1)
Using the BINOM.DIST function:
#2)
The arguments for the BINOM.DIST function are:
Argument Required? Description
number_s Required The number of successes in trials.
trials Required The number of independent trials.
probability_s Required The probability of success on each trial.
cumulative Required A logical value that determines the form of the function. If cumulative is TRUE, then BINOM.DIST returns the cumulative distribution function, which is the probability that there are at most number_s successes; if FALSE, it returns the probability mass function, which is the probability that there are number_s successes.
#3)
A few more things:
number_s and trials are truncated to integers.
If number_s, trials, or probability_s is nonnumeric, BINOM.DIST returns the #VALUE! error value.
If number_s < 0 or number_s > trials, BINOM.DIST returns the #NUM! error value.
If probability_s < 0 or probability_s > 1, BINOM.DIST returns the #NUM! error value.

Summary

The BINOM.DIST function returns the individual term binomial distribution probability.
comments powered by Disqus