# BINOMDIST

Formulas / BINOMDIST
To calculate the probability of a specific number of successes in a fixed number of trials with a specified probability of success.
`BINOMDIST(number_s, trials, probability_s, cumulative)`
• number_s - The number of successes you want to calculate the probability for.
• trials - The number of trials.
• probability_s - The probability of success in each trial.
• cumulative - A logical value that determines the type of probability distribution to use. If cumulative is TRUE, BINOMDIST returns the cumulative distribution function; if FALSE, it returns the probability mass function.

## Examples

• `=BINOMDIST(5, 10, 0.5, FALSE)`

This formula calculates the probability of getting 5 successes in 10 trials where each trial has a 50% chance of success and returns the probability mass function.

• `=BINOMDIST(3, 5, 0.8, TRUE)`

This formula calculates the cumulative probability of getting up to and including 3 successes in 5 trials where each trial has an 80% chance of success and returns the cumulative distribution function.

## Summary

BINOMDIST is a formula used to calculate the probability of a certain number of successes in a fixed number of trials with a specified probability of success.

• The BINOMDIST function calculates the probability of a specific number of successes in a fixed number of trials with a specified probability of success.
• The number_s argument must be an integer between 0 and trials, while the trials argument must be a positive integer up to 10^10 and the probability_s argument must be a value between 0 and 1.
• The cumulative argument is a logical value that determines the type of probability distribution to use, with TRUE indicating a cumulative distribution function and FALSE indicating a probability mass function.
• If the arguments are invalid, BINOMDIST returns a #VALUE! error.
• BINOMDIST is commonly used in statistical analysis, such as in quality control, hypothesis testing, and risk assessment.

What does the BINOMDIST function do?
The BINOMDIST function calculates the probability of a specific number of successes in a fixed number of trials with a specified probability of success.
What are the arguments for the BINOMDIST function?
The arguments for the BINOMDIST function are:
• number_s: The number of successes you want to calculate the probability for.
• trials: The number of trials.
• probability_s: The probability of success in each trial.
• cumulative: A logical value that determines the type of probability distribution to use. If cumulative is TRUE, BINOMDIST returns the cumulative distribution function; if FALSE, it returns the probability mass function.
What is the difference between the cumulative distribution function and the probability mass function?
The probability mass function (PMF) gives the probability of getting exactly x successes in n trials, while the cumulative distribution function (CDF) gives the probability of getting up to and including x successes in n trials.
What range of values can the arguments of BINOMDIST take?
The number_s argument can take values between 0 and trials. The trials argument can take values between 1 and 10^10. The probability_s argument can take values between 0 and 1.
What error does BINOMDIST return if the arguments are invalid?
If the arguments of BINOMDIST are invalid, the function returns a #VALUE! error.