# Documentation/Calc Functions/CRITBINOM

Jump to navigation Jump to search

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

CRITBINOM