Spread.NET 18 Formula Reference
Formula Functions / Functions A to C / CRITBINOM
In This Topic
    CRITBINOM
    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

    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

    Version Available

    This function is available in product version 1.0 or later.

    See Also

    BINOMDIST | Statistical Functions