EXPON.DIST Function

Returns the exponential distribution — for the time until the next event.

Category

Statistical

Available in

Excel 2010+, Microsoft 365

Returns

A number

Want to practice EXPON.DIST in a real spreadsheet? Open a blank sheet in our Practice Sandbox and try it with live data, with the AI Excel tutor beside you. No Excel needed — just a free account.Try it free in the Sandbox

Overview

The exponential distribution models waiting times between random events that happen at a steady average rate: the next support ticket, the next customer, the next machine fault.

lambda is the rate — events per unit of time — so 1 ÷ lambda is the average wait. A ticket every 10 minutes on average means lambda = 0.1.

TRUE returns the cumulative probability (the chance of a value up to x); FALSE returns the probability density — the height of the curve, not a probability.

Syntax

=EXPON.DIST(x, lambda, cumulative) Explain

Arguments

ArgumentRequired?What it does
xYesThe waiting time; can't be negative.
lambdaYesThe rate (1 ÷ average wait); must be greater than 0.
cumulativeYesTRUE for the cumulative probability, FALSE for the density (height of the curve).

Examples

Example 1 — Will a ticket arrive within 5 minutes?

Tickets arrive on average every 10 minutes.

B4fx=EXPON.DIST(5,B3,TRUE)
AB
1MeasureValue
2Average wait (min)10
3Rate (lambda)0.1
4Within 5 min0.3935
5Quiet for 20+ min0.1353
=EXPON.DIST(5,B3,TRUE) Explain

About a 39% chance of a ticket in the next 5 minutes, and about 14% that 20 minutes pass with none.

Common mistakes

  • Passing the average instead of the rate. lambda is events per unit of time. For an average of 10 minutes, use 0.1 (or 1/10), not 10.
  • #NUM! x is negative, or lambda is 0 or negative.

Notes

Kyle Stott

Author

Kyle Stott

Certified Microsoft Excel Expert

Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.