SheetFX
≡
<< Go back to all functions

GAMMA

The GAMMA function in Google Sheets returns the Gamma function evaluated at the specified value. This function is commonly used in statistical analysis and mathematical modeling.

Function Syntax and Parameters

Syntax: GAMMA(number)

Parameters:

  • number: The value at which the Gamma function is evaluated.

Step-by-Step Tutorial

  1. Using GAMMA with a number:
    • Example: =GAMMA(5)
    • Result: The Gamma function evaluated at 5.

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 complex numbers.

Related Functions

  • GAMMALN: Returns the natural logarithm of the absolute value of the Gamma function.

Note: The GAMMA function is a mathematical function and does not have any related articles or videos specific to Google Sheets.