WorksheetFunction.Expon_Dist Method (Excel)
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.
Version Information
Version Added: Excel 2010
Syntax
expression .Expon_Dist(Arg1, Arg2, Arg3)
expression A variable that represents a WorksheetFunction object.
Parameters
Name |
Required/Optional |
Data Type |
Description |
|---|---|---|---|
Arg1 |
Required |
Double |
X - the value of the function. |
Arg2 |
Required |
Double |
Lambda - the parameter value. |
Arg3 |
Required |
Boolean |
Cumulative - a logical value that indicates which form of the exponential function to provide. If cumulative is TRUE, EXPONDIST returns the cumulative distribution function; if FALSE, it returns the probability density function. |
Return Value
Double
Remarks
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:
.gif "Ff194546.awfxpnd1_ZA06051267(en-us,office.14).gif")
The equation for the cumulative distribution function is:
.gif "Ff194546.awfxpnd2_ZA06051268(en-us,office.14).gif")