Documentation/Calc Functions/CRITBINOM

From The Document Foundation Wiki
Jump to navigation Jump to search


Function name:

CRITBINOM

Category:

Statistical Analysis

Summary:

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

Syntax:

CRITBINOM(Trials; SP; Alpha)

Returns:

Returns a real number.

Arguments:

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

SP is a real number between 0 and 1 or a reference to the cell containing that value which is the probability of success for one trial only.

Alphais a real number between 0 and 1 or a reference to the cell containing that value which is the threshold probability to be reached 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 on inverse binomial distribution, visit Wikipedia.
  • CRITBINOM and BINOM.INV performs the same function

Examples:

Formula Description Returns
=CRITBINOM(100;0.5;0.1) The function calculates the smallest value for which the cumulative binomial distribution is greater than or equal to a criterion value. Here there will be total number of trials as 100, probability of success for one trial as 0.5 and threshold probability to reached as 0.1. 44

Related LibreOffice functions:

BINOM.INV

ODF standard:

Section 6.18.19, part 2

Equivalent Excel functions:

CRITBINOM