How to use EXPON.DIST Function in Excel

The EXPON.DIST function returns the exponential distribution. Use EXPON.DIST to model the time between events.

Syntax:= EXPON.DIST(x,lambda,cumulative)

The EXPON.DIST function syntax has the following arguments:

  • X     Required. The value of the function.
  • Lambda     Required. The parameter value.
  • Cumulative     Required. A logical value that indicates which form of the exponential function to provide. If cumulative is TRUE, EXPON.DIST returns the cumulative distribution function; if FALSE, it returns the probability density function.

Example: Let’s look at some Excel EXPON.DIST function examples and explore how to use the EXPON.DIST function as a worksheet function in Microsoft Excel:

EXPON.DIST Function - How to use EXPON.DIST Function in Excel

Syntax:  =EXPON.DIST(B1,B2,FALSE)

Result: 0.389400392

EXPON.DIST Function in Excel 2 - How to use EXPON.DIST Function in Excel

Based on the Excel spreadsheet above, the following EXPON.DIST examples would return:

Syntax:
=EXPON.DIST(B1,B3,FALSE)
Result: 0.60653066

Syntax: =EXPON.DIST(B1,B4,FALSE)
Result: 0.735758882

Syntax: =EXPON.DIST(B1,B2,TRUE)
Result: 0.221199217

Syntax: =EXPON.DIST(B1,B3,TRUE)
Result: 0.39346934

Syntax: =EXPON.DIST(B1,B4,TRUE)
Result: 0.632120559

Note:

  • If x or lambda is nonnumeric, EXPON.DIST returns the #VALUE! error value.
  • If x < 0, EXPON.DIST returns the #NUM! error value.
  • If lambda ≤ 0, EXPON.DIST returns the #NUM! error value.
  • The equation for the probability density function is: EXPON.DIST Function in Excel - How to use EXPON.DIST Function in Excel

  • The equation for the cumulative distribution function is: EXPON.DIST Function in Excel 1 - How to use EXPON.DIST Function in Excel

Add a Comment

Your email address will not be published. Required fields are marked *