Related Topics:
	Spreadsheet Math Functions Formulas Tab and Insert Function Data Entry Tips for Functions Function Wizard

EXPONDIST

Description: Returns the exponential distribution.

Syntax: EXPONDIST(Number, Lambda, Cumulative)

• Number is the value of the function.

• Lambda is the parameter value.

• Cumulative is a logical value that indicates which form of the exponential function to provide. If Cumulative is TRUE, EXPONDIST returns the cumulative distribution function; if FALSE, it returns the probability density function.

Remarks:

• Number and lambda must be numerical.

• Number must be >= 0.

• Lambda must be > 0.

• The equation for the probability density function is:

• The equation for the cumulative distribution function is:

Example:

• EXPONDIST(0.2,10,TRUE) = 0.864665

• EXPONDIST(0.2,10,FALSE) = 1.353353

© 1992-2016. ReliaSoft Corporation. ALL RIGHTS RESERVED.

E-mail Link