Returns the individual term binomial distribution probability.
BINOMDIST(number_s, trials, probability_s, cumulative)
- number_s - The number of successes for which to calculate the probability.
- trials - The number of independent trials.
- probability_s - The probability of success in any given trial.
- cumulative - A logical value that determines the form of the function.
BINOMDIST(C2,C3,C4,FALSE) returns the probability of exactly 6 of 10 trials being successful.
BINOMDIST(4,100,0.005,FALSE) returns a value of 0.00151.