|
<< Click to Display Table of Contents >> EXPON.DIST (exponential distribution) |
Syntax:
EXPON.DIST(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.
Compatibility notes:
Microsoft Excel supports this function only in version 2010 or later. In older versions, the function is unknown.
See also: