Spread Formula Reference
Formula Functions / Functions A to C / BETA.INV
In This Topic
    BETA.INV
    In This Topic

    This function calculates the inverse of the cumulative beta density function.

    Syntax

    BETA.INV(prob,alpha,beta,lower,upper)

    Arguments

    This function has these arguments:

    Argument Description
    prob Probability of the distribution
    alpha Alpha parameter of the distribution
    beta Beta parameter of the distribution
    lower [Optional] Lower bound of the interval for x; 0 if omitted
    upper [Optional] Upper bound of the interval for x; 1 if omitted

    Remarks

    If you omit values for upper and lower, the calculation uses the standard cumulative beta distribution, so that lower is zero and upper is one. This function returns the #VALUE! error value if any argument is nonnumeric.

    Data Types

    Accepts numeric data for all arguments. Returns numeric data.

    Examples

    BETA.INV(0.75,B3,C3,2,4)

    BETA.INV(0.75,R3C2,R3C3,2,4)

    BETA.INV(0.75,9,12,2,4) gives the result 3.0011968805340232

    Version Available

    This function is available in Spread for Windows Forms 11.0 or later.

    See Also

    BETAINV