Excel Statistical Functions

FUNCTIONSYNTAX
AVEDEVAVEDEV(number1, [number2], ...)
AVERAGEAVERAGE(number1, [number2], ...)
AVERAGEAAVERAGEA(value1, [value2], ...)
AVERAGEIFAVERAGEIF(range, criteria, [average_range])
AVERAGEIFSAVERAGEIFS(avg_rng, range1, criteria1, [range2], [criteria2], ...)
COMBINCOMBIN(number, number_chosen)
COUNTCOUNT(value1, [value2], ...)
COUNTACOUNTA(value1, [value2], ...)
COUNTBLANKCOUNTBLANK(range)
COUNTIFCOUNTIF(range, criteria)
COUNTIFSCOUNTIFS(range1, criteria1, [range2], [criteria2], ...)
DEVSQDEVSQ(number1, [number2], ...)
FREQUENCYFREQUENCY(data_array, bins_array)
GEOMEANGEOMEAN(number1, [number2], ...)
HARMEANHARMEAN(number1, [number2], ...)
LARGELARGE(array, n)
MAXMAX(number1, [number2], ...)
MAXAMAXA(value1, [value2], ...)
MAXIFSMAXIFS(max_range, range1, criteria1, [range2], [criteria2], ...)
MEDIANMEDIAN(number1, [number2], ...)
MINMIN(number1, [number2], ...)
MINAMINA(value1, [value2], ...)
MINIFSMINIFS(min_range, range1, criteria1, [range2], [criteria2], ...)
MODEMODE(number1, [number2], ...)
MODE.MULTMODE.MULT(number1, [number2], ...)
MODE.SNGLMODE.SNGL(number1, [number2], ...)
PERCENTILEPERCENTILE(array, k)
PERCENTILE.EXCPERCENTILE.EXC(array, k)
PERCENTILE.INCPERCENTILE.INC(array, k)
PERCENTRANKPERCENTRANK(array, x, [significance])
PERCENTRANK.EXCPERCENTILE.EXC(array, k)
PERCENTRANK.INCPERCENTILE.INC(array, k)
PERMUTPERMUT(number, number_chosen)
QUARTILEQUARTILE(array, quart)
QUARTILE.EXCQUARTILE.EXC(array, quart)
QUARTILE.INCQUARTILE.INC(array, quart)
RANKRANK(number, array, [order])
RANK.AVGRANK.AVG(number,ref,[order])
RANK.EQRANK.EQ(number,ref,[order])
SMALLSMALL(array, k)
STANDARDIZESTANDARDIZE(x, mean, standard_dev)
STDEVSTDEV(number1,[number2],...)
STDEV.PSTDEV.P(number1,[number2],...)
STDEV.SSTDEV.S(number1,[number2],...)
STDEVASTDEVA(value1, [value2], ...)
STDEVPSTDEVP(number1,[number2],...)
STDEVPASTDEVPA(value1, [value2], ...)
TRIMMEANTRIMMEAN(array, percent)
VARVAR(number1,[number2],...)
VAR.PVAR.P(number1,[number2],...)
VAR.SVAR.S(number1,[number2],...)
VARAVARA(value1, [value2], ...)
VARPVARP(number1,[number2],...)
VARPAVARPA(value1, [value2], ...)