BINOMDIST function
Summary
Returns the individual term binomial distribution probability
Syntax
BINOMDIST(number_s,trials,probability_s,cumulative)
The BINOMDIST function syntax has the following arguments:
• 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 BINOMDIST 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.
• 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 BINOMDIST 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.
Example
=BINOMDIST(A2,A3,A4,FALSE)