EXPONDIST

Syntax

EXPONDIST( <number>, <number>; <boolean>)

Description

Returns the exponential distribution for a certain value with given lambda.

or

Returns the exponential density function or the cumulative distribution function for the exponential distribution. This function is frequently used used to measure the degree of diversity between two data sets.

The function arguments are:

x: The value for which the distribution should be computed (NUMERIC)
Lambda: The lambda parameter of the exponential distribution (NUMERIC)
Cumulative: Constant indicating the form of the function. If true then the cumulative distribution function is used. If false then the probability mass function is used (BOOLEAN)

Cumulative/Boolean	Logical argument which defines the type of distribution to be calculated
True	Uses the cumulative distribution function
False	Uses the probability density function

Example

EXPONDIST(#input!VALUE; #input!LAMBDA; cumulative value)

VALUE	LAMBDA	Cumulative value	EXPONDIST returns
0.5	1	false	0.60653066
0.5	1	true	0.39346934

Common Errors

#NUM!

-

Occurs if either:

The x value is less than 0
The numerator or denominator is less than 1

#VALUE!

-

Occurs if the argument type isn't numeric