Statistical functions gammainv, gammaln, geomean, growth, harmean, intercept

Excel Function GAMMAINV

The GAMMAINV() function is used to calculate the inverse of the GAMMADIST() function.

The important thing is, this function returns the inverse of cumulative distribution function.

The Syntax is as follows:


Probability Alpha Beta GAMMAINV() Formula
0.3 3 1 1.91377579412706 =GAMMAINV(L4,M4,N4)
0.5 4 7 25.7044252419563 =GAMMAINV(L5,M5,N5)
0.8 2 2 5.98861669400424 =GAMMAINV(L6,M6,N6)
0.1 7 9 35.0529012438857 =GAMMAINV(L7,M7,N7)



Excel Function GAMMALN

The GAMMALN() function is used to calculate the natural logarithm of the gamma distribution for a given value.

The natural logarithm is the one with base value of e.

The syntax is as follows:


x GAMMALN() Formula
2 0 =GAMMALN(L17)
4 1.79175946922805 =GAMMALN(L18)
11 15.1044125730755 =GAMMALN(L19)
8 8.52516136106541 =GAMMALN(L20)



Excel Function GEOMEAN

The GEOMEAN() is used to calculate the geometric mean of an array of numbers.

The geometric mean is average growth rate taking into account, the compounding effect.

The syntax is as follows:


x GEOMEAN() Formula
2 4 =GEOMEAN(L27,L30)
4 2.82842712474619 =GEOMEAN(L27:L28)
11 5.15101915380279 =GEOMEAN(L27:L28,L29:L30)
8 8.37852702443198 =GEOMEAN(L27:L29,56)





Excel Function GROWTH

The GROWTH() function is used to calculate the exponential growth curve for a given set of y-axis values.

This function can also take an optional set of x-axis values.

The syntax is as follows:

GROWTH(known y's,[x's],[x's_new],[optional var])

y GROWTH() Formula
2 1.89661659387997 =GROWTH(L40:L42)
4 2 =GROWTH(L40:L41)
11 8.15666374813476 =GROWTH(L42:L44)
8 2.3717355572556 =GROWTH(L40:L43)





Excel Function HARMEAN

The HARMEAN() function is used to calculate the harmonic mean of the given array of values.

The syntax is as follows:


x HARMEAN() Formula
2 3.56756756756757 =HARMEAN(L53:L55)
4 3.38461538461538 =HARMEAN(L53,L55)
11 4.14117647058823 =HARMEAN(L53:L54,L55:L56)
8 4.81803542673108 =HARMEAN(L53:L56,34,L54)





Excel Function INTERCEPT

The INTERCEPT() function is used to calculate the intercept of the linear regression for a given set of x vlues.

This is nothing but the interception of y axis.

The syntax is as follows:


x y INTERCEPT() Formula
3 1 -17 =INTERCEPT(N65:N66,M65:M66)
4 7 -1.4 =INTERCEPT(N65:N66,M67:M68)
2 2 16.5 =INTERCEPT(N66:N68,M65:M67)
7 9 -1.53571428571429 =INTERCEPT(N65:N68,M65:M68)

excel statistical functions gammainv gammaln geomean growth harmean intercept


You can find similar Excel Questions and Answer hereunder

1) statistical functions poisson prob quartile skew slope standardize

2) How to change the color of gridlines in a worksheet in Excel

3) statistical functions trend var vara varp varpa

4) How to freeze a row or column in Excel

5) Formula does not calculate in Excel

6) Write to text file without quotes in vba in Excel

7) Millions thousands custom number formatting in Excel

8) Converting numbers stored as text to numbers via macro in Excel

9) Generate a list of unique values in Excel

10) How do i apply a formula to an entire column in Excel


Here the previous and next chapter