Skip to Content
 AVEDEV
AVEDEV(number1, [number2], ...)
 AVERAGE
AVERAGE(number1, [number2], ...)
 AVERAGEA
AVERAGEA(value1, [value2], ...)
 AVERAGEIF
AVERAGEIF(range, criteria, [average_range])
 AVERAGEIFS
AVERAGEIFS(average_range, criteria_range1, ...)
 BETA.DIST
BETA.DIST(x, alpha, beta, cumulative, [A], [B])
 BETA.INVn
BETA.INV(probability, alpha, beta, [A], [B])
 BINOM.DIST
BINOM.DIST(number_s, trials, probability_s, cumulative)
 BINOM.DIST.RANGE
BINOM.DIST.RANGE(trials, probability_s, ...)
 BINOM.INV
BINOM.INV(trials, probability_s, alpha)
 CHISQ.DIST
CHISQ.DIST(x, deg_freedom, cumulative)
 CHISQ.DIST.RT
CHISQ.DIST.RT(x, deg_freedom)
 CHISQ.INV
CHISQ.INV(probability, deg_freedom)
 CHISQ.INV.RT
CHISQ.INV.RT(probability, deg_freedom)
 CHISQ.TEST
CHISQ.TEST(actual_range, expected_range)
 CONFIDENCE.NORM
CONFIDENCE.NORM(alpha, standard_dev, size)
 CONFIDENCE.T
CONFIDENCE.T(alpha, standard_dev, size)
 CORREL
CORREL(array1, array2)
 COUNT
COUNT(value1, [value2], ...)
 COUNTA
COUNTA(value1, [value2], ...)
 COUNTBLANK
COUNTBLANK(range)
 COUNTIF
COUNTIF(range, criteria)
 COUNTIFS
COUNTIFS(criteria_range1, criteria1, ...)
 COVARIANCE.P
COVARIANCE.P(array1, array2)
 COVARIANCE.S
COVARIANCE.S(array1, array2)
 DEVSQ
DEVSQ(number1, [number2], ...)
 EXPON.DIST
EXPON.DIST(x, lambda, cumulative)
 F.DIST
F.DIST(x, deg_freedom1, deg_freedom2, cumulative)
 F.DIST.RT
F.DIST.RT(x, deg_freedom1, deg_freedom2)
 F.INV
F.INV(probability, deg_freedom1, deg_freedom2)
 F.INV.RT
F.INV.RT(probability, deg_freedom1, deg_freedom2)
 FISHER
FISHER(x)
 FISHERINV
FISHERINV(y)
 FORECAST
FORECAST(x, known_y's, known_x's)
 FORECAST.ETS
FORECAST.ETS(target_date, values, ...)
 FORECAST.ETS.CONFINT
FORECAST.ETS.CONFINT(target_date, ...)
 FORECAST.ETS.SEASONALITY
FORECAST.ETS.SEASONALITY(values, ...)
 FORECAST.ETS.STAT
FORECAST.ETS.STAT(values, timeline, ...)
 FORECAST.LINEAR
FORECAST.LINEAR(x, known_y's, known_x's)
 FREQUENCY
FREQUENCY(data_array, bins_array)
 F.TEST
F.TEST(array1, array2)
 GAMMA
GAMMA(number)
 GAMMA.DIST
GAMMA.DIST(x, alpha, beta, cumulative)
 GAMMA.INV
GAMMA.INV(probability, alpha, beta)
 GAMMALN
GAMMALN(x)
 GAMMALN.PRECISE
GAMMALN.PRECISE(x)
 GAUSS
GAUSS(z)
 GEOMEAN
GEOMEAN(number1, [number2], ...)
 GROWTH
GROWTH(known_y's, [known_x's], [new_x's], [const])
 HARMEAN
HARMEAN(number1, [number2], ...)
 HYPGEOM.DIST
HYPGEOM.DIST(sample_s, number_sample, ...)
 INTERCEPT
INTERCEPT(known_y's, known_x's)
 KURT
KURT(number1, [number2], ...)
 LARGE
LARGE(array, k)
 LINEST
LINEST(known_y's, [known_x's], [const], [stats])
 LOGEST
LOGEST(known_y's, [known_x's], [const], [stats])
 LOGNORM.DIST
LOGNORM.DIST(x, mean, standard_dev, cumulative)
 LOGNORM.INV
LOGNORM.INV(probability, mean, standard_dev)
 MAX
MAX(number1, [number2], ...)
 MAXA
MAXA(value1, [value2], ...)
 MAXIFS
MAXIFS(max_range, criteria_range1, ...)
 MEDIAN
MEDIAN(number1, [number2], ...)
 MIN
MIN(number1, [number2], ...)
 MINIFS
MINIFS(min_range, criteria_range1, ...)
 MINA
MINA(value1, [value2], ...)
 MODE.MULT
MODE.MULT(number1, [number2], ...)
 MODE.SNGL
MODE.SNGL(number1, [number2], ...)
 NEGBINOM.DIST
NEGBINOM.DIST(number_f, number_s, probability_s, cumulative)
 NORM.DIST
NORM.DIST(x, mean, standard_dev, cumulative)
 NORMINV
NORM.INV(probability, mean, standard_dev)
 NORM.S.DIST
NORM.S.DIST(z, cumulative)
 NORM.S.INV
NORM.S.INV(probability)
 PEARSON
PEARSON(array1, array2)
 PERCENTILE.EXC
PERCENTILE.EXC(array, k)
 PERCENTILE.INC
PERCENTILE.INC(array, k)
 PERCENTRANK.EXC
PERCENTRANK.EXC(array, x, [significance])
 PERCENTRANK.INC
PERCENTRANK.INC(array, x, [significance])
 PERMUT
PERMUT(number, number_chosen)
 PERMUTATIONA
PERMUTATIONA(number, number_chosen)
 PHI
PHI(x)
 POISSON.DIST
POISSON.DIST(x, mean, cumulative)
 PROB
PROB(x_range, prob_range, [lower_limit], [upper_limit])
 QUARTILE.EXC
QUARTILE.EXC(array, quart)
 QUARTILE.INC
QUARTILE.INC(array, quart)
 RANK.AVG
RANK.AVG(number, ref, [order])
 RANK.EQ
RANK.EQ(number, ref, [order])
 RSQ
RSQ(known_y's, known_x's)
 SKEW
SKEW(number1, [number2], ...)
 SKEW.P
SKEW.P(number1, [number2], ...)
 SLOPE
SLOPE(known_y's, known_x's)
 SMALL
SMALL(array, k)
 STANDARDIZE
STANDARDIZE(x, mean, standard_dev)
 STDEV.P
STDEV.P(number1, [number2], ...)
 STDEV.S
STDEV.S(number1, [number2], ...)
 STDEVA
STDEVA(value1, [value2], ...)
 STDEVPA
STDEVPA(value1, [value2], ...)
 STEYX
STEYX(known_y's, known_x's)
 T.DIST
T.DIST(x, deg_freedom, cumulative)
 T.DIST.2T
T.DIST.2T(x, deg_freedom)
 T.DIST.RT
T.DIST.RT(x, deg_freedom)
 T.INV
T.INV(probability, deg_freedom)
 T.INV.2T
T.INV.2T(probability, deg_freedom)
 TREND
TREND(known_y's, [known_x's], [new_x's], [const])
 TRIMMEAN
TRIMMEAN(array, percent)
 T.TEST
T.TEST(array1, array2, tails, type)
 VAR.P
VAR.P(number1, [number2], ...)
 VAR.S
VAR.S(number1, [number2], ...)
 VARA
VARA(value1, [value2], ...)
 VARPA
VARPA(value1, [value2], ...)
 WEIBULL.DIST
WEIBULL.DIST(x, alpha, beta, cumulative)
 Z.TEST
Z.TEST(array, x, [sigma])

Statistical

Statistical functions help to perform statistical analysis.