SheetFX
Back to Functions

EXPONDIST

See EXPON.DIST

StatisticalEXPONDIST(x, LAMBDA, cumulative)

EXPONDIST

The EXPONDIST function in Google Sheets is used to calculate the exponential distribution. It calculates the probability of an event occurring in a given time frame based on a specified average rate. Explore our comprehensive guide to understand the application of the EXPONDIST function.

Function Syntax and Parameters

Syntax: EXPONDIST(x, LAMBDA, cumulative)

Parameters:

  • x: The value at which you want to evaluate the exponential distribution.
  • LAMBDA: The parameter value of the distribution.
  • cumulative: A logical value that determines the form of the function.

Step-by-Step Tutorial

  1. Calculating probability for a single value:

    • Example: =EXPONDIST(5, 2, TRUE)
    • Result: 0.9865761769810299

  2. Calculating cumulative probability:

    • Example: =EXPONDIST(5, 2, FALSE)
    • Result: 0.9999999999999998

Use Cases and Scenarios

  1. Reliability Analysis: Evaluate the probability of a device functioning without failure for a given time frame.
  2. Queueing Theory: Determine the average time a customer spends in a queue before being served.
  3. Financial Modeling: Calculate the likelihood of an investment reaching a certain return within a specific time period.

Related Functions

  • EXPON.DIST: Similar to EXPONDIST, but it uses different syntax.

Related Articles