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 TRUE, EXPONDIST returns the cumulative distribution function; if FALSE, EXPONDIST returns the probability density function.

Return Type and Value: number – The exponential distribution.

However, if

  • < 0, #NUM! is returned.

  • lambda ≤ 0, #NUM! is returned.

example: