Formulas and Functions

CRITBINOM
The CRITBINOM function returns the smallest value for which the cumulative binomial
distribution is greater than or equal to a given value.
CRITBINOM(trials, prob-success, alpha)
 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.
 alpha: The probability that the true population value lies outside the interval. alpha
is a number value and must be less than or equal to 1. Subtracting the condence
interval from 1 yields the alpha.
Example
=CRITBINOM(97, 0.05, 0.05) returns 2, based on 97 trials, with each trial having a probability of success
of 5% and a 95% condence interval (5% alpha).
=CRITBINOM(97, 0.25, 0.1) returns 19, based on 97 trials, with each trial having a probability of success
of 25% and a 90% condence interval (10% alpha).
=CRITBINOM(97, 0.25, 0.05) returns 17, based on 97 trials, with each trial having a probability of
success of 25% and a 95% condence interval (5% alpha).
Related Topics
For related functions and additional information, see:
“BINOMDIST” on page 238
“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
252 Chapter 10 Statistical Functions