Documentation/Calc Functions/BINOM.INV

From The Document Foundation Wiki
Jump to navigation Jump to search


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 border probability.

Syntax:

BINOM.INV(Trials; SP; Alpha)

Returns:

Returns a real number.

Arguments:

Trials is a positive integer value or a reference to a cell containing that value which is the total number of trials.

SP is a real number between 0 and 1(both inclusive) or a reference to a cell containing that number is the probability of success on each trial.

Alpha is a real number between 0 and 1(both inclusive) or a reference to a cell containing that number which is the border probability that is attained or exceeded.

  • If Trials is a non-integer value, then the function truncates it to an integer.
  • If Trials is less than zero, then the function returns an error value.
  • If SP or Alpha are greater than 1 or less than 0, then the function returns an error value.

Additional details:

  • For more details th on inverse binomial distribution, visit Wikipedia.
  • CRITBINOM and BINOM.INV performs the same function

Examples:

Formula Description Returns
=BINOM.INV(8;0.6;0.9) the smallest value for which the cumulative binomial distribution is greater than or equal to 0.9. 7

Related LibreOffice functions:

BINOM.DIST

BINOMDIST

B

CRITBINOM

ODF standard:

None

Equivalent Excel functions:

BINOM.INV