Spread Silverlight Documentation
Spread Silverlight Documentation / Formula Reference / Formula Functions / CRITBINOM
In This Topic
    CRITBINOM
    In This Topic

    Summary

    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

    CRITBINOM(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

    CRITBINOM(B5,0.75,0.92)

    CRITBINOM(R5C2,R8C14,0.75)

    CRITBINOM(14,0.75,0.85) gives the result 12

    See Also