Statistical
Statistical functions help to perform statistical analysis.
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])
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])