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
x: The waiting time, 0 or more.lambda: The rate: how many events happen in one unit of time.cumulative: TRUE for the chance of x or less; FALSE for the height of the curve at x.
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
A call within 6 minutes, when calls come 10 an hour
A B C D 1 Hours Per hour 2 0.1 10 63.2% In D2:
=EXPON.DIST(A2, B2, TRUE)→ 63.2%
Common mistakes
- Rate, not average time. Lambda is the rate (events per unit of time), not the average wait.
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.
- Czech: EXPON.DIST
- Danish: EKSP.FORDELING
- Dutch: EXPON.VERD.N
- Finnish: EKSPONENTIAALI.JAKAUMA
- French: LOI.EXPONENTIELLE.N
- German: EXPON.VERT
- Hungarian: EXP.ELOSZL
- Italian: DISTRIB.EXP.N
- Norwegian: EKSP.FORDELING.N
- Polish: ROZKŁ.EXP
- Portuguese (Brazil): DISTR.EXPON
- Portuguese (Portugal): DIST.EXPON
- Russian: ЭКСП.РАСП
- Spanish: DISTR.EXP.N
- Swedish: EXPON.FÖRD
- Turkish: ÜSTEL.DAĞ
Also written as EXPONDIST.
Try EXPON.DIST in the playground
Related functions
- POISSON.DIST: The chance of a number of events in a period, given how many happen on average.
- WEIBULL.DIST: The Weibull distribution, used for how long things last before they fail.
- GAMMA.DIST: The gamma distribution, for values that cannot be negative and lean to the right, such as waiting times.