Formulas and Functions

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).
Related Topics
For related functions and additional information, see:
“CRITBINOM” on page 252
“NEGBINOMDIST” on page 275
“PERMUT” on page 281
“PROB” on page 282
“Listing of Statistical Functions” on page 225
“Value Types” on page 36
“The Elements of Formulas” on page 15
“Using the Keyboard and Mouse to Create and Edit Formulas” on page 26
“Pasting from Examples in Help” on page 41
238 Chapter 10 Statistical Functions