# 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
##### Kickstart Your Career

Get certified by completing the course