BINOM.INV function
BINOM.INV(TrialCount, Probability, Alpha) BINOM.INV(TrialCount; Probability; Alpha)
TrialCount
Number or { Number }
The total number of trials.
Probability
Number or { Number }
The probability of success for one trial.
Alpha
Number or { Number }
The threshold probability to be reached or exceeded.
Returns
Number or { Number }
The smallest value for which the cumulative binomial distribution is less than or equal to a criterion value.
Returns the smallest value for which the cumulative binomial distribution is less than or equal to a criterion value.
Example
BINOM.INV(8, 0.6,
0.8)BINOM.INV(8; 0,6;
0,8)
Returns 6, which is the smallest value for which the cumulative binomial distribution is greater than or equal to 0.8.
Partly derived from the OpenOffice.org documentation, licensed
under the Apache License 2.0.