EXPONDIST function
EXPONDIST returns an exponential-distribution value, modeling waiting time between random events such as incoming calls. It still works, but EXPON.DIST supersedes it for new workbooks.
Example
Read it as a sentence: find the cumulative exponential distribution at D1 (which is empty, so counted as 0) with a rate of 0.5.
Excel shows 0
D
1
Data
Syntax
EXPONDIST(x, lambda, cumulative)
-
x(required) - The time or value to evaluate, 0 or more.
-
lambda(required) - Rate parameter, above 0.
-
cumulative(required) - TRUE for the cumulative probability, FALSE for the density.
Returns: An exponential-distribution value.
What Excel actually returns
Each formula below was run in desktop Excel. The result is exactly what the cell showed, errors included.
| Formula | Excel shows | Case |
|---|---|---|
=EXPONDIST(2,0.5,TRUE) | 0.632120559 | Working example |
=EXPONDIST(2,0.5,FALSE) | 0.183939721 | Other cumulative flag |
=EXPONDIST(2,0.5,0) | 0.183939721 | Cumulative as 0 |
=EXPONDIST("2",0.5,TRUE) | 0.632120559 | Text-number in first arg |
=EXPONDIST({2,2},0.5,TRUE) | 0.632120559 | Array in first arg (lifts, spills) |
=EXPONDIST(Data!D1,0.5,TRUE) | 0 | Blank cell as first arg |
=EXPONDIST("abc",0.5,TRUE) | #VALUE! | Non-numeric text in first arg |
=EXPONDIST(NA(),0.5,TRUE) | #N/A | Error in first arg |
The Data sheet these formulas read
A cell that starts with = holds that formula.
D
1
Data
Watch out for
- Superseded by EXPON.DIST; use that in new workbooks.
- lambda is a rate, not a mean time; the mean is 1/lambda.
Where it works
- Excel
- EXPONDIST is in every version of Excel from 2007 on. Compatibility function: still works in every version, but newer replacements exist.
- Google Sheets
- Same name, same behaviour for everyday use.
Part of Compatibility functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .