EXPON.DIST Function Explained
The EXPON.DIST Function in Microsoft Excel calculates the exponential distribution for a given set of parameters. It returns the probability that a variable, which follows an exponential distribution, is less than or equal to a specified value. The function takes three arguments: x, lambda, and cumulative. x is the value at which the probability is calculated, lambda is the rate parameter, and cumulative is a logical value that determines whether the function returns the cumulative distribution function or the probability density function.
EXPON.DIST Function Syntax
EXPON.DIST(x,lambda,cumulative)
- x: The value at which you want to evaluate the function.
- lambda: The parameter value of the distribution.
- cumulative: A logical value that determines the form of the function. If cumulative is TRUE, EXPON.DIST returns the cumulative distribution function; if FALSE, it returns the probability density function.