SpreadJS 13
SpreadJS Documentation / Formula Reference / Formula Functions / BINOM.INV
In This Topic
    BINOM.INV
    In This Topic

    This function returns the criterion binomial, the smallest value for which the cumulative binomial distribution is greater than or equal to a criterion value.

    Syntax

    BINOM.INV(n,p,alpha)

    Arguments

    This function has these arguments:

    Argument Description
    n Number of trials; if not an integer, the number is truncated
    p Probability of success on each trial; number between 0 and 1
    alpha Alpha, value for the criterion

    Data Types

    Accepts numeric data for all arguments. Returns numeric data.

    Examples

    BINOM.INV(B5,0.75,0.92)

    BINOM.INV(R5C2,R8C14,0.75)

    BINOM.INV(14,0.75,0.85) gives the result 14