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