Spread Formula Reference
Formula Functions / Functions D to G / EXPON.DIST
In This Topic
    EXPON.DIST
    In This Topic

    This function returns the exponential distribution or the probability density.

    Syntax

    EXPON.DIST(value,lambda,cumulative)

    Arguments

    This function has these arguments:

    Argument Description
    value Value of the function; must be positive or zero
    lambda Parameter value; must be greater than zero
    cumulative Logical value indicating whether to return the cumulative distribution; set to TRUE to return the cumulative distribution; set to FALSE to return the probability density

    Remarks

    Use this function to model the time between events, such as how long an automated bank teller takes to deliver cash. For example, you can use this function to determine the probability that the process takes at most one minute.

    The cumulative distribution is calculated as follows:

    Equation EXPONDIST (probability density)

    where x is the value argument, lambda is the lambda argument.

    The probability density is calculated as follows:

    Equation EXPONDIST cumulative distribution

    where x is the value argument, lambda is the lambda argument.

    Data Types

    Accepts numeric data, except the third argument, which accepts logical data. Returns numeric data.

    Examples

    EXPON.DIST(C12,10,TRUE)

    EXPON.DIST(R12C3,8,FALSE)

    EXPON.DIST(0.2,10,TRUE) gives the result 0.8646647167633873

    Version Available

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

    See Also

    EXPONDIST