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 ...
Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
