DAX Statistical - EXPON.DIST function

Description

Returns the exponential distribution. DAX EXPON.DIST function is new in Excel 2016.

Syntax

EXPON.DIST (x, lambda, cumulative)

Parameters

Sr.No. Parameter & Description
1

x

The value of the function.
2

lambda

The parameter value.
3

cumulative

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

TRUE: EXPON.DIST returns the cumulative distribution function.

FALSE: EXPON.DIST returns the probability density function.

Return Value

Returns the exponential distribution.

Remarks

  • If x or lambda is non-numeric, EXPON.DIST returns the #VALUE! error value.

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

  • If lambda ≤ 0, EXPON.DIST 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

= EXPON.DIST(0.2,10, TRUE ()) returns 0.864664716763387.
dax_functions_statistical.htm
Advertisements