GAMMA function - The function returns the gamma function value in Excel
The following article introduces you to the GAMMA function - one of the functions in the statistical function group is very popular in Excel.
GAMMA function - The function returns the gamma function value in Excel Picture 1
Description: The function returns the gamma function value . Support functions from Excel 2013 onwards.
Syntax: GAMMA (number )
Inside:
- number: The value you want to calculate the gamma function value .
Attention:
- Function of calculation using equation:
[Gamma left (N right) = intlimits_0 ^ infty {{t ^ {N - 1}} {e ^ {- t}} dt}]
- If number is a negative integer or equal to 0 -> the function returns the #NUM! Error value .
- If the number value is not valid -> the function returns the error value #VALUE!
For example:
Find the value of the GAMMA function of the values in the data table below:
GAMMA function - The function returns the gamma function value in Excel Picture 2 u
- In the cell to calculate enter the formula : = GAMMA (C6)
GAMMA function - The function returns the gamma function value in Excel Picture 3
- Similarly copying the formula for the remaining values results:
GAMMA function - The function returns the gamma function value in Excel Picture 4
- Where the number value is a negative integer or equal to 0 -> the function returns the #NUM! Error value
GAMMA function - The function returns the gamma function value in Excel Picture 5
- Where the number value is not a numerical value -> the function returns the error value #VALUE!
GAMMA function - The function returns the gamma function value in Excel Picture 6
Above are instructions and some specific examples when using the GAMMA function in Excel.
Good luck!
You should read it
- GAMMA.INV function - The function returns the inverse of the gamma distribution in Excel
- GAMMA.DIST function - The function returns the gamma distribution in Excel
- GAMMALN.PRECISE function - The function returns the natural logarithm of the gamma function, Γ (x) in Excel
- GAMMALN function - The function returns the natural logarithm of the gamma function, Γ (x) in Excel
- What is gamma-ray burst?
- How to use Gamma AI to create stunning presentations
- How to use the IFS function in Excel 2016
- How to use the IF function in Excel
- OR function in Excel, how to use the OR function, and examples
- Save time with these text formatting functions in Microsoft Excel
- CHISQ.TEST function - The function returns the independence test in Excel
- FORECAST function - The function returns a value along a linear trend in Excel
May be interested
GAMMA.DIST function - The function returns the gamma distribution in Excel
SECOND function - The function returns the second part of a time value in Excel
TIME function - Function returns decimal numbers for a specific time value in Excel
TIMEVALUE function - The function returns the decimal number of time expressed as a text string in Excel
AVEDEV function
AVERAGE function - The function returns the average of the arguments in Excel