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:
GAMMAINV(probability,alpha,beta)
| 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:
GAMMALN(x)
| 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:
GEOMEAN(num1,num2,..num255)
| 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) |
7.55662969711176
=GEOMEAN(L27:L31)
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) |
2.0936636941679
=GROWTH(L40:L44)
Excel Function HARMEAN
The HARMEAN() function is used to calculate the harmonic mean of the given array of values.
The syntax is as follows:
HARMEAN(num1,num2,�num255)
| 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) |
5.56682397831108
=HARMEAN(12,L53:L57)
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:
INTERCEPT(x,y)
| 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) |
