GAMMA.DIST is an updated version of the GAMMADIST function in Excel. It takes the value and the two parameters named alpha and beta. In this tutorial, we will guide you to know how to use the GAMMA.DIST Function In Excel Spreadsheet. Get an official version of MS Excel from the following link: https://www.microsoft.com/en-in/microsoft-365/excel
GAMMA.DIST Function syntax
=GAMMA.DIST(x, alpha, beta, cumulative)
Syntax Explanation:
- x : value at which you want to evaluate the distribution.
- alpha : parameter to the distribution.
- beta : parameter to the distribution. If beta = 1 , GAMMA.DIST returns the standard gamma distribution.
- cumulative : logical value that determines the form of the function. If cumulative is TRUE , GAMMA.DIST returns the cumulative distribution function ; if FALSE , it returns the probability density function.
Example
- Firstly, you need to create the sample data with value x and the two parameters named alpha and beta.
- Then, you have to calculate the cumulative distribution.
- Now, you need to use the following formula given below.
=GAMMA.DIST(B2,B3,B4,FALSE)
- After that, you have to find the probability density distribution.
- You need to use the following formula given below.
=GAMMA.DIST(B2,B3,B4,TRUE)
NOTE:
- The GAMMA.DIST Function only works with numbers.
- If any argument other than cumulative is non-numeric , the function returns #VALUE! error.
- The function returns #NUM! Error.
- If x < 0
- If alpha < =0
- If beta < = 0
- Now, the cumulative argument can be used with boolean numbers (0 and 1) or (FALSE or TRUE).
- You can feed the arguments to the function directly or using the cell reference, as explained in the example.
Conclusion
From this article, you can get to know how to use the GAMMA.DIST Function In Excel Spreadsheet. Hope that this article is useful to you. Kindly, drop your feedback in the below sections. Thank you for Visiting Our Site!! Continue learning on Geek Excel!! *Read more on Excel Formulas *!!
Continue Reading:
Top comments (0)