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

    This function calculates the cumulative beta distribution function.

    Syntax

    BETA.DIST(x,alpha,beta,cumulative,lower,upper)

    Arguments

    This function has these arguments:

    Argument Description
    x Value at which to evaluate the function, between the values of lower and upper
    alpha Alpha parameter of the distribution
    beta Beta parameter of the distribution
    cumulative A logical value that determines the function form. The function returns the cumulative distribution function if this argument is true. It returns the probability density function, if the argument is false
    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.

    Data Types

    Accepts numeric data for all arguments except cumulative. Accepts TRUE or FALSE for cumulative. Returns numeric data.

    Examples

    BETA.DIST(A1,A3,B4,TRUE,1,3)

    BETA.DIST(2,8,10,TRUE,1,3) gives the result 0.6854705810546875

    Version Available

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

    See Also

    BETADIST