BINOM.INV Function

The BINOM.INV function is one of the statistical functions. It is used to return the smallest value for which the cumulative binomial distribution is greater than or equal to a criterion value.

Syntax

BINOM.INV(trials, probability_s, alpha)

The BINOM.INV function has the following arguments:

Argument	Description
trials	The number of trials, a numeric value greater than 0.
probability_s	The success probability of each trial, a numeric value greater than 0 but less than 1.
alpha	The criterion, a numeric value greater than 0 but less than 1.

Notes

How to apply the BINOM.INV function.

Examples

The figure below displays the result returned by the BINOM.INV function.