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