BINOMDIST Function Explained
The BINOMDIST Function in Microsoft Excel calculates the probability of a certain number of successes in a given number of independent trials, where each trial has the same probability of success. It takes four arguments: the number of successes, the number of trials, the probability of success, and a cumulative flag (TRUE or FALSE).
BINOMDIST Function Syntax
BINOMDIST(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, BINOMDIST returns the cumulative distribution function; if FALSE, it returns the probability mass function.