Statistical Functions

AVEDEVThe average deviation of the numbers in a list, table or cell range.
AVERAGEThe arithmetic mean of non blank cells in a list, table or cell range.
AVERAGEAThe arithmetic mean of non blank cells in a list, table or cell range (including logical values and text).
AVERAGEIFThe arithmetic mean of all the numbers in a range that satisfies one condition.
AVERAGEIFSThe arithmetic mean of all the numbers in a range that satisfies multiple conditions.
BETA.DIST(2010) The probability of getting less than or equal to a particular value in a beta distribution.
BETA.INV(2010) The probability of getting greater than a particular value in a beta distribution.
BETADIST(BETA.DIST) The probability of getting less than or equal to a particular value in a beta distribution.
BETAINV(BETA.INV) The probability of getting greater than a particular value in a beta distribution.
BINOM.DIST(2010) The probability of getting less than or equal to a particular value in a binomial distribution.
BINOM.DIST.RANGE(2013) The probability of a trial result using a binomial distribution.
BINOM.INV(2010) The probability of getting greater than a particular value in a binomial distribution.
BINOMDIST(BINOM.DIST) The probability of getting less than or equal to a particular value in a binomial distribution.
CHIDIST(CHISQ.DIST.RT) The probability of getting less than or equal to a particular value in a chi-squared distribution (right tailed).
CHIINV(CHISQ.INV.RT) The probability of getting greater than a particular value in a chi-squared distribution (right tailed).
CHISQ.DIST(2010) The probability of getting less than or equal to a particular value in a chi-squared distribution (left tailed).
CHISQ.DIST.RT(2010) The probability of getting more than a particular value in a chi-squared distribution (right tailed).
CHISQ.INV(2010) The probability of getting greater than a particular value in a chi-squared distribution (left tailed).
CHISQ.INV.RT(2010) The probability of getting more than a particular value in a chi-squared distribution (right tailed).
CHISQ.TEST(2010) The value from the chi-squared distribution.
CHITEST(CHISQ.TEST) The value from the chi-squared distribution.
CONFIDENCE(CONFIDENCE.NORM) The confidence interval for a population mean.
CONFIDENCE.NORM(2010) The confidence interval for a population mean.
CONFIDENCE.T(2010) The confidence interval for a population mean using a t distribution.
CORRELThe correlation coefficient between two data sets.
COUNTThe number of non blank cells in a list, table or cell range.
COUNTAThe number of non blank cells in a list, table or cell range (including logical values and text).
COUNTBLANKThe number of blank cells in a list, table or cell range.
COUNTIFThe number of non blank cells that satisfies one condition.
COUNTIFSThe number of non blank cells that satisfies multiple conditions.
COVAR(COVARIANCE.P) The average of the products of deviations for each data point pair.
COVARIANCE.P(2010) The covariance based on an entire population.
COVARIANCE.S(2010) The covariance based on a sample.
CRITBINOM(BINOM.INV) The probability of getting greater than a particular value in a binomial distribution.
DEVSQThe sum of the squared deviations from the mean.
EXPON.DIST(2010) The exponential distribution.
EXPONDIST(EXPON.DIST) The exponential distribution.
F.DIST(2010) The probability of getting less than or equal to a particular value in an f distribution (left tailed).
F.DIST.RT(2010) The probability of getting less than or equal to a particular value in an f distribution (right tailed).
F.INV(2010) The probability of getting greater than a particular value in an f distribution (left tailed).
F.INV.RT(2010) The probability of getting greater than a particular value in an f distribution (right tailed).
F.TEST(2010) The value from the f test.
FDIST(F.DIST) The probability of getting less than or equal to a particular value in an f distribution (no cumulative) (left tailed).
FINV(F.INV) The probability of getting greater than a particular value in an f distribution (left tailed).
FISHERThe fisher transformation.
FISHERINVThe inverse of the fisher transformation.
FORECAST(FORECAST.LINEAR) The future y-value along a linear trend using existing values.
FORECAST.ETS(2016) The future value based on historical values.
FORECAST.LINEAR(2016) The future y-value along a linear trend using existing values.
FREQUENCYThe number of times a particular value occurs in a list, table or cell range.
FTEST(F.TEST) The value from the f test.
GAMMA(2013) The gamma function value.
GAMMA.DIST(2010) The probability of getting less than or equal to a particular value in a gamma distribution.
GAMMA.INV(2010) The probability of getting greater than a particular value in a gamma distribution.
GAMMADIST(GAMMA.DIST) The probability of getting less than or equal to a particular value in a gamma distribution.
GAMMAINV(GAMMA.INV) The probability of getting greater than a particular value in a gamma distribution.
GAMMALN(GAMMALN.PRECISE) The natural logarithm of the gamma function.
GAMMALN.PRECISE(2010) The natural logarithm of the gamma function.
GAUSS(2013) The 0.5 less than the standard normal cumulative distribution.
GEOMEANThe geometric mean of an array of numbers.
GROWTHThe predicted exponential growth using existing data.
HARMEANThe harmonic mean of a data set.
HYPGEOM.DIST(2010) The probability of getting less than or equal to a particular value in a hyper geometric distribution (finite population).
HYPGEOMDIST(HYPGEOM.DIST) The probability of getting less than or equal to a particular value in a hyper geometric distribution (finite population) (no cumulative).
INTERCEPTThe intersection with the y-axis using a linear regression plotted through known values.
KURTThe kurtosis for a list or array of numbers.
LARGEThe kth largest value in a list or array of numbers.
LINESTThe array of values for a straight line that best fits your data.
LOGESTThe array of values for an exponential curve that best fits your data.
LOGINV(LOGNORM.INV) The probability of getting greater than a particular value in a lognormal distribution.
LOGNORM.DIST(2010) The probability of getting less than or equal to a particular value in a lognormal distribution.
LOGNORM.INV(2010) The probability of getting greater than a particular value in a lognormal distribution.
LOGNORMDIST(LOGNORM.DIST) The probability of getting less than or equal to a particular value in a lognormal distribution (no cumulative).
MAXThe largest value in a list or array of numbers.
MAXAThe largest value in a list or array of numbers (including logical values and text).
MAXIFS(2016) The largest value in a list or array of numbers that satisfies multiple conditions.
MEDIANThe median value in a list or array of numbers.
MINThe smallest value in a list or array of numbers.
MINAThe smallest value in a list or array of numbers (including logical values and text).
MINIFS(2016) The smallest value in a list or array of numbers that satisfies multiple conditions.
MODE(MODE.SNGL) The value that occurs most frequently in a list or array of numbers.
MODE.MULT(2010) The array of most frequent or repetitive values.
MODE.SNGL(2010) The value that occurs most frequently in a list or array of numbers.
NEGBINOM.DIST(2010) The probability of getting less than or equal to a particular value in a negative binomial distribution.
NEGBINOMDIST(NEGBINOM.DIST) The probability of getting less than or equal to a particular value in a negative binomial distribution (no cumulative).
NORM.DIST(2010) The probability of getting less than or equal to a particular value in a normal distribution.
NORM.INV(2010) The x variable corresponding to less than a particular probability.
NORM.S.DIST(2010) The probability of getting less than or equal to a particular value in a standard normal distribution.
NORM.S.INV(2010) The x variable corresponding to less than a particular probability.
NORMDIST(NORM.DIST) The probability of getting less than or equal to a particular value in a normal distribution.
NORMINV(NORM.INV) The x variable corresponding to less than a particular probability.
NORMSDIST(NORM.S.DIST) The probability of getting less than or equal to a particular value in a normal distribution (no cumulative).
NORMSINV(NORM.S.INV) The x variable corresponding to less than a particular probability.
PEARSONThe pearson product moment correlation coefficient.
PERCENTILE(PERCENTILE.INC) The number corresponding to a particular percentage from an array of numbers (inclusive).
PERCENTILE.EXC(2010) The number corresponding to a particular percentage from an array of numbers (exclusive).
PERCENTILE.INC(2010) The number corresponding to a particular percentage from an array of numbers (inclusive).
PERCENTRANK(PERCENTRANK.INC) The percentage rank of a value in an array of numbers (inclusive).
PERCENTRANK.EXC(2010) The percentage rank of a value in an array of numbers (exclusive).
PERCENTRANK.INC(2010) The percentage rank of a value in an array of numbers (inclusive).
PERMUTThe number of permutations for a subset of objects or events.
PERMUTATIONA(2013) The number of permutations for a subset of objects or events (with repetition).
PHI(2013) The value of the density function for a standard normal distribution.
POISSON(POISSON.DIST) The probability of getting less than or equal to a particular value in a poisson distribution.
POISSON.DIST(2010) The probability of getting less than or equal to a particular value in a poisson distribution.
PROBThe probability that values in a range are between two limits.
QUARTILE(QUARTILE.INC) The quartile of a data set (inclusive).
QUARTILE.EXC(2010) The quartile of a data set (exclusive).
QUARTILE.INC(2010) The quartile of a data set (inclusive).
RANK(RANK.EQ) The rank of a value in a list, table or cell range (in descending order) (equal ranking).
RANK.AVG(2010) The rank of a value in a list, table or cell range (in descending order) (average ranking).
RANK.EQ(2010) The rank of a value in a list, table or cell range (in descending order) (equal ranking).
RSQThe square of pearson product moment correlation coefficient through data points in known y's and known x's.
SKEWThe number representing the skewness of a distribution based on a sample.
SKEW.P(2013) The number representing the skewness of a distribution based on an entire population.
SLOPEThe slope of a linear regression line through the given data points.
SMALLThe kth smallest value in a list or array of numbers.
STANDARDIZEThe normalized value from a distributed characterised by a mean and a standard deviation.
STDEV(STDEV.S) The standard deviation based on a sample.
STDEV.P(2010) The standard deviation based on an entire population.
STDEV.S(2010) The standard deviation based on a sample.
STDEVAThe standard deviation based on a sample (including logical values and text).
STDEVP(STDEV.P) The standard deviation based on an entire population.
STDEVPAThe standard deviation based on an entire population (including logical values and text).
STEYXThe standard error of a regression.
T.DIST(2010) The probability of getting less than or equal to a particular value in a t distribution (left tailed).
T.DIST.2T(2010) The percentage points probability for the t distribution.
T.DIST.RT(2010) The probability of getting greater than a particular value in a t distribution (right tailed).
T.INV(2010) The probability of getting greater than a particular value in a t distribution (left tailed)
T.INV.2T(2010) The t value of the t distribution as a function of the probability and the degrees of freedom.
T.TEST(2010) The probability associated with a t test.
TDIST(T.DIST.2T) The percentage points probability for the t distribution.
TINV(T.INV.2T) The t-value of the distribution as a function of the probability and the degrees of freedom.
TRENDThe y-values along a linear trend given a set of x-values.
TRIMMEANThe mean of the interior of a data set.
TTEST(T.TEST) The probability associated with a t test.
VAR(VAR.S) The variance based on a sample.
VAR.P(2010) The variance based on an entire population.
VAR.S(2010) The variance based on a sample.
VARAThe variance based on a sample (including logical values and text).
VARP(VAR.P) The variance based on an entire population.
VARPAThe variance based on an entire population (including logical values and text).
WEIBULL(WEIBULL.DIST) The probability of getting less than or equal to a particular value in a weibull distribution.
WEIBULL.DIST(2010) The probability of getting less than or equal to a particular value in a weibull distribution.
Z.TEST(2010) The two-tailed p-value of a z-test.
ZTEST(Z.TEST) The two-tailed p-value of a z-test.
AVEDEV
The average deviation of the numbers in a list, table or cell range.
AVERAGE
The arithmetic mean of non blank cells in a list, table or cell range.
AVERAGEA
The arithmetic mean of non blank cells in a list, table or cell range (including logical values and text).
AVERAGEIF
The arithmetic mean of all the numbers in a range that satisfies one condition.
AVERAGEIFS
The arithmetic mean of all the numbers in a range that satisfies multiple conditions.
BETA.DIST
(2010) The probability of getting less than or equal to a particular value in a beta distribution.
BETA.INV
(2010) The probability of getting greater than a particular value in a beta distribution.
BETADIST
(BETA.DIST) The probability of getting less than or equal to a particular value in a beta distribution.
BETAINV
(BETA.INV) The probability of getting greater than a particular value in a beta distribution.
BINOM.DIST
(2010) The probability of getting less than or equal to a particular value in a binomial distribution.
BINOM.DIST.RANGE
(2013) The probability of a trial result using a binomial distribution.
BINOM.INV
(2010) The probability of getting greater than a particular value in a binomial distribution.
BINOMDIST
(BINOM.DIST) The probability of getting less than or equal to a particular value in a binomial distribution.
CHIDIST
(CHISQ.DIST.RT) The probability of getting less than or equal to a particular value in a chi-squared distribution (right tailed).
CHIINV
(CHISQ.INV.RT) The probability of getting greater than a particular value in a chi-squared distribution (right tailed).
CHISQ.DIST
(2010) The probability of getting less than or equal to a particular value in a chi-squared distribution (left tailed).
CHISQ.DIST.RT
(2010) The probability of getting more than a particular value in a chi-squared distribution (right tailed).
CHISQ.INV
(2010) The probability of getting greater than a particular value in a chi-squared distribution (left tailed).
CHISQ.INV.RT
(2010) The probability of getting more than a particular value in a chi-squared distribution (right tailed).
CHISQ.TEST
(2010) The value from the chi-squared distribution.
CHITEST
(CHISQ.TEST) The value from the chi-squared distribution.
CONFIDENCE
(CONFIDENCE.NORM) The confidence interval for a population mean.
CONFIDENCE.NORM
(2010) The confidence interval for a population mean.
CONFIDENCE.T
(2010) The confidence interval for a population mean using a t distribution.
CORREL
The correlation coefficient between two data sets.
COUNT
The number of non blank cells in a list, table or cell range.
COUNTA
The number of non blank cells in a list, table or cell range (including logical values and text).
COUNTBLANK
The number of blank cells in a list, table or cell range.
COUNTIF
The number of non blank cells that satisfies one condition.
COUNTIFS
The number of non blank cells that satisfies multiple conditions.
COVAR
(COVARIANCE.P) The average of the products of deviations for each data point pair.
COVARIANCE.P
(2010) The covariance based on an entire population.
COVARIANCE.S
(2010) The covariance based on a sample.
CRITBINOM
(BINOM.INV) The probability of getting greater than a particular value in a binomial distribution.
DEVSQ
The sum of the squared deviations from the mean.
EXPON.DIST
(2010) The exponential distribution.
EXPONDIST
(EXPON.DIST) The exponential distribution.
F.DIST
(2010) The probability of getting less than or equal to a particular value in an f distribution (left tailed).
F.DIST.RT
(2010) The probability of getting less than or equal to a particular value in an f distribution (right tailed).
F.INV
(2010) The probability of getting greater than a particular value in an f distribution (left tailed).
F.INV.RT
(2010) The probability of getting greater than a particular value in an f distribution (right tailed).
F.TEST
(2010) The value from the f test.
FDIST
(F.DIST) The probability of getting less than or equal to a particular value in an f distribution (no cumulative) (left tailed).
FINV
(F.INV) The probability of getting greater than a particular value in an f distribution (left tailed).
FISHER
The fisher transformation.
FISHERINV
The inverse of the fisher transformation.
FORECAST
(FORECAST.LINEAR) The future y-value along a linear trend using existing values.
FORECAST.ETS
(2016) The future value based on historical values.
FORECAST.LINEAR
(2016) The future y-value along a linear trend using existing values.
FREQUENCY
The number of times a particular value occurs in a list, table or cell range.
FTEST
(F.TEST) The value from the f test.
GAMMA
(2013) The gamma function value.
GAMMA.DIST
(2010) The probability of getting less than or equal to a particular value in a gamma distribution.
GAMMA.INV
(2010) The probability of getting greater than a particular value in a gamma distribution.
GAMMADIST
(GAMMA.DIST) The probability of getting less than or equal to a particular value in a gamma distribution.
GAMMAINV
(GAMMA.INV) The probability of getting greater than a particular value in a gamma distribution.
GAMMALN
(GAMMALN.PRECISE) The natural logarithm of the gamma function.
GAMMALN.PRECISE
(2010) The natural logarithm of the gamma function.
GAUSS
(2013) The 0.5 less than the standard normal cumulative distribution.
GEOMEAN
The geometric mean of an array of numbers.
GROWTH
The predicted exponential growth using existing data.
HARMEAN
The harmonic mean of a data set.
HYPGEOM.DIST
(2010) The probability of getting less than or equal to a particular value in a hyper geometric distribution (finite population).
HYPGEOMDIST
(HYPGEOM.DIST) The probability of getting less than or equal to a particular value in a hyper geometric distribution (finite population) (no cumulative).
INTERCEPT
The intersection with the y-axis using a linear regression plotted through known values.
KURT
The kurtosis for a list or array of numbers.
LARGE
The kth largest value in a list or array of numbers.
LINEST
The array of values for a straight line that best fits your data.
LOGEST
The array of values for an exponential curve that best fits your data.
LOGINV
(LOGNORM.INV) The probability of getting greater than a particular value in a lognormal distribution.
LOGNORM.DIST
(2010) The probability of getting less than or equal to a particular value in a lognormal distribution.
LOGNORM.INV
(2010) The probability of getting greater than a particular value in a lognormal distribution.
LOGNORMDIST
(LOGNORM.DIST) The probability of getting less than or equal to a particular value in a lognormal distribution (no cumulative).
MAX
The largest value in a list or array of numbers.
MAXA
The largest value in a list or array of numbers (including logical values and text).
MAXIFS
(2016) The largest value in a list or array of numbers that satisfies multiple conditions.
MEDIAN
The median value in a list or array of numbers.
MIN
The smallest value in a list or array of numbers.
MINA
The smallest value in a list or array of numbers (including logical values and text).
MINIFS
(2016) The smallest value in a list or array of numbers that satisfies multiple conditions.
MODE
(MODE.SNGL) The value that occurs most frequently in a list or array of numbers.
MODE.MULT
(2010) The array of most frequent or repetitive values.
MODE.SNGL
(2010) The value that occurs most frequently in a list or array of numbers.
NEGBINOM.DIST
(2010) The probability of getting less than or equal to a particular value in a negative binomial distribution.
NEGBINOMDIST
(NEGBINOM.DIST) The probability of getting less than or equal to a particular value in a negative binomial distribution (no cumulative).
NORM.DIST
(2010) The probability of getting less than or equal to a particular value in a normal distribution.
NORM.INV
(2010) The x variable corresponding to less than a particular probability.
NORM.S.DIST
(2010) The probability of getting less than or equal to a particular value in a standard normal distribution.
NORM.S.INV
(2010) The x variable corresponding to less than a particular probability.
NORMDIST
(NORM.DIST) The probability of getting less than or equal to a particular value in a normal distribution.
NORMINV
(NORM.INV) The x variable corresponding to less than a particular probability.
NORMSDIST
(NORM.S.DIST) The probability of getting less than or equal to a particular value in a normal distribution (no cumulative).
NORMSINV
(NORM.S.INV) The x variable corresponding to less than a particular probability.
PEARSON
The pearson product moment correlation coefficient.
PERCENTILE
(PERCENTILE.INC) The number corresponding to a particular percentage from an array of numbers (inclusive).
PERCENTILE.EXC
(2010) The number corresponding to a particular percentage from an array of numbers (exclusive).
PERCENTILE.INC
(2010) The number corresponding to a particular percentage from an array of numbers (inclusive).
PERCENTRANK
(PERCENTRANK.INC) The percentage rank of a value in an array of numbers (inclusive).
PERCENTRANK.EXC
(2010) The percentage rank of a value in an array of numbers (exclusive).
PERCENTRANK.INC
(2010) The percentage rank of a value in an array of numbers (inclusive).
PERMUT
The number of permutations for a subset of objects or events.
PERMUTATIONA
(2013) The number of permutations for a subset of objects or events (with repetition).
PHI
(2013) The value of the density function for a standard normal distribution.
POISSON
(POISSON.DIST) The probability of getting less than or equal to a particular value in a poisson distribution.
POISSON.DIST
(2010) The probability of getting less than or equal to a particular value in a poisson distribution.
PROB
The probability that values in a range are between two limits.
QUARTILE
(QUARTILE.INC) The quartile of a data set (inclusive).
QUARTILE.EXC
(2010) The quartile of a data set (exclusive).
QUARTILE.INC
(2010) The quartile of a data set (inclusive).
RANK
(RANK.EQ) The rank of a value in a list, table or cell range (in descending order) (equal ranking).
RANK.AVG
(2010) The rank of a value in a list, table or cell range (in descending order) (average ranking).
RANK.EQ
(2010) The rank of a value in a list, table or cell range (in descending order) (equal ranking).
RSQ
The square of pearson product moment correlation coefficient through data points in known y's and known x's.
SKEW
The number representing the skewness of a distribution based on a sample.
SKEW.P
(2013) The number representing the skewness of a distribution based on an entire population.
SLOPE
The slope of a linear regression line through the given data points.
SMALL
The kth smallest value in a list or array of numbers.
STANDARDIZE
The normalized value from a distributed characterised by a mean and a standard deviation.
STDEV
(STDEV.S) The standard deviation based on a sample.
STDEV.P
(2010) The standard deviation based on an entire population.
STDEV.S
(2010) The standard deviation based on a sample.
STDEVA
The standard deviation based on a sample (including logical values and text).
STDEVP
(STDEV.P) The standard deviation based on an entire population.
STDEVPA
The standard deviation based on an entire population (including logical values and text).
STEYX
The standard error of a regression.
T.DIST
(2010) The probability of getting less than or equal to a particular value in a t distribution (left tailed).
T.DIST.2T
(2010) The percentage points probability for the t distribution.
T.DIST.RT
(2010) The probability of getting greater than a particular value in a t distribution (right tailed).
T.INV
(2010) The probability of getting greater than a particular value in a t distribution (left tailed)
T.INV.2T
(2010) The t value of the t distribution as a function of the probability and the degrees of freedom.
T.TEST
(2010) The probability associated with a t test.
TDIST
(T.DIST.2T) The percentage points probability for the t distribution.
TINV
(T.INV.2T) The t-value of the distribution as a function of the probability and the degrees of freedom.
TREND
The y-values along a linear trend given a set of x-values.
TRIMMEAN
The mean of the interior of a data set.
TTEST
(T.TEST) The probability associated with a t test.
VAR
(VAR.S) The variance based on a sample.
VAR.P
(2010) The variance based on an entire population.
VAR.S
(2010) The variance based on a sample.
VARA
The variance based on a sample (including logical values and text).
VARP
(VAR.P) The variance based on an entire population.
VARPA
The variance based on an entire population (including logical values and text).
WEIBULL
(WEIBULL.DIST) The probability of getting less than or equal to a particular value in a weibull distribution.
WEIBULL.DIST
(2010) The probability of getting less than or equal to a particular value in a weibull distribution.
Z.TEST
(2010) The two-tailed p-value of a z-test.
ZTEST
(Z.TEST) The two-tailed p-value of a z-test.

© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited Top