Excel Function : BINOM.DIST

Download now!

Excel Function : BINOM.DIST

Category

Statistical

Description

Returns the individual term binomial distribution probability

Microsoft Excel Reference Page

https://support.office.com/en-us/article/BINOMDIST-function-c5ae37b6-f39c-4be2-94c2-509a1480770c

Syntax and Description of the BINOM.DIST Excel Function

=BINOM.DIST(number_s,trials,probability_s,cumulative) The BINOM.DIST 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, BINOM.DIST 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

About BINOM.DIST Excel Function

BINOM.DIST returns the probability that there are a certain number of successes in a binomial distribution. The function takes four arguments: the number of successes, the number of trials, the probability of success on each trial, and whether to return the cumulative probability (TRUE or FALSE).