The BINOM.DIST function in Excel returns the Binomial Distribution probability for a given number of successes from a given number of trials.
Syntax:
=BINOM.DIST( number_s, trials, probability_s, cumulative )
Parameter:
number_s:
trials:
probability_s:
cumulati:
TRUE or FALSE, which means:
TRUE: Apply the cumulative distribution function;
FALSE: Apply the probability mass function.
The graphic on the right employs the Binomial Distribution Probability Mass Function to calculate the likelihood that precisely x heads will be tossed out of 100 coin flips.
Ask Your Query