EXPONDIST
Formulas / EXPONDISTReturn the exponential distribution.
EXPONDIST(x, lambda, cumulative)
- x - the value to evaluate for the exponential distribution
- lambda - the parameter of the distribution
- cumulative - a logical argument
Examples
=EXPONDIST(A2,A3,TRUE)The function can be used to determine the cumulative exponential distribution when given three arguments. For example, this formula returns the cumulative exponential distribution for the given arguments in cells A2 and A3. The third argument is a logical value, indicating whether to calculate a cumulative distribution or not. In this example, TRUE indicates that a cumulative exponential distribution is desired.
=EXPLODIST(0.2,10,FALSE)The function can also be used to determine the non-cumulative exponential distribution when given three arguments. This example returns 1.35335283 which is the exponential distribution. The third argument is a logical value, indicating whether to calculate a cumulative distribution or not. In this example, FALSE indicates that a non-cumulative exponential distribution is desired.
Summary
The EXPONDIST function is a mathematical tool used to calculate the probability of an event occurring based on an exponential distribution.
- The EXPONDIST function returns the exponential distribution, modeling time between events.
- Newer functions such as EXPON.DIST may provide improved accuracy over the EXPONDIST function.
Frequently Asked Questions
What is the EXPONDIST function?
What is the new EXPON.DIST function?
What is the #VALUE! error associated with the EXPONDIST function?
