BINOM.INV
Description
Returns the smallest value where the cumulative binomial distribution is greater than or equal to the criterion value.
Syntax
BINOM.INV(
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 |
|---|---|
=BINOM.INV(6, 0.5, 0.75) | 4 |
Notes
- This function does the same action as BINOMINV() and CRITBINOM().
- If any argument is nonnumeric, BINOM.INV() returns #VALUE! (invalid type).
- Iftrialsis not an integer, it is truncated.
- Iftrialsis less than zero, BINOM.INV() returns #NUM! (invalid number).
- Ifprobability_sis less than zero or greater than 1, BINOM.INV() returns #NUM! (invalid number).
- Ifalphais less than zero or greater than 1, BINOM.INV() returns #NUM! (invalid number).