Buzz
The EXPONDIST function returns the result of the exponential distribution. This function is primarily applied to model time between events, such as determining how long an ATM takes to dispense cash or calculating the probability of a process occurring within a certain defined time interval.
Guide on How to Use EXPONDIST Function
How to Use EXPONDIST Function - Illustrated Examples
Syntax: EXPONDIST(x,lambda,cumulative)
Where:
- x: Mandatory - Value of the function.
- lambda: Mandatory - Parameter value.
- cumulative: Mandatory - Logical value indicating which form of the exponential function to provide.
Consider an Example
You input your actual values into Excel corresponding to the function parameters in Excel cells, and in this example, the function value is 0.3, the parameter value is 12, and the two logical values are TRUE and FALSE:
Input the Formula to Calculate
- And the calculated result of the function with the logic value set to TRUE is 0.972676278:
- The computed result of the function with the logic value set to FALSE is 0.327884669:
So now you understand how to use the EXPONDIST function in Excel. Key points to note about this function are that the function values and parameters must be in numeric form, and when the logic value is TRUE, it returns the cumulative distribution function, while if it is FALSE, it returns the probability density function. You can apply this function in Office 2013, Office 2010, Office 2007, and Office 2003.
