EXPON.DIST function

The EXPON.DIST function in Excel calculates the exponential distribution for a specified value, given a rate parameter. The exponential distribution is often used to model the time between events in a process where events occur continuously and independently at a constant average rate.

Syntax:

EXPON.DIST(x, lambda, cumulative)

Arguments:

• x: The value at which you want to evaluate the function. This must be greater than or equal to 0.
• lambda: The rate parameter (also known as the inverse of the mean). It must be greater than 0.
• cumulative: A logical value that determines the type of function to return:
  • TRUE: Returns the cumulative distribution function (CDF), which gives the probability that a value is less than or equal to x.
  • FALSE: Returns the probability density function (PDF), which gives the probability that a value is exactly x.

Formula:

For the cumulative distribution function (CDF), the formula is:

$$F(x) = 1 – e^{-\lambda x}$$

For the probability density function (PDF), the formula is:

$$f(x) = \lambda e^{-\lambda x}$$

Where:

• $\lambda$ is the rate parameter (1/mean).
• $x$ is the value for which you want to compute the distribution.

Example 1: Cumulative Distribution Function (CDF)

If you want to find the cumulative probability for $x = 5$ with a rate parameter $\lambda = 0.2$, you would use the formula:

=EXPON.DIST(5, 0.2, TRUE)

This would return the cumulative probability that a random variable following an exponential distribution with rate $\lambda = 0.2$ is less than or equal to 5.

Example 2: Probability Density Function (PDF)

If you want to find the probability density for $x = 5$ with a rate parameter $\lambda = 0.2$, you would use:

=EXPON.DIST(5, 0.2, FALSE)

This would return the probability density at $x = 5$.

Key Points:

• The exponential distribution is widely used for modeling the time between events in processes such as queuing, reliability analysis, or decay rates.
• CDF (TRUE): Calculates the probability that the random variable is less than or equal to a given value.
• PDF (FALSE): Calculates the probability that the random variable takes a specific value, typically used to describe the rate of occurrence.

Use Cases:

• Queuing Theory: Modeling the time between arrivals of customers in a queue.
• Reliability Analysis: Estimating the time until a machine fails.
• Decay Processes: Modeling the time until a radioactive substance decays.