# STATISTICAL | Function | Example call | Expected result | | -------------- | -------------------------------------------------------------- | --------------- | | AVEDEV | AVEDEV(\[2,4], \[8,16]) | 4.5 | | AVERAGE | AVERAGE(\[2,4], \[8,16]) | 7.5 | | AVERAGEA | AVERAGEA(\[2,4], \[8,16]) | 7.5 | | AVERAGEIF | AVERAGEIF(\[2,4,8,16], '>5', \[1, 2, 3, 4]) | 3.5 | | AVERAGEIFS | AVERAGEIFS(\[2,4,8,16], \[1,2,3,4], '>=2', \[1,2,4,8], '<=4') | 6 | | BETADIST | BETADIST(2, 8, 10, true, 1, 3) | 0.685470581 | | BETAINV | BETAINV(0.6854705810117458, 8, 10, 1, 3) | 2 | | BINOMDIST | BINOMDIST(6, 10, 0.5, false) | 0.205078125 | | CORREL | CORREL(\[3,2,4,5,6], \[9,7,12,15,17]) | 0.997054486 | | COUNT | COUNT(\[1,2], \[3,4]) | 4 | | COUNTA | COUNTA(\[1, null, 3, 'a', '', 'c']) | 4 | | COUNTBLANK | COUNTBLANK(\[1, null, 3, 'a', '', 'c']) | 2 | | COUNTIF | COUNTIF(\['Caen', 'Melbourne', 'Palo Alto', 'Singapore'], 'a') | 3 | | COUNTIFS | COUNTIFS(\[2,4,8,16], \[1,2,3,4], '>=2', \[1,2,4,8], '<=4') | 2 | | COUNTUNIQUE | COUNTUNIQUE(\[1,1,2,2,3,3]) | 3 | | COVARIANCEP | COVARIANCEP(\[3,2,4,5,6], \[9,7,12,15,17]) | 5.2 | | COVARIANCES | COVARIANCES(\[2,4,8], \[5,11,12]) | 9.666666667 | | DEVSQ | DEVSQ(\[2,4,8,16]) | 115 | | EXPONDIST | EXPONDIST(0.2, 10, true) | 0.864664717 | | FDIST | FDIST(15.2069, 6, 4, false) | 0.001223792 | | FINV | FINV(0.01, 6, 4) | 0.109309914 | | FISHER | FISHER(0.75) | 0.972955075 | | FISHERINV | FISHERINV(0.9729550745276566) | 0.75 | | FORECAST | FORECAST(30, \[6,7,9,15,21], \[20,28,31,38,40]) | 10.60725309 | | FREQUENCY | FREQUENCY(\[79,85,78,85,50,81,95,88,97], \[70,79,89]) | 1,2,4,2 | | GAMMA | GAMMA(2.5) | 1.329340392 | | GAMMALN | GAMMALN(10) | 12.80182748 | | GAUSS | GAUSS(2) | 0.477249868 | | GEOMEAN | GEOMEAN(\[2,4], \[8,16]) | 5.656854249 | | GROWTH | GROWTH(\[2,4,8,16], \[1,2,3,4], \[5]) | 32 | | HARMEAN | HARMEAN(\[2,4], \[8,16]) | 4.266666667 | | HYPGEOMDIST | HYPGEOMDIST(1, 4, 8, 20, false) | 0.363261094 | | INTERCEPT | INTERCEPT(\[2,3,9,1,8], \[6,5,11,7,5]) | 0.048387097 | | KURT | KURT(\[3,4,5,2,3,4,5,6,4,7]) | -0.151799637 | | LARGE | LARGE(\[3,5,3,5,4,4,2,4,6,7], 3) | 5 | | LINEST | LINEST(\[1,9,5,7], \[0,4,2,3], true, true) | 2,1 | | LOGNORMDIST | LOGNORMDIST(4, 3.5, 1.2, true) | 0.039083556 | | LOGNORMINV | LOGNORMINV(0.0390835557068005, 3.5, 1.2, true) | 4 | | MAX | MAX(\[0.1,0.2], \[0.4,0.8], \[true, false]) | 0.8 | | MAXA | MAXA(\[0.1,0.2], \[0.4,0.8], \[true, false]) | 1 | | MEDIAN | MEDIAN(\[1,2,3], \[4,5,6]) | 3.5 | | MIN | MIN(\[0.1,0.2], \[0.4,0.8], \[true, false]) | 0.1 | | MINA | MINA(\[0.1,0.2], \[0.4,0.8], \[true, false]) | 0 | | MODEMULT | MODEMULT(\[1,2,3,4,3,2,1,2,3]) | 2,3 | | MODESNGL | MODESNGL(\[1,2,3,4,3,2,1,2,3]) | 2 | | NORMDIST | NORMDIST(42, 40, 1.5, true) | 0.90878878 | | NORMINV | NORMINV(0.9087887802741321, 40, 1.5) | 42 | | NORMSDIST | NORMSDIST(1, true) | 0.841344746 | | NORMSINV | NORMSINV(0.8413447460685429) | 1 | | PEARSON | PEARSON(\[9,7,5,3,1], \[10,6,1,5,3]) | 0.699378606 | | PERCENTILEEXC | PERCENTILEEXC(\[1,2,3,4], 0.3) | 1.5 | | PERCENTILEINC | PERCENTILEINC(\[1,2,3,4], 0.3) | 1.9 | | PERCENTRANKEXC | PERCENTRANKEXC(\[1,2,3,4], 2, 2) | 0.4 | | PERCENTRANKINC | PERCENTRANKINC(\[1,2,3,4], 2, 2) | 0.33 | | PERMUT | PERMUT(100, 3) | 970200 | | PERMUTATIONA | PERMUTATIONA(4, 3) | 64 | | PHI | PHI(0.75) | 0.301137432 | | POISSONDIST | POISSONDIST(2, 5, true) | 0.124652019 | | PROB | PROB(\[1,2,3,4], \[0.1,0.2,0.2,0.1], 2, 3) | 0.4 | | QUARTILEEXC | QUARTILEEXC(\[1,2,3,4], 1) | 1.25 | | QUARTILEINC | QUARTILEINC(\[1,2,3,4], 1) | 1.75 | | RANKAVG | RANKAVG(4, \[2,4,4,8,8,16], false) | 4.5 | | RANKEQ | RANKEQ(4, \[2,4,4,8,8,16], false) | 4 | | RSQ | RSQ(\[9,7,5,3,1], \[10,6,1,5,3]) | 0.489130435 | | SKEW | SKEW(\[3,4,5,2,3,4,5,6,4,7]) | 0.359543071 | | SKEWP | SKEWP(\[3,4,5,2,3,4,5,6,4,7]) | 0.303193339 | | SLOPE | SLOPE(\[1,9,5,7], \[0,4,2,3]) | 2 | | SMALL | SMALL(\[3,5,3,5,4,4,2,4,6,7], 3) | 3 | | STANDARDIZE | STANDARDIZE(42, 40, 1.5) | 1.333333333 | | STDEVA | STDEVA(\[2,4], \[8,16], \[true, false]) | 6.013872851 | | STDEVP | STDEVP(\[2,4], \[8,16], \[true, false]) | 5.361902647 | | STDEVPA | STDEVPA(\[2,4], \[8,16], \[true, false]) | 5.489889697 | | STDEVS | STDEVS(\[2,4], \[8,16], \[true, false]) | 6.191391874 | | STEYX | STEYX(\[2,3,9,1,8,7,5], \[6,5,11,7,5,4,4]) | 3.30571895 | | TDIST | TDIST(60, 1, true) | 0.994695326 | | TINV | TINV(0.9946953263673741, 1) | 60 | | TRIMMEAN | TRIMMEAN(\[4,5,6,7,2,3,4,5,1,2,3], 0.2) | 3.777777778 | | VARA | VARA(\[2,4], \[8,16], \[true, false]) | 36.16666667 | | VARP | VARP(\[2,4], \[8,16], \[true, false]) | 28.75 | | VARPA | VARPA(\[2,4], \[8,16], \[true, false]) | 30.13888889 | | VARS | VARS(\[2,4], \[8,16], \[true, false]) | 38.33333333 | | WEIBULLDIST | WEIBULLDIST(105, 20, 100, true) | 0.92958139 | | ZTEST | ZTEST(\[3,6,7,8,6,5,4,2,1,9], 4) | 0.090574197 |