Microsoft Office Tutorials and References
In Depth Information
the sum of the
yields the same result
as the DEVSQ function.
of the sum of the
Results of the
EXPONDIST returns the exponential distribution.
The exponential probability distribution deals with the lapse of time between two successive
occurrences, when the average number of occurrences per unit of time is known. Figure
11.14 shows an example of this function.
X Is the value of the function.
LAMBDA ( λ ) Is the parameter value.
CUMULATIVE Is a logical value that indicates which form of the exponential function
to provide. If TRUE, then EXPONDIST returns the cumulative distribution
function. If FALSE, then EXPONDIST returns the probability density
The formula for the probability density function is
The formula for the cumulative distribution function is