Statistical - EXPON.DIST Function



Description

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

Syntax

EXPON.DIST(x,lambda,cumulative)

Arguments

Argument Description Required/ Optional
X The value of the function. Required
Lambda The parameter value. Required
Cumulative

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 cumulative is FALSE, EXPON.DIST returns the probability density function.

Required

Notes

  • The equation for the probability density function is −

    $$f\left ( x;\lambda \right )= \lambda e^{-\lambda x}$$

  • The equation for the cumulative distribution function is −

    $$F\left ( x;\lambda \right )= 1- e^{-\lambda x}$$

  • 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.

Applicability

Excel 2010, Excel 2013, Excel 2016

Example

Expon.Dist Function
advanced_excel_statistical_functions.htm
Advertisements