Returns the individual term binomial distribution probability.
Składnia
BINOM.DIST(number_s, trials, probability_s, cumulative)Argumenty
number_swymagane
The number of successes in trials.
trialswymagane
The number of independent trials.
probability_swymagane
The probability of success on each trial.
cumulativewymagane
A logical value that determines the form of the function; TRUE for cumulative distribution, FALSE for probability mass function.
Use BINOM.DIST in problems with a fixed number of tests or trials, when the outcomes of any trial are only success or failure, when trials are independent, and when the probability of success is constant. It is commonly used in quality control and risk assessment.
=BINOM.DIST(6, 10, 0.5, FALSE)→0.205078Calculates the probability of getting exactly 6 successes in 10 trials with a 50% success rate.
Select the cell
Click on the cell where you want to calculate the binomial probability.
Enter the formula
Type =BINOM.DIST( and input the number of successes, total trials, probability, and cumulative flag.
TRUE returns the probability that there are at most number_s successes, while FALSE returns the probability that there are exactly number_s successes.