### 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). 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 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.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 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. COUNTIF(COUNTIFS) The 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.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 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.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 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.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 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.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 two-tailed p-value of a z-test. ZTEST(Z.TEST) The two-tailed p-value of a z-test.