EXPONDIST Function Explained
The EXPONDIST Function in Microsoft Excel calculates the exponential distribution for a given set of parameters. It returns the probability that a variable will be 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 to be calculated, lambda is the rate parameter, and cumulative is a logical value that determines the form of the function. If cumulative is TRUE, the function returns the cumulative distribution function; if FALSE, it returns the probability density function.
EXPONDIST Function Syntax
EXPONDIST(x,lambda,cumulative)
- x: The value at which you want to evaluate the exponential distribution.
- lambda: The parameter value that determines the shape of the exponential distribution.
- cumulative: A logical value that determines the form of the function. If cumulative is TRUE, EXPONDIST returns the cumulative distribution function; if FALSE, it returns the probability density function.