GAMMA

The GAMMA function in Google Sheets returns the Gamma function evaluated at the specified value. The Gamma function extends the factorial to non-integer values and is a common building block in statistical distributions. Dive into our comprehensive guide to master its application.

Parameters

• number: The value at which the Gamma function is evaluated. Cannot be zero or a negative integer.

Step-by-Step Tutorial

1. Using GAMMA with a positive integer:

   • Example: =GAMMA(5)
   • Result: 24

2. Using GAMMA with a non-integer value:

   • Example: =GAMMA(0.5)
   • Result: 1.7724539

Use Cases and Scenarios

1. Statistical Analysis: Calculate the probability density function or cumulative distribution function of a continuous random variable.
2. Mathematical Modeling: Evaluate the Gamma function in equations involving factorials of non-integer values.

Related Functions

• GAMMALN: Returns the natural logarithm of the absolute value of the Gamma function.
• GAMMA.DIST: Calculates the gamma distribution, a two-parameter continuous probability distribution.
• GAMMA.INV: Calculates the inverse of the gamma cumulative distribution function.

Related Articles

• Understanding Statistical Functions in Google Sheets