The EXPON.DIST function - The function returns the exponential distribution in Excel

The following article introduces you to the EXPON.DIST function - one of the functions in the statistical function group is very popular in Excel.

The EXPON.DIST function - The function returns the exponential distribution in Excel Picture 1

Description: The function returns an exponential distribution, using this function to model the time at which events occur.

Syntax: EXPON.DIST (x, lambda, cumulative)

Inside:

- x: The value of the function, is a required parameter.

- lambda: The parameter value, is a required parameter.

- cumulative: Logical value determines the exponential type, is a required parameter, including the following values:

+ Cumulative = True -> Returns the cumulative distribution function.

+ Cumulative = False -> Returns the probability density function

Attention:

- If x or lambda are not numeric -> the function returns the #VALUE! Error value

- If x <0 or lambda ≤ 0 -> the function returns the #NUM! Error value

- The equation for the cumulative distribution function is:

[fleft ({x; lambda} right) = lambda {e ^ {- lambda x}}]

- The equation for the probability density function is:

[Fleft ({x; lambda} right) = 1 - {e ^ {- lambda x}}]

For example:

Calculate the value of the cumulative distribution function and the probability density function according to the data in the following data table:

The EXPON.DIST function - The function returns the exponential distribution in Excel Picture 2

- Calculate the value of cumulative distribution function. In the cell to calculate enter the formula : = EXPON.DIST (D6, D7, D8)

The EXPON.DIST function - The function returns the exponential distribution in Excel Picture 3

- Press Enter -> cumulative distribution function value is:

The EXPON.DIST function - The function returns the exponential distribution in Excel Picture 4

- Calculate the value of probability density function. In the cell to calculate enter the formula : = EXPON.DIST (D6, D7, D9)

The EXPON.DIST function - The function returns the exponential distribution in Excel Picture 5

- Press Enter -> the probability density function value is:

The EXPON.DIST function - The function returns the exponential distribution in Excel Picture 6

Above are instructions and some specific examples when using the EXPON.DIST function in Excel.

Good luck!