- DAX Functions Tutorial
- DAX Functions - Home
- DAX Functions - Introduction
- DAX Parameter Naming Conventions
- Description Structure
- DAX Functions - Aggregation
- DAX Functions - Filter
- DAX Functions - Time Intelligence
- DAX Functions - Date and Time
- DAX Functions - Information
- DAX Functions - Logical
- Math & Trigonometric Functions
- DAX Functions - Parent & Child
- DAX Functions - Statistical
- DAX Functions - Text
- DAX Functions - Other
- DAX Functions Useful Resources
- DAX Functions - Quick Guide
- DAX Functions - Useful Resources
- DAX Functions - Discussion
DAX Statistical - EXPON.DIST function
Description
Returns the exponential distribution. DAX EXPON.DIST function is new in Excel 2016.
Syntax
EXPON.DIST (x, lambda, cumulative)
Parameters
| Sr.No. | Parameter & Description |
|---|---|
| 1 |
x The value of the function. |
| 2 |
lambda The parameter value. |
| 3 |
cumulative A logical value that indicates which form of the exponential function to provide. TRUE: EXPON.DIST returns the cumulative distribution function. FALSE: EXPON.DIST returns the probability density function. |
Return Value
Returns the exponential distribution.
Remarks
If x or lambda is non-numeric, 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 −
$$f(x\:;\lambda)\:=\:\lambda e^{-\lambda x}$$
The equation for the cumulative distribution function is −
$$f(x\:;\lambda)\:=\:1\:-\: e^{-\lambda x}$$
Example
= EXPON.DIST(0.2,10, TRUE ()) returns 0.864664716763387.
