Compatibility - EXPONDIST Function

The EXPONDIST function in Excel 2013 replaces the EXPON.DIST function in Excel 2010.

Description

The function returns the exponential distribution. Use EXPONDIST to model the time between events, such as how long an automated bank teller takes to deliver cash.

Syntax

EXPONDIST(x,lambda,cumulative)

Arguments

Argument Description Required/ Optional
X The value of the function. Required
Cumulative

A logical value that indicates which form of the exponential function to provide.

If cumulative is TRUE, EXPONDIST returns the cumulative distribution function.

If cumulative is FALSE, EXPONDIST returns the probability density function.

 Required

Notes

  • If x or lambda is nonnumeric, EXPONDIST returns the #VALUE! error value.

  • If x < 0, EXPONDIST returns the #NUM! error value.

  • If lambda ≤ 0, EXPONDIST returns the #NUM! error value.

  • The equation for the probability density function is −

    $$f(x;\lambda) = \lambda_e^{-\lambda x}$$

  • The equation for the cumulative distribution function is −

    $$F(x;\lambda) = 1- e^{-\lambda x}$$

Example

EXPONDIST Function
advanced_excel_compatibility_functions.htm
Advertisements