CRITBINOM
Description
Returns the smallest value where the cumulative binomial distribution is greater than or equal to the criterion value.
Syntax
CRITBINOM(
trials
,
probability_s
,
alpha
)
- trials: The number of trials. If you enter a non-integer, it is truncated.
- probability_s: The number between 0 and 1 for the probability of success in one trial.
- alpha: The number between 0 and 1 for the criterion.
Example
Formula | Result |
|---|---|
=CRITBINOM(6, 0.5, 0.75) | 4 |
Notes
- This function does the same action as BINOM.INV() and BINOMINV().
- If any argument is nonnumeric, CRITBINOM() returns #VALUE! (invalid type).
- Iftrialsis not an integer, it is truncated.
- Iftrialsis less than zero, CRITBINOM() returns #NUM! (invalid number).
- Ifprobability_sis less than zero or greater than 1, CRITBINOM() returns #NUM! (invalid number).
- Ifalphais less than zero or greater than 1, CRITBINOM() returns #NUM! (invalid number).