In Google Sheets, the EXPON.DIST function is used to calculate the exponential distribution.

It returns the probability density function (PDF) or the cumulative distribution function (CDF) for a specified value in the exponential distribution.

The function takes three arguments:

x: This is the value at which you want to evaluate the distribution.

lambda: This parameter represents the rate or inverse scale of the distribution. It must be greater than zero.

cumulative: This is a logical value that determines the type of the function's result. If set to TRUE or omitted, it returns the cumulative distribution function (CDF). If set to FALSE, it returns the probability density function (PDF). Here's the general syntax:

EXPON.DIST(x, lambda, cumulative)

If cumulative is TRUE (or omitted), the function returns the cumulative probability of the exponential distribution up to the value x.

If cumulative is FALSE, the function returns the probability density of the exponential distribution at the value x.

Note that the exponential distribution is often used to model the time between events in a Poisson process, where events occur at a constant average rate.

Please let me know if you need any further clarification!