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.

Frequently Asked Questions

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.

Make Better Decisions
With Data

Analyze data, automate reports and create live dashboards
for all your business applications, without code. Get unlimited access free for 14 days.