GAMMA

Formulas / GAMMA
Return 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.


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.

Related Functions

Sourcetable Logo

Work smarter

Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.

Try out Sourcetable
Drop CSV