EXPON.DIST()/EXPONDIST()

Syntax. EXPON.DIST(x,lambda,cumulative)

Definition. This function returns the probabilities of an exponential distributed random variable. Use EXPON.DIST() to model the time between events. For example, you can calculate the probability that a call center will receive a call after three minutes, although the hourly average for incoming calls is three minutes.

Arguments

  • x (required). The value of the function.

  • lambda (required). The value that is passed.

  • cumulative (required). The logical value. If cumulative is TRUE, the cumulative distribution is returned; otherwise, the probability density function is returned.

Note

If x or lambda isn’t a numeric value, the EXPON.DIST() function returns the #VALUE! error.

If x is less than 0, ...

Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.