BINOM.DIST
Category: Statistical Function.
Description: Returns the individual term binomial distribution probability.
Syntax: BINOM.DIST(number_s, trials, probability_s, cumulative)
The BINOM.DIST function syntax has the following arguments:
Number_s: number of successes in trials.
Trials: number of independent trials.
Probability_s: probability of success on each trial.
Cumulative: 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, BINOM.DIST returns the probability mass function, which is the probability that there are number_s successes.