EXPONDIST
Syntax:
EXPONDIST ( x , lambda , cumulative-flag )
Description: Computes the exponential distribution.
Mathematical Formula:
The equation for the probability density function is:
The equation for the cumulative distribution function is:
Arguments:
Name |
Type |
Description |
---|---|---|
x |
number |
The value of the function. |
lambda |
number |
The parameter value. |
cumulative-flag |
logical |
Determines the form of the function. If |
Return Type and Value: number – The exponential distribution.
However, if
x < 0,
#NUM!
is returned.lambda ≤ 0,
#NUM!
is returned.
example: