BINOM.DIST Function Explained
The BINOM.DIST Function in Microsoft Excel calculates the probability of a certain number of successes in a sequence of independent trials, given a probability of success in each trial. It takes four arguments: the number of successes, the number of trials, the probability of success in each trial, and a logical value that determines whether the probability is cumulative or not.
BINOM.DIST Function Syntax
BINOM.DIST(number_s,trials,probability_s,cumulative)
- number_s: The number of successes in trials.
- trials: The number of independent trials.
- probability_s: The probability of success on each trial.
- cumulative: A logical value that determines the form of the function. If cumulative is TRUE, BINOM.DIST returns the cumulative distribution function; if FALSE, it returns the probability mass function.