O'Reilly logo

Microsoft® Excel® 2010 Formulas & Functions Inside Out by Helmut Reinke Egbert Jeschke Sara Unverhau, Eckehard Pfeifer, Bodo Fienitz, and Jens Bock

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

BINOM.DIST()/BINOMDIST()

Syntax. BINOM.DIST(number_s;trials;probability_s;cumulative)

Definition. This function returns the probabilities of a binomial distributed random variable. Use the BINOM.DIST() function for problems with a fixed number of tests or trials when the results of a trial are only success or failure, when trials are independent, and when the probability of success is constant throughout all trials. For example, you can use the BINOM.DIST() function to calculate the probability that 50 of 100 people in a restaurant support a smoking ban.

Arguments

  • number_s (required). The number of successes in trials.

  • trials (required). The number of independent trials.

  • probability_s (required). The probability for the success of each trial.

  • cumulative ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required