Microsoft Office Tutorials and References
In Depth Information
EXPONDIST
Figure 11.13
Manually calculating
the sum of the
squared deviations
yields the same result
as the DEVSQ function.
1
Manual calculation
of the sum of the
squared deviations
B
Results of the
DEVSQ function
EXPONDIST
EXPONDIST returns the exponential distribution.
=EXPONDIST(x,lambda,cumulative)
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
function.
The formula for the probability density function is
The formula for the cumulative distribution function is
Search JabSto ::




Custom Search