BINOMDIST

BINOMDIST probability mass or cumulative distribution function of the binomial distribution

Synopsis

BINOMDIST(n,trials,p,cumulative)

Arguments

n: number of successes

trials: number of trials

p: probability of success in each trial

cumulative: whether to evaluate the mass function or the cumulative distribution function

Note

If n or trials are non-integer they are truncated. If n < 0 or trials < 0 this function returns a #NUM! error. If n > trials this function returns a #NUM! error. If p < 0 or p > 1 this function returns a #NUM! error.

Microsoft Excel Compatibility

This function is Excel compatible.

See also

POISSON.