|
<< Click to Display Table of Contents >> EXPON.DIST (exponential distribution) |
Syntax:
EXPON.DIST(x, Lambda, Cumulative)
Description:
This 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.
If, for example, 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 whose probability is to be calculated. x must be ≥ 0.
Lambda (λ) is the average number of successes per time interval. Lambda must be > 0.
You use the logical value Cumulative to 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. The function is unknown in older versions.
See also: