The BINOMDIST function in Excel returns the Binomial Distribution probability of a certain number of successes out of a given number of trials.
Syntax:
=BINOMDIST( number_s, trials, probability_s, cumulative )
Parameter:
number_s:
trials:
probability_s:
cumulative:
TRUE: Apply the cumulative distribution function;
FALSE: Apply the probability mass function.
The graph on the right depicts the Binomial Distribution Probability Mass Function for 100 coin tosses. The graphic depicts the chance that x heads will be tossed out of 100 coin flips.
Ask Your Query