GAMMALN function - The function returns the natural logarithm of the gamma function, Γ (x) in Excel
The following article introduces you to the GAMMALN function - one of the functions in the statistical function group is very popular in Excel.
Description: The function returns the natural logarithm of the gamma function, Γ (x).
Syntax: GAMMALN (x)
Inside:
- x: The value you want to calculate the natural logarithm of the gamma function, Γ (x). .
Attention:
- If the function's x value is not numeric -> the function returns the #VALUE! Error value
- If x ≤ 0 the function returns the #NUM! Error value
- The exponent e of GAMMALN (i), i is an integer, returns the same result as (i - 1) !.
- The function is calculated as follows:
[GAMMALN = LNleft ({Gamma left (x right)} right)]
Inside:
(fleft (x right) = left {{begin {array} {* {20} {c}}
{0 ,,,,,,, {rm {if}}, x <0}
{x ,,,, { rm {if}}, 0 le x le 1}
{1 ,,,,,,,, {rm {if}}, x> 1}
end {array}} right.,)
For example:
Calculate the natural logarithm value of the gamma function, Γ (x) of the values in the following data table:
- In the cell to calculate enter the formula : = GAMMALN (C6)
- Press Enter -> the natural logarithmic value of the gamma function, Γ (x) is:
- Similarly copying the formula for the remaining values results:
Where x ≤ 0 -> the function returns the #NUM! Error value
Above are instructions and some specific examples when using the GAMMALN 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
- 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
- QUARTILE.EXC function - The function returns the quartile of a dataset without values 0 and 1 in Excelquartile.exc function: the function returns the quartile of the data set, with percentile values from 0 to 1 excluding 0 and 1. the support function is from excel 2010 onwards. syntax: quartile.exc (array, quart)
- What is gamma-ray burst?the first thing you imagine in your head when listening to the gamma rays phrase - what is the gamma flash? join tipsmake.com to learn about gamma ray bursts!
- PHI function - The function returns the value of the density function for a normal distribution in Excelphi function: the function returns the value of the density function for a standard normal distribution. support functions from excel 2013 onwards. syntax: phi (x)
- FORECAST function - The function returns a value along a linear trend in Excelforecast function: the function performs the calculation or prediction of a future value by using current values using linear regression. in excel 2016 this function is replaced by forecast.linear function. syntax: forecast (x, known_ys, known_xs)
- BETA.DIST function - The function returns the Beta distribution in Excelbeta.dist function: the function returns the beta distribution to study the variability of a number of things through a sample. support functions from excel 2010 onwards. syntax: beta.dist (x, alpha, beta, cumulative, [a], [b])
- How to use the IFS function in Excel 2016the ifs function in excel is a logical function introduced in excel 2016. this function is a function that replaces the nested if function and is much easier to use. the ifs function checks one or more conditions and returns a value that meets the first true condition.
- FTEST function - The function returns the result of an F-Test in Excelthe following article details how to use ftest - the function returns the result of an f-test. in statistical probability, the determination of the correctness and the deviation between two data samples is a regular and extremely important job.
- How to use ADDRESS function in Excelthe address function in excel takes the number of rows and column numbers as arguments and returns the reference of the standard cell (cell address). for example, if you go to row 4 and column 3, the function returns c4.
- FISHER function - The function returns the Fissher transformation at x in Excelfisher function: the function returns the fissher transformation at x. this transformation creates a normal distribution function, using this function to test a hypothesis based on a correlation coefficient. syntax: fisher (x)
- QUARTILE function - The function returns the quartile of a dataset in Excelthe quartile is an indispensable value in the field of surveying and sales, it helps you evaluate certain criteria in a set. the following article details how to use quartile function, the function returns the quartile of a dataset.