Owner manual

BINOMDIST

The BINOMDIST function returns the individual term binomial distribution probability

of the specied form.

BINOMDIST(success-num, trials, prob-success, form-type)

Â success-num: The number of successful trials or tests. success-num is a number

value that must be greater than or equal to 1 and less than or equal to trials.

Â trials: The total number of trials or tests. trials is a number value that must be

greater than or equal to 0.

Â prob-success: The probability of success for each trial or test. prob-success is a

number value that must be greater than or equal to 0 and less than or equal to 1.

Â form-type: A value that indicates which form of the exponential function to provide.

cumulative form (TRUE or 1): Return the value of the cumulative distribution

function form (that the specied number or fewer successes or events will occur).

probability mass form (FALSE or 0): Return the value of the probability mass

function form (that there are exactly the specied number of successes or events).

Usage Notes

The BINOMDIST is appropriate for problems with a xed number of independent Â

trials that have a constant probability of success and where the outcomes of a trial

are only success or failure.

Examples

=BINOMDIST(3, 98, 0.04, 1) returns 0.445507210083272 (cumulative distribution form).

=BINOMDIST(3, 98, 0.04, 0) returns 0.201402522366024 (probability mass form).