Documentation/Calc Functions/EXPON.DIST

Function name:
EXPON.DIST

Category:
Statistical Analysis

Summary:
Returns a value of the probability density function or the cumulative distribution function for the exponential distribution.

Syntax:
EXPON.DIST(Number; Lambda; C)

Returns:
Returns a real number which is the value of the probability density function or the cumulative distribution function for the exponential distribution.

Arguments:
Number is a real number or a reference to the cell containing that number which is the input value of the function.

Lambda is a real number or a reference to the cell containing that number which is the rate parameter of the exponential distribution.

C is a logical value that determines the form of the function. C = 0 or False to calculate the probability density function. It can be any other value or True to calculate the cumulative distribution function.


 * For all Number less than 0, the function returns 0 by definition, given valid values for Lambda.
 * If Lambda is less than or equal to 0, the function returns an error value.

Additional details:

 * The formula for the EXPON.DIST is:

If Cumulative is FALSE, EXPON.DIST returns 0 for x < 0 and the probability density function value

otherwise.

If Cumulative is TRUE, EXPON.DIST returns 0 if x < 0 and the cumulative distribution function value

otherwise.

Here x is Number and λ is Lambda
 * For more details on exponential distribution, visit Wikipedia

Related LibreOffice functions:
[[Special:MyLanguage/Documentation/Calc_Functions/EXPONDIST EXPONDIST]

ODF standard:
None

Equivalent Excel functions:
EXPON.DIST