EXPON.DIST DAX Function (Statistical)
Returns the exponential distribution. Use EXPON.DIST to model the time between events, such as how long an automated bank teller takes to deliver cash. For example, you can use EXPON.DIST to determine the probability that the process takes at most 1 minute.
Syntax
Parameter | Attributes | Description |
---|---|---|
X |
The value of the function. |
|
Lambda |
The parameter value. |
|
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 FALSE, it returns the probability density function. |
Return values
Examples
-- Given the lambda parameter to define the power, EXPON.DIST returns the -- exponential distribution of a value, or the cumulative distribution -- depending on its third argument -- -- https://en.wikipedia.org/wiki/Exponential_distribution DEFINE VAR Vals = GENERATESERIES ( 0, 5, 0.5 ) VAR Lambda = 0.8 VAR CumulativeTrue = TRUE -- Cumulative distribution function VAR CumulativeFalse = FALSE -- Probability density function EVALUATE ADDCOLUMNS ( Vals, "EXPON.DIST", EXPON.DIST ( [Value], Lambda, CumulativeFalse ), "EXPON.DIST Cumulative", EXPON.DIST ( [Value], Lambda, CumulativeTrue ) )
Value | EXPON.DIST | EXPON.DIST Cumulative |
---|---|---|
0.00 | 0.80 | 0.00 |
0.50 | 0.54 | 0.33 |
1.00 | 0.36 | 0.55 |
1.50 | 0.24 | 0.70 |
2.00 | 0.16 | 0.80 |
2.50 | 0.11 | 0.86 |
3.00 | 0.07 | 0.91 |
3.50 | 0.05 | 0.94 |
4.00 | 0.03 | 0.96 |
4.50 | 0.02 | 0.97 |
5.00 | 0.01 | 0.98 |
Last update: Dec 4, 2024 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo
Microsoft documentation: https://docs.microsoft.com/en-us/dax/expon-dist-function-dax