|
<< Click to Display Table of Contents >> EXPONDIST (exponential distribution) |
Note: EXPONDIST is supplemented by the new identical function EXPON.DIST, which is available in newer versions of Microsoft Excel (2010 or later).
Syntax:
EXPONDIST(x, Lambda, Cumulative)
Description:
Returns the probabilities of an exponentially distributed random number.
An exponential distribution can be used to model time intervals like the time between phone calls or the time customers have to wait at a counter.
For example, if it is known that a customer arrives at a bank counter every three minutes on average, you can use this function to calculate the probability that a customer will arrive after two minutes at the latest.
x is the value to be evaluated. Must be ≥ 0.
Lambda (λ) is the average number of successes per time interval. Must be > 0.
The logical value Cumulative lets you specify which type of function will be returned:
FALSE: The probability density function is returned.
TRUE: The cumulative distribution function is returned.
See also: