Edit

Share via


WorksheetFunction.Expon_Dist(Double, Double, Boolean) Method

Definition

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.

public:
 double Expon_Dist(double Arg1, double Arg2, bool Arg3);
public double Expon_Dist (double Arg1, double Arg2, bool Arg3);
Public Function Expon_Dist (Arg1 As Double, Arg2 As Double, Arg3 As Boolean) As Double

Parameters

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, Expon_Dist returns the cumulative distribution function; if false, it returns the probability density function.

Returns

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:

Figure 1: Equation for the probability density function

The equation for the cumulative distribution function is:

Figure 2: Equation for the cumulative distribution function

Applies to