EXPONDIST

The EXPONDIST function returns the exponential distribution of the specified form.

EXPONDIST(non-neg-x-value, lambda, form-type)

non-neg-x-value: A number value representing the x value at which you want to evaluate the function. non-neg-x-value must be greater than or equal to 0.

lambda: A number value representing the parameter value. lambda must be greater than 0.

form-type: A modal value that indicates which form of the exponential function to provide.

cumulative form (TRUE or 1): Return the value of the cumulative distribution form.

probability density form (FALSE or 0): Return the value of the probability density form.

Examples

=EXPONDIST(4, 2, 1) returns 0.999664537372097 (cumulative distribution form).

=EXPONDIST(4, 2, 0) returns 0.000670925255805024 (probability density form).

See also
LOGNORMDIST