Practice free

EXPON.DIST function

EXPON.DIST returns the exponential distribution at a value, which models the waiting time between random events such as customer arrivals or machine failures. It replaces the older EXPONDIST.

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.

Practice this in the app

Syntax

EXPON.DIST(x, lambda, cumulative)

x (required)
Value at which to evaluate; not negative.
lambda (required)
Rate parameter, above 0.
cumulative (required)
TRUE for cumulative probability, FALSE for density.

Returns: The exponential distribution value at x.

What Excel actually returns

Each formula below was run in desktop Excel. The result is exactly what the cell showed, errors included.

FormulaExcel showsCase
=EXPON.DIST(2,0.5,TRUE) 0.632120559 Working example
=EXPON.DIST(2,0.5,FALSE) 0.183939721 Other cumulative flag
=EXPON.DIST(2,0.5,0) 0.183939721 Cumulative as 0
=EXPON.DIST("2",0.5,TRUE) 0.632120559 Text-number in first arg
=EXPON.DIST({2,2},0.5,TRUE) 0.632120559 Array in first arg (lifts, spills)
=EXPON.DIST(Data!D1,0.5,TRUE) 0 Blank cell as first arg
=EXPON.DIST("abc",0.5,TRUE) #VALUE! Non-numeric text in first arg
=EXPON.DIST(NA(),0.5,TRUE) #N/A Error in first arg

The Data sheet these formulas read

A cell that starts with = holds that formula.

Watch out for

  • lambda is a rate (events per unit time), the inverse of the mean wait.
  • Replaces the older EXPONDIST.

Where it works

Excel
EXPON.DIST arrived in Excel 2010. Older versions do not have it.
Google Sheets
Same name, same behaviour for everyday use.

Part of Statistical functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .