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