DAX Function Guide

EXPON.DIST
Empty image or helper icon

Sam McKay

CEO & Founder

How does the EXPON.DIST work?
The EXPON.DIST function (DAX) returns the exponential distribution.
EXPON.DIST Formula Syntax

EXPON.DIST(
     x,lambda,cumulative
)

How do you use the EXPON.DIST?

Use EXPON.DIST function to model the time between events, such as how long an automated bank teller takes to deliver cash.

Related Blog Posts

Loading

Considerations when using the EXPON.DIST?

If x or lambda is nonnumeric, EXPON.DIST returns the #VALUE! error value.

If x or lambda is not an integer, it is rounded.

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:

a
Formula

The equation for the cumulative distribution function is:

Formula
Related Video Tutorials

Loading

Formula examples using the EXPON.DIST

=EXPONDIST( 0.5, 1, FALSE )

=EXPON.DIST(0.2,10,FALSE)

=EXPON.DIST(A2,A3,TRUE)

Related Courses

Loading