Statistical Functions

AVEDEVThe average deviation of the numbers in a list, table or cell range.
AVERAGEThe arithmetic mean of the values in a list, range or array.
AVERAGEAThe arithmetic mean of the values in a list, range or array (including logical values and text).
AVERAGEIF(AVERAGEIFS) The 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.DISTThe probability of getting a specific value between 0 and 1 for different distribution shapes.
BETA.INVThe inverse of the cumulative probability function for a beta distribution.
BETADIST(BETA.DIST) The cumulative probability function for a beta distribution (only cumulative).
BETAINV(BETA.INV) The inverse of the probability distribution function for a beta distribution.
BINOM.DISTThe probability of getting a specific number of successes using a binomial distribution.
BINOM.DIST.RANGE(2013) The probability of a trial result using a binomial distribution.
BINOM.INVThe number of trials needed for a specific amount of success using a binomial distribution.
BINOMDIST(BINOM.DIST) The probability of getting a specific number of successes using a binomial distribution.
CHIDIST(CHISQ.DIST.RT) The probability distribution function for a chi-squared distribution (right tailed) (no cumulative).
CHIINV(CHISQ.INV.RT) The inverse of the probability distribution function for a chi-squared distribution (right tailed).
CHISQ.DISTThe probability distribution function OR the cumulative probability function for a chi-squared distribution (left tailed).
CHISQ.DIST.RTThe probability distribution function for a chi-squared distribution (right tailed) (no cumulative).
CHISQ.INVThe inverse of the probability distribution function for a chi-squared distribution (left tailed).
CHISQ.INV.RTThe inverse of the probability distribution function for a chi-squared distribution (right tailed) (no cumulative).
CHISQ.TESTThe probability value from a chi-squared distribution.
CHITEST(CHISQ.TEST) The probability value from a chi-squared distribution.
CONFIDENCE(CONFIDENCE.NORM) The confidence interval for a population mean.
CONFIDENCE.NORMThe confidence interval for a population mean.
CONFIDENCE.TThe confidence interval for a population mean using a t distribution.
CORRELThe correlation coefficient between two data sets.
COUNTThe number of values in a list, range or array.
COUNTAThe number of values in a list, range or array (including logical values and text).
COUNTBLANKThe number of blank cells in a list, table or range.
COUNTIF(COUNTIFS) The number of numerical values in a range that satisfies one condition.
COUNTIFSThe number of numerical values in a range that satisfies multiple conditions.
COVAR(COVARIANCE.P) The average of the products of deviations for each data point pair.
COVARIANCE.PThe covariance based on an entire population.
COVARIANCE.SThe covariance based on a sample.
CRITBINOM(BINOM.INV) The inverse of the probability distribution function for a binomial distribution (renamed).
DEVSQThe sum of the squared deviations from the mean.
EXPON.DISTThe probability distribution function OR the cumulative probability function for an exponential distribution.
EXPONDIST(EXPON.DIST) The probability distribution function OR the cumulative probability function for an exponential distribution.
F.DISTThe probability distribution function OR the cumulative probability function for an f distribution (left tailed).
F.DIST.RTThe probability distribution function for an f distribution (right tailed) (no cumulative).
F.INVThe inverse of the probability distribution function for an f distribution (left tailed).
F.INV.RTThe inverse of the probability distribution function for an f distribution (right tailed).
F.TESTThe probability value from an f distribution.
FDIST(F.DIST) The probability distribution function for an f distribution (left tailed) (no cumulative).
FINV(F.INV) The inverse of the probability distribution function for 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 probability value from an f distribution.
GAMMA(2013) The gamma function value.
GAMMA.DISTThe probability distribution function OR the cumulative probability function for a gamma distribution.
GAMMA.INVThe inverse of the cumulative probability function for a gamma distribution.
GAMMADIST(GAMMA.DIST) The probability distribution function OR the cumulative probability function for a gamma distribution.
GAMMAINV(GAMMA.INV) The inverse of the probability distribution for a gamma distribution.
GAMMALN(GAMMALN.PRECISE) The natural logarithm of the gamma function.
GAMMALN.PRECISEThe 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.DISTThe probability distribution functon OR the cumulative probability function for a hypergeometric distribution.
HYPGEOMDIST(HYPGEOM.DIST) The cumulative probability function for a hypergeometric distribution (only 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 inverse of the probability distribution function for a lognormal distribution.
LOGNORM.DISTThe probability distribution function OR the cumulative probability function for a lognormal distribution.
LOGNORM.INVThe inverse of the probability distribution function for a lognormal distribution.
LOGNORMDIST(LOGNORM.DIST) The cumulative probability function for a lognormal distribution (only cumulative).
MAXThe largest value in a list, range or array.
MAXAThe largest value in a list, range or array (including logical values and text).
MAXIFS(2019) The largest value in a list, range or array that satisfies multiple conditions.
MEDIANThe median value in a list or array of numbers.
MINThe smallest value in a list, range or array.
MINAThe smallest value in a list, range or array (including logical values and text).
MINIFS(2019) The smallest value in a list, range or array that satisfies multiple conditions.
MODE(MODE.SNGL) The value that occurs most frequently in a list or array of numbers.
MODE.MULTThe array of most frequent or repetitive values.
MODE.SNGLThe value that occurs most frequently in a list or array of numbers.
NEGBINOM.DISTThe probability distribution function OR the cumulative probability function for a negative binomial distribution.
NEGBINOMDIST(NEGBINOM.DIST) The probability distribution function for a negative binomial distribution (no cumulative).
NORM.DISTThe probability distribution function OR the cumulative probability function for a normal distribution.
NORM.INVThe inverse of the probability distribution function for a normal distribution.
NORM.S.DISTThe probability distribution function OR the cumulative probability function for a standard normal distribution.
NORM.S.INVThe inverse of the probability distribution function for a standard normal distribution.
NORMDIST(NORM.DIST) The probability distribution function OR the cumulative probability function for a normal distribution.
NORMINV(NORM.INV) The inverse of the probability distribution function for a normal distribution.
NORMSDIST(NORM.S.DIST) The probability distribution function for a standard normal distribution (no cumulative).
NORMSINV(NORM.S.INV) The inverse of the probability distribution function for a standard normal distribution.
PEARSONThe pearson product moment correlation coefficient.
PERCENTILE(PERCENTILE.INC) The number corresponding to a particular percentage from an array of numbers (inclusive).
PERCENTILE.EXCThe number corresponding to a particular percentage from an array of numbers (exclusive).
PERCENTILE.INCThe 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.EXCThe percentage rank of a value in an array of numbers (exclusive).
PERCENTRANK.INCThe 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 distribution function OR the cumulative probability function for a poisson distribution.
POISSON.DISTThe probability distribution function OR the cumulative probability function for 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.EXCThe quartile of a data set (exclusive).
QUARTILE.INCThe 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.AVGThe rank of a value in a list, table or cell range (in descending order) (average ranking).
RANK.EQThe 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.PThe standard deviation based on an entire population.
STDEV.SThe 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.DISTThe probability distribution function for a t distribution (left tailed).
T.DIST.2TThe probability distribution function for a two tailed distribution (no cumulative).
T.DIST.RTThe probability distribution function for a t distribution (right tailed) (no cumulative).
T.INVThe inverse of the probability distribution function for a t distribution (left tailed)
T.INV.2TThe inverse of the probability distribution function for a two tailed distribution.
T.TESTThe probability value from a t distribution.
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 value from a t distribution.
VAR(VAR.S) The variance based on a sample.
VAR.PThe variance based on an entire population.
VAR.SThe 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 distribution function OR the cumulative probability function for a weibull distribution.
WEIBULL.DISTThe probability distribution function OR the cumulative probability function for a weibull distribution.
Z.TESTThe probability that the supplied hypothesized sample mean is greater than the mean of the supplied data values.
ZTEST(Z.TEST) The probability that the supplied hypothesized sample mean is greater than the mean of the supplied data values.
AVEDEV
The average deviation of the numbers in a list, table or cell range.
AVERAGE
The arithmetic mean of the values in a list, range or array.
AVERAGEA
The arithmetic mean of the values in a list, range or array (including logical values and text).
AVERAGEIF
(AVERAGEIFS) 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
The probability of getting a specific value between 0 and 1 for different distribution shapes.
BETA.INV
The inverse of the cumulative probability function for a beta distribution.
BETADIST
(BETA.DIST) The cumulative probability function for a beta distribution (only cumulative).
BETAINV
(BETA.INV) The inverse of the probability distribution function for a beta distribution.
BINOM.DIST
The probability of getting a specific number of successes using a binomial distribution.
BINOM.DIST.RANGE
(2013) The probability of a trial result using a binomial distribution.
BINOM.INV
The number of trials needed for a specific amount of success using a binomial distribution.
BINOMDIST
(BINOM.DIST) The probability of getting a specific number of successes using a binomial distribution.
CHIDIST
(CHISQ.DIST.RT) The probability distribution function for a chi-squared distribution (right tailed) (no cumulative).
CHIINV
(CHISQ.INV.RT) The inverse of the probability distribution function for a chi-squared distribution (right tailed).
CHISQ.DIST
The probability distribution function OR the cumulative probability function for a chi-squared distribution (left tailed).
CHISQ.DIST.RT
The probability distribution function for a chi-squared distribution (right tailed) (no cumulative).
CHISQ.INV
The inverse of the probability distribution function for a chi-squared distribution (left tailed).
CHISQ.INV.RT
The inverse of the probability distribution function for a chi-squared distribution (right tailed) (no cumulative).
CHISQ.TEST
The probability value from a chi-squared distribution.
CHITEST
(CHISQ.TEST) The probability value from a chi-squared distribution.
CONFIDENCE
(CONFIDENCE.NORM) The confidence interval for a population mean.
CONFIDENCE.NORM
The confidence interval for a population mean.
CONFIDENCE.T
The confidence interval for a population mean using a t distribution.
CORREL
The correlation coefficient between two data sets.
COUNT
The number of values in a list, range or array.
COUNTA
The number of values in a list, range or array (including logical values and text).
COUNTBLANK
The number of blank cells in a list, table or range.
COUNTIF
(COUNTIFS) The number of numerical values in a range that satisfies one condition.
COUNTIFS
The number of numerical values in a range that satisfies multiple conditions.
COVAR
(COVARIANCE.P) The average of the products of deviations for each data point pair.
COVARIANCE.P
The covariance based on an entire population.
COVARIANCE.S
The covariance based on a sample.
CRITBINOM
(BINOM.INV) The inverse of the probability distribution function for a binomial distribution (renamed).
DEVSQ
The sum of the squared deviations from the mean.
EXPON.DIST
The probability distribution function OR the cumulative probability function for an exponential distribution.
EXPONDIST
(EXPON.DIST) The probability distribution function OR the cumulative probability function for an exponential distribution.
F.DIST
The probability distribution function OR the cumulative probability function for an f distribution (left tailed).
F.DIST.RT
The probability distribution function for an f distribution (right tailed) (no cumulative).
F.INV
The inverse of the probability distribution function for an f distribution (left tailed).
F.INV.RT
The inverse of the probability distribution function for an f distribution (right tailed).
F.TEST
The probability value from an f distribution.
FDIST
(F.DIST) The probability distribution function for an f distribution (left tailed) (no cumulative).
FINV
(F.INV) The inverse of the probability distribution function for 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 probability value from an f distribution.
GAMMA
(2013) The gamma function value.
GAMMA.DIST
The probability distribution function OR the cumulative probability function for a gamma distribution.
GAMMA.INV
The inverse of the cumulative probability function for a gamma distribution.
GAMMADIST
(GAMMA.DIST) The probability distribution function OR the cumulative probability function for a gamma distribution.
GAMMAINV
(GAMMA.INV) The inverse of the probability distribution for a gamma distribution.
GAMMALN
(GAMMALN.PRECISE) The natural logarithm of the gamma function.
GAMMALN.PRECISE
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
The probability distribution functon OR the cumulative probability function for a hypergeometric distribution.
HYPGEOMDIST
(HYPGEOM.DIST) The cumulative probability function for a hypergeometric distribution (only 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 inverse of the probability distribution function for a lognormal distribution.
LOGNORM.DIST
The probability distribution function OR the cumulative probability function for a lognormal distribution.
LOGNORM.INV
The inverse of the probability distribution function for a lognormal distribution.
LOGNORMDIST
(LOGNORM.DIST) The cumulative probability function for a lognormal distribution (only cumulative).
MAX
The largest value in a list, range or array.
MAXA
The largest value in a list, range or array (including logical values and text).
MAXIFS
(2019) The largest value in a list, range or array that satisfies multiple conditions.
MEDIAN
The median value in a list or array of numbers.
MIN
The smallest value in a list, range or array.
MINA
The smallest value in a list, range or array (including logical values and text).
MINIFS
(2019) The smallest value in a list, range or array that satisfies multiple conditions.
MODE
(MODE.SNGL) The value that occurs most frequently in a list or array of numbers.
MODE.MULT
The array of most frequent or repetitive values.
MODE.SNGL
The value that occurs most frequently in a list or array of numbers.
NEGBINOM.DIST
The probability distribution function OR the cumulative probability function for a negative binomial distribution.
NEGBINOMDIST
(NEGBINOM.DIST) The probability distribution function for a negative binomial distribution (no cumulative).
NORM.DIST
The probability distribution function OR the cumulative probability function for a normal distribution.
NORM.INV
The inverse of the probability distribution function for a normal distribution.
NORM.S.DIST
The probability distribution function OR the cumulative probability function for a standard normal distribution.
NORM.S.INV
The inverse of the probability distribution function for a standard normal distribution.
NORMDIST
(NORM.DIST) The probability distribution function OR the cumulative probability function for a normal distribution.
NORMINV
(NORM.INV) The inverse of the probability distribution function for a normal distribution.
NORMSDIST
(NORM.S.DIST) The probability distribution function for a standard normal distribution (no cumulative).
NORMSINV
(NORM.S.INV) The inverse of the probability distribution function for a standard normal distribution.
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
The number corresponding to a particular percentage from an array of numbers (exclusive).
PERCENTILE.INC
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
The percentage rank of a value in an array of numbers (exclusive).
PERCENTRANK.INC
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 distribution function OR the cumulative probability function for a poisson distribution.
POISSON.DIST
The probability distribution function OR the cumulative probability function for 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
The quartile of a data set (exclusive).
QUARTILE.INC
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
The rank of a value in a list, table or cell range (in descending order) (average ranking).
RANK.EQ
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
The standard deviation based on an entire population.
STDEV.S
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
The probability distribution function for a t distribution (left tailed).
T.DIST.2T
The probability distribution function for a two tailed distribution (no cumulative).
T.DIST.RT
The probability distribution function for a t distribution (right tailed) (no cumulative).
T.INV
The inverse of the probability distribution function for a t distribution (left tailed)
T.INV.2T
The inverse of the probability distribution function for a two tailed distribution.
T.TEST
The probability value from a t distribution.
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 value from a t distribution.
VAR
(VAR.S) The variance based on a sample.
VAR.P
The variance based on an entire population.
VAR.S
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 distribution function OR the cumulative probability function for a weibull distribution.
WEIBULL.DIST
The probability distribution function OR the cumulative probability function for a weibull distribution.
Z.TEST
The probability that the supplied hypothesized sample mean is greater than the mean of the supplied data values.
ZTEST
(Z.TEST) The probability that the supplied hypothesized sample mean is greater than the mean of the supplied data values.

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