GAMMA
Formulas / GAMMAReturn the gamma function value.
==GAMMA(number)
- x - required, the value at which the distribution is evaluated
- alpha - required, a parameter to the distribution
- beta - required, a parameter to the distribution
- cumulative - required, indicates whether the distribution is cumulative or not
Examples
The gamma function is used to calculate the gamma value of a real number. The Sourcetable function GAMMA(2.5) returns the gamma value of 2.5, which is 1.329.
The Sourcetable function GAMMA(-3.75) returns the gamma value of -3.75, which is 0.268.
The Sourcetable function GAMMA(-2) returns 0 because a negative integer is not a valid argument for the gamma function.
Need help with Formulas?
Summary
The GAMMA function is a mathematical tool used to calculate the gamma function value of a given number.
- The GAMMA function returns the gamma function value, which is calculated using the equation Г(N+1) = N * Г(N).
Frequently Asked Questions
What is the GAMMA.DIST function?
The GAMMA.DIST function is used to calculate the gamma distribution. It is used to study variables with a skewed distribution.
What type of variables does the GAMMA.DIST function help to study?
The GAMMA.DIST function helps to study variables with a skewed distribution.
What are the benefits of using the GAMMA.DIST function?
- It provides accurate results for variables with a skewed distribution.
- It can be used to study and analyze complex data sets.
- It is easy to use and can be applied to a variety of applications.
Work smarter
Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.
Drop CSV