Excel functions / Statistics

EXPON.DIST function

The exponential distribution, for the time between events that happen at a steady rate: the chance of waiting x or less.

Syntax

=EXPON.DIST(x, lambda, cumulative)

Arguments

When to use it

EXPON.DIST gives the chance of waiting x or less for an event that happens at a steady average rate (with TRUE): the time to the next call, or until a part fails.

Examples

  1. A call within 6 minutes, when calls come 10 an hour

    ABCD
    1HoursPer hour
    20.11063.2%

    In D2: =EXPON.DIST(A2, B2, TRUE) → 63.2%

    Try this example

Common mistakes

EXPON.DIST in other languages

Excel shows function names in its own language. In these languages it also puts a semicolon between arguments where English has a comma.

Translate a whole formula

Also written as EXPONDIST.

Try EXPON.DIST in the playground

Related functions