BINOMINV

BINOMINV(trials, probability_s, probability)[source]

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.

    Supported types:

    • INTEGER

    • DECIMAL

    • INTEGER_ARRAY

    • DECIMAL_ARRAY

  • probability_s (Operand | int | float) –

    The probability of success on each trial (must be between 0 and 1).

    Supported types:

    • INTEGER

    • DECIMAL

    • INTEGER_ARRAY

    • DECIMAL_ARRAY

  • probability (Operand | int | float) –

    The criterion probability (must be between 0 and 1).

    Supported types:

    • INTEGER

    • DECIMAL

    • INTEGER_ARRAY

    • DECIMAL_ARRAY

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

Supported types:

  • INTEGER

  • INTEGER_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