BINOMINV

BINOMINV(trials, probability_s, probability)

Calculates the inverse of the binomial cumulative distribution.

BINOMINV returns the smallest integer k such that the binomial CDF evaluated at k is greater than or equal to the given criterion probability.

Parameters:

• trials (Operand | int | float) – The number of independent trials.

• probability_s (Operand | int | float) – The probability of success on each trial (must be between 0 and 1).

• probability (Operand | int | float) – The criterion probability (must be between 0 and 1).

Return type:

Formula

Returns:

A formula object evaluating to the inverse binomial distribution value(s).

• Returns INTEGER if all inputs are scalar

• Returns INTEGER_ARRAY if any input is an array

Raises:

ValueError – If trials, probability_s, or probability are not numeric types

Examples

Scalar inverse:

BINOMINV(10, 0.5, 0.9)
# Returns the smallest k where P(X <= k) >= 0.9 for X ~ Binomial(10, 0.5)

Array inputs:

BINOMINV(my_table["trials"], 0.5, 0.9)
# Returns an array of inverse binomial values for each row

``trials`` — accepted types

• DECIMAL

• DECIMAL_ARRAY

• INTEGER

• INTEGER_ARRAY

``probability_s`` — accepted types

• DECIMAL

• DECIMAL_ARRAY

• INTEGER

• INTEGER_ARRAY

``probability`` — accepted types

• DECIMAL

• DECIMAL_ARRAY

• INTEGER

• INTEGER_ARRAY

Return types

• INTEGER

• INTEGER_ARRAY