EXPONDIST(x, lambda, cumulative)

The EXPONDIST function calculates the exponential distribution. x is the input value to the function; lambda is a distribution parameter; and cumulative is a logical value with the following effect:

FALSE

the probability density function is calculated, using the equation:

image\ebx_1032429053.gif

TRUE

the cumulative distribution function is calculated, using the equation:

image\ebx_-132618076.gif

For example

EXPONDIST(0.3, 9, TRUE) returns 0.932794

EXPONDIST(0.3, 9, FALSE)  returns 0.604850

See also:

Other statistical functions