ElyxAI

Excel Statistical Formulas

Functions for statistical analysis: averages, median, standard deviation, distributions, and probabilities.

98 formulas
3 Beginner
35 Intermediate
60 Advanced

MEDIAN

Beginner
=MEDIAN(number1, [number2], ...)

MODE.SNGL

Intermediate
=MODE.SNGL(number1, [number2], ...)

MODE.MULT

Intermediate
=MODE.MULT(number1, [number2], ...)

STDEV.S

Intermediate
=STDEV.S(number1, [number2], ...)

STDEV.P

Intermediate
=STDEV.P(number1, [number2], ...)

VAR.S

Intermediate
=VAR.S(number1, [number2], ...)

VAR.P

Intermediate
=VAR.P(number1, [number2], ...)

LARGE

Beginner
=LARGE(array, k)

SMALL

Beginner
=SMALL(array, k)

RANK.EQ

Intermediate
=RANK.EQ(number, ref, [order])

RANK.AVG

Intermediate
=RANK.AVG(number, ref, [order])

PERCENTILE.INC

Intermediate
=PERCENTILE.INC(array, k)

PERCENTILE.EXC

Intermediate
=PERCENTILE.EXC(array, k)

QUARTILE.INC

Intermediate
=QUARTILE.INC(array, quart)

CORREL

Advanced
=CORREL(array1, array2)

COVARIANCE.P

Advanced
=COVARIANCE.P(array1, array2)

COVARIANCE.S

Advanced
=COVARIANCE.S(array1, array2)

FORECAST.LINEAR

Advanced
=FORECAST.LINEAR(x, known_y's, known_x's)

TREND

Advanced
=TREND(known_y's, [known_x's], [new_x's], [const])

GROWTH

Advanced
=GROWTH(known_y's, [known_x's], [new_x's], [const])

SLOPE

Intermediate
=SLOPE(known_y's, known_x's)

INTERCEPT

Intermediate
=INTERCEPT(known_y's, known_x's)

NORM.DIST

Advanced
=NORM.DIST(x, mean, standard_dev, cumulative)

NORM.INV

Advanced
=NORM.INV(probability, mean, standard_dev)

FREQUENCY

Intermediate
=FREQUENCY(data_array, bins_array)

GEOMEAN

Intermediate
=GEOMEAN(number1, [number2], ...)

HARMEAN

Intermediate
=HARMEAN(number1, [number2], ...)

FORECAST.ETS

Advanced
=FORECAST.ETS(target_date, values, timeline, [seasonality], [data_completion], [aggregation])

FORECAST.ETS.CONFINT

Advanced
=FORECAST.ETS.CONFINT(target_date, values, timeline, [confidence_level], [seasonality], ...)

FORECAST.ETS.SEASONALITY

Advanced
=FORECAST.ETS.SEASONALITY(values, timeline, [data_completion], [aggregation])

FORECAST.ETS.STAT

Advanced
=FORECAST.ETS.STAT(values, timeline, statistic_type, [seasonality], [data_completion], [aggregation])

LINEST

Advanced
=LINEST(known_y's, [known_x's], [const], [stats])

LOGEST

Advanced
=LOGEST(known_y's, [known_x's], [const], [stats])

PHI

Advanced
=PHI(x)

GAMMA

Advanced
=GAMMA(number)

GAMMALN

Advanced
=GAMMALN(x)

GAMMALN.PRECISE

Advanced
=GAMMALN.PRECISE(x)

GAUSS

Advanced
=GAUSS(z)

FISHER

Advanced
=FISHER(x)

FISHERINV

Advanced
=FISHERINV(y)

PROB

Advanced
=PROB(x_range, prob_range, lower_limit, [upper_limit])

STEYX

Advanced
=STEYX(known_y's, known_x's)

RSQ

Intermediate
=RSQ(known_y's, known_x's)

PEARSON

Intermediate
=PEARSON(array1, array2)

PERMUT

Intermediate
=PERMUT(number, number_chosen)

PERMUTATIONA

Intermediate
=PERMUTATIONA(number, number_chosen)

SKEW

Advanced
=SKEW(number1, [number2], ...)

SKEW.P

Advanced
=SKEW.P(number1, [number2], ...)

KURT

Advanced
=KURT(number1, [number2], ...)

DEVSQ

Advanced
=DEVSQ(number1, [number2], ...)

AVEDEV

Intermediate
=AVEDEV(number1, [number2], ...)

TRIMMEAN

Intermediate
=TRIMMEAN(array, percent)

STANDARDIZE

Intermediate
=STANDARDIZE(x, mean, standard_dev)

AVERAGEA

Intermediate
=AVERAGEA(value1, [value2], ...)

MAXA

Intermediate
=MAXA(value1, [value2], ...)

MINA

Intermediate
=MINA(value1, [value2], ...)

BETA.DIST

Advanced
=BETA.DIST(x, alpha, beta, cumulative, [A], [B])

BETA.INV

Advanced
=BETA.INV(probability, alpha, beta, [A], [B])

BINOM.DIST

Advanced
=BINOM.DIST(number_s, trials, probability_s, cumulative)

BINOM.DIST.RANGE

Advanced
=BINOM.DIST.RANGE(trials, probability_s, number_s, [number_s2])

BINOM.INV

Advanced
=BINOM.INV(trials, probability_s, alpha)

CHISQ.DIST

Advanced
=CHISQ.DIST(x, deg_freedom, cumulative)

CHISQ.DIST.RT

Advanced
=CHISQ.DIST.RT(x, deg_freedom)

CHISQ.INV

Advanced
=CHISQ.INV(probability, deg_freedom)

CHISQ.INV.RT

Advanced
=CHISQ.INV.RT(probability, deg_freedom)

CHISQ.TEST

Advanced
=CHISQ.TEST(actual_range, expected_range)

CONFIDENCE.NORM

Advanced
=CONFIDENCE.NORM(alpha, standard_dev, size)

CONFIDENCE.T

Advanced
=CONFIDENCE.T(alpha, standard_dev, size)

EXPON.DIST

Advanced
=EXPON.DIST(x, lambda, cumulative)

F.DIST

Advanced
=F.DIST(x, deg_freedom1, deg_freedom2, cumulative)

F.DIST.RT

Advanced
=F.DIST.RT(x, deg_freedom1, deg_freedom2)

F.INV

Advanced
=F.INV(probability, deg_freedom1, deg_freedom2)

F.INV.RT

Advanced
=F.INV.RT(probability, deg_freedom1, deg_freedom2)

F.TEST

Advanced
=F.TEST(array1, array2)

GAMMA.DIST

Advanced
=GAMMA.DIST(x, alpha, beta, cumulative)

GAMMA.INV

Advanced
=GAMMA.INV(probability, alpha, beta)

HYPGEOM.DIST

Advanced
=HYPGEOM.DIST(sample_s, number_sample, population_s, number_pop, cumulative)

LOGNORM.DIST

Advanced
=LOGNORM.DIST(x, mean, standard_dev, cumulative)

LOGNORM.INV

Advanced
=LOGNORM.INV(probability, mean, standard_dev)

NEGBINOM.DIST

Advanced
=NEGBINOM.DIST(number_f, number_s, probability_s, cumulative)

NORM.S.DIST

Intermediate
=NORM.S.DIST(z, cumulative)

NORM.S.INV

Intermediate
=NORM.S.INV(probability)

PERCENTRANK.EXC

Intermediate
=PERCENTRANK.EXC(array, x, [significance])

PERCENTRANK.INC

Intermediate
=PERCENTRANK.INC(array, x, [significance])

POISSON.DIST

Advanced
=POISSON.DIST(x, mean, cumulative)

QUARTILE.EXC

Intermediate
=QUARTILE.EXC(array, quart)

STDEVA

Intermediate
=STDEVA(value1, [value2], ...)

STDEVPA

Intermediate
=STDEVPA(value1, [value2], ...)

T.DIST

Advanced
=T.DIST(x, deg_freedom, cumulative)

T.DIST.2T

Advanced
=T.DIST.2T(x, deg_freedom)

T.DIST.RT

Advanced
=T.DIST.RT(x, deg_freedom)

T.INV

Advanced
=T.INV(probability, deg_freedom)

T.INV.2T

Advanced
=T.INV.2T(probability, deg_freedom)

T.TEST

Advanced
=T.TEST(array1, array2, tails, type)

VARA

Intermediate
=VARA(value1, [value2], ...)

VARPA

Intermediate
=VARPA(value1, [value2], ...)

WEIBULL.DIST

Advanced
=WEIBULL.DIST(x, alpha, beta, cumulative)

Z.TEST

Advanced
=Z.TEST(array, x, [sigma])