Binomdist, 238 binomdist – Apple iWork '09 User Manual
Page 238
BINOMDIST
The BINOMDIST function returns the individual term binomial distribution probability
of the specified 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 specified 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 specified number of successes or events).
Usage Notes
The BINOMDIST is appropriate for problems with a fixed 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
“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