- Advanced Excel Functions Tutorial
- Advanced Excel Functions - Home
- Compatibility Functions
- Advanced Excel Functions - Cube
- Database Functions
- Date & Time Functions
- Engineering Functions
- Financial Functions
- Information Functions
- Advanced Excel Functions - Logical
- Lookup & Reference Functions
- Math & Trignometric Functions
- Statistical Functions
- Useful Resources
- Quick Guide
- Useful Resources
- Discussion
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