# Statistical Functions

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

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

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