STATISTICAL
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