# Statistical Functions

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 | (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 less than or equal to a particular value in a beta distribution. |

BETA.INV | 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 | 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 | 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 | The probability of getting less than or equal to a particular value in a chi-squared distribution (left tailed). |

CHISQ.DIST.RT | The probability of getting more than a particular value in a chi-squared distribution (right tailed). |

CHISQ.INV | The probability of getting greater than a particular value in a chi-squared distribution (left tailed). |

CHISQ.INV.RT | The probability of getting more than a particular value in a chi-squared distribution (right tailed). |

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 numerical values in a list, table or cell range. |

COUNTA | The number of numerical values 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 | (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 probability of getting greater than a particular value in a binomial distribution. |

DEVSQ | The sum of the squared deviations from the mean. |

EXPON.DIST | The exponential distribution. |

EXPONDIST | (EXPON.DIST) The exponential distribution. |

F.DIST | The probability of getting less than or equal to a particular value in an f distribution (left tailed). |

F.DIST.RT | The probability of getting less than or equal to a particular value in an f distribution (right tailed). |

F.INV | The probability of getting greater than a particular value in an f distribution (left tailed). |

F.INV.RT | The probability of getting greater than a particular value in an f distribution (right tailed). |

F.TEST | The probability value from an F distribution. |

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 probability value from an F distribution. |

GAMMA | (2013) The gamma function value. |

GAMMA.DIST | The probability of getting less than or equal to a particular value in a gamma distribution. |

GAMMA.INV | 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 | 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 of getting less than or equal to a value in a hyper geometric distribution (finite population). |

HYPGEOMDIST | (HYPGEOM.DIST) The probability of getting less than or equal to a 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 | The probability of getting less than or equal to a particular value in a lognormal distribution. |

LOGNORM.INV | 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 | (2019) 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 | (2019) 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 | 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 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 | The probability of getting less than or equal to a particular value in a normal distribution. |

NORM.INV | The x variable corresponding to less than a particular probability. |

NORM.S.DIST | The probability of getting less than or equal to a particular value in a standard normal distribution. |

NORM.S.INV | 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 | 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 of getting less than or equal to a particular value in a poisson distribution. |

POISSON.DIST | 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 | 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 of getting less than or equal to a particular value in a t distribution (left tailed). |

T.DIST.2T | The percentage points probability for the t distribution. |

T.DIST.RT | The probability of getting greater than a particular value in a t distribution (right tailed). |

T.INV | The probability of getting greater than a particular value in a t distribution (left tailed) |

T.INV.2T | The t value of the t distribution as a function of the probability and the degrees of freedom. |

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 of getting less than or equal to a particular value in a weibull distribution. |

WEIBULL.DIST | The probability of getting less than or equal to a particular value in a weibull distribution. |

Z.TEST | The probability value from a Normal distribution. |

ZTEST | (Z.TEST) The probability value from a Normal distribution. |

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). |

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 less than or equal to a particular value in a beta distribution. |

BETA.INVThe 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.DISTThe 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.INVThe 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.DISTThe probability of getting less than or equal to a particular value in a chi-squared distribution (left tailed). |

CHISQ.DIST.RTThe probability of getting more than a particular value in a chi-squared distribution (right tailed). |

CHISQ.INVThe probability of getting greater than a particular value in a chi-squared distribution (left tailed). |

CHISQ.INV.RTThe probability of getting more than a particular value in a chi-squared distribution (right tailed). |

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 numerical values in a list, table or cell range. |

COUNTAThe number of numerical values in a list, table or cell range (including logical values and text). |

COUNTBLANKThe number of blank cells in a list, table or cell 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 probability of getting greater than a particular value in a binomial distribution. |

DEVSQThe sum of the squared deviations from the mean. |

EXPON.DISTThe exponential distribution. |

EXPONDIST(EXPON.DIST) The exponential distribution. |

F.DISTThe probability of getting less than or equal to a particular value in an f distribution (left tailed). |

F.DIST.RTThe probability of getting less than or equal to a particular value in an f distribution (right tailed). |

F.INVThe probability of getting greater than a particular value in an f distribution (left tailed). |

F.INV.RTThe probability of getting greater than a particular value in an f distribution (right tailed). |

F.TESTThe probability value from an F distribution. |

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 probability value from an F distribution. |

GAMMA(2013) The gamma function value. |

GAMMA.DISTThe probability of getting less than or equal to a particular value in a gamma distribution. |

GAMMA.INVThe 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.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 of getting less than or equal to a value in a hyper geometric distribution (finite population). |

HYPGEOMDIST(HYPGEOM.DIST) The probability of getting less than or equal to a 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.DISTThe probability of getting less than or equal to a particular value in a lognormal distribution. |

LOGNORM.INVThe 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(2019) 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(2019) 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.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 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.DISTThe probability of getting less than or equal to a particular value in a normal distribution. |

NORM.INVThe x variable corresponding to less than a particular probability. |

NORM.S.DISTThe probability of getting less than or equal to a particular value in a standard normal distribution. |

NORM.S.INVThe 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.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 of getting less than or equal to a particular value in a poisson distribution. |

POISSON.DISTThe 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.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 of getting less than or equal to a particular value in a t distribution (left tailed). |

T.DIST.2TThe percentage points probability for the t distribution. |

T.DIST.RTThe probability of getting greater than a particular value in a t distribution (right tailed). |

T.INVThe probability of getting greater than a particular value in a t distribution (left tailed) |

T.INV.2TThe t value of the t distribution as a function of the probability and the degrees of freedom. |

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 of getting less than or equal to a particular value in a weibull distribution. |

WEIBULL.DISTThe probability of getting less than or equal to a particular value in a weibull distribution. |

Z.TESTThe probability value from a Normal distribution. |

ZTEST(Z.TEST) The probability value from a Normal distribution. |

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