Documentation/Calc Functions/BINOM.INV

From The Document Foundation Wiki
Jump to: navigation, search


Im-jabber.svg

Under construction.
For now, see the system Help files.


Function name:

BINOM.INV

Category:

Statistical Analysis

Summary:

Returns the smallest value for which the cumulative binomial distribution is greater than or equal to a criterion value.

Syntax:

BINOM.INV(Trials; SP; Alpha)

Returns:

Arguments:

Trials The total number of trials.

SP is the probability of success on each trial.

Alpha The border probability that is attained or exceeded.

Additional details:

Examples:

=BINOM.INV(8;0.6;0.9) returns 7, the smallest value for which the cumulative binomial distribution is greater than or equal to a criterion value.

Related LibreOffice functions:

ODF standard:

Equivalent Excel functions: