BINOM.INV function

BINOM.INV(NumberOfTrials, Probability, Alpha) BINOM.INV(NumberOfTrials; Probability; Alpha)

NumberOfTrials

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.