EXPON.DIST

Formulas / EXPON.DIST
Calculate the exponential distribution.
EXPONDIST(x,lambda,cumulative)
  • x - required argument that is the value of the function
  • lambda - required argument that is the parameter value
  • cumulative - required argument that indicates which form of the exponential function to use

Examples

  • =EXPONDIST( 0.5, 1, FALSE )

    The EXPON.DIST function is used to calculate the probability density function (PDF) for the exponential distribution. For example, the formula returns the probability density value of 0.60653066, which is the PDF of the exponential distribution with λ = 0.5 and x = 0.5.

  • =EXPONDIST( 0.5, 1, TRUE )

    The EXPON.DIST function can also be used to calculate the cumulative distribution function (CDF) for the exponential distribution. For example, the formula returns the cumulative distribution value of 0.39346934, which is the CDF of the exponential distribution with λ = 0.5 and x = 0.5.

Summary

The EXPON.DIST function returns the exponential distribution, allowing users to calculate the probability of a given event occurring.

  • The EXPON.DIST function in Sourcetable can be used to model the time between events as it calculates an exponential distribution.


Frequently Asked Questions

What is the EXPON.DIST function?
The EXPON.DIST function calculates the exponential distribution, which models the time between events.
What is the syntax of the EXPON.DIST function?
The syntax is EXPON.DIST(x, lambda, cumulative).
What parameters do I need to use the EXPON.DIST function?
You need two parameters: x and lambda. X is the value for which you want to calculate the exponential distribution. Lambda is the rate parameter for the distribution.
What type of values do I need to use with the EXPON.DIST function?
Both x and lambda need to be numeric values. If either x or lambda is not numeric, the function will return a #VALUE! error.

Make Better Decisions
With Data

Analyze data, automate reports and create live dashboards
for all your business applications, without code. Get unlimited access free for 14 days.