EXPONDIST

Formulas / EXPONDIST
Return 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?
The EXPONDIST function returns the exponential distribution and is used to model the time between events.
What is the new EXPON.DIST function?
The new EXPON.DIST function may provide improved accuracy compared to the original EXPONDIST function.
What is the #VALUE! error associated with the EXPONDIST function?
The EXPONDIST function throws a #VALUE! error if either the x or lambda parameter is not numeric.
Sourcetable Logo

Make Better Decisions
With Data

Analyze data, automate reports and create live dashboards
for all your business applications, without code.

Drop CSV