WorksheetFunction.Expon_Dist (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.

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 The equation for the cumulative distribution function is

Expon_Dist (Arg1, Arg2, Arg3)

Dim dblArg1 As Double: dblArg1 = 
Dim dblArg2 As Double: dblArg2 = 
Dim dblExpon_Dist As Double
dblExpon_Dist = WorksheetFunction.Expon_Dist(Arg1:=dblArg1, Arg2:=dblArg2, Arg3:=True)


Arg1, Arg2, Arg3

Arg1 (Double) - X - the value of the function.

Arg2 (Double) - Lambda - the parameter value.

Arg3 (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.