UntitledColumn 1TitleTextFunctionDescriptionAVEDEVReturns the average of the absolute deviations of data points from their meanAVERAGEReturns the average of its argumentsAVERAGEAReturns the average of its arguments, including numbers, text, and logical valuesAVERAGEIFReturns the average (arithmetic mean) of all the cells in a range that meet a given criteriaAVERAGEIFS (2019)Returns the average (arithmetic mean) of all cells that meet multiple criteriaBETA.DIST (2010)Returns the beta cumulative distribution functionBETA.INV (2010)Returns the inverse of the cumulative distribution function for a specified beta distributionBINOM.DIST (2010)Returns the individual term binomial distribution probabilityBINOM.DIST.RANGE (2013)Returns the probability of a trial result using a binomial distributionBINOM.INV (2010)Returns the smallest value for which the cumulative binomial distribution is less than or equal to a criterion valueCHISQ.DIST (2010)Returns the cumulative beta probability density functionCHISQ.DIST.RT (2010)Returns the one-tailed probability of the chi-squared distributionCHISQ.INV (2010)Returns the cumulative beta probability density functionCHISQ.INV.RT (2010)Returns the inverse of the one-tailed probability of the chi-squared distributionCHISQ.TEST (2010)Returns the test for independenceCONFIDENCE.NORM (2010)Returns the confidence interval for a population meanCONFIDENCE.T (2010)Returns the confidence interval for a population mean, using a Student's t distributionCORRELReturns the correlation coefficient between two data setsCOUNTCounts how many numbers are in the list of argumentsCOUNTACounts how many values are in the list of argumentsCOUNTBLANKCounts the number of blank cells within a rangeCOUNTIFCounts the number of cells within a range that meet the given criteriaCOUNTIFS (2019)Counts the number of cells within a range that meet multiple criteriaCOVARIANCE.P (2010)Returns covariance, the average of the products of paired deviationsCOVARIANCE.S (2010)Returns the sample covariance, the average of the products deviations for each data point pair in two data setsDEVSQReturns the sum of squares of deviationsEXPON.DIST (2010)Returns the exponential distributionF.DIST (2010)Returns the F probability distributionF.DIST.RT (2010)Returns the F probability distributionF.INV (2010)Returns the inverse of the F probability distributionF.INV.RT (2010)Returns the inverse of the F probability distributionF.TEST (2010)Returns the result of an F-testFISHERReturns the Fisher transformationFISHERINVReturns the inverse of the Fisher transformationFORECASTReturns a value along a linear trend Note: In Excel 2016, this function is replaced with FORECAST.LINEAR as part of the new Forecasting functions, but it's still available for compatibility with earlier versions.FORECAST.ETS (2016)Returns a future value based on existing (historical) values by using the AAA version of the Exponential Smoothing (ETS) algorithmFORECAST.ETS.CONFINT (2016)Returns a confidence interval for the forecast value at the specified target dateFORECAST.ETS.SEASONALITY (2016)Returns the length of the repetitive pattern Excel detects for the specified time seriesFORECAST.ETS.STAT (2016)Returns a statistical value as a result of time series forecastingFORECAST.LINEAR (2016)Returns a future value based on existing valuesFREQUENCYReturns a frequency distribution as a vertical arrayGAMMA (2013)Returns the Gamma function valueGAMMA.DIST (2010)Returns the gamma distributionGAMMA.INV (2010)Returns the inverse of the gamma cumulative distributionGAMMALNReturns the natural logarithm of the gamma function, Γ(x)GAMMALN.PRECISE (2010)Returns the natural logarithm of the gamma function, Γ(x)GAUSS (2013)Returns 0.5 less than the standard normal cumulative distributionGEOMEANReturns the geometric meanGROWTHReturns values along an exponential trendHARMEANReturns the harmonic meanHYPGEOM.DISTReturns the hypergeometric distributionINTERCEPTReturns the intercept of the linear regression lineKURTReturns the kurtosis of a data setLARGEReturns the k-th largest value in a data setLINESTReturns the parameters of a linear trendLOGESTReturns the parameters of an exponential trendLOGNORM.DIST (2010)Returns the cumulative lognormal distributionLOGNORM.INV (2010)Returns the inverse of the lognormal cumulative distributionMAXReturns the maximum value in a list of argumentsMAXAReturns the maximum value in a list of arguments, including numbers, text, and logical valuesMAXIFS (2019)Returns the maximum value among cells specified by a given set of conditions or criteriaMEDIANReturns the median of the given numbersMINReturns the minimum value in a list of argumentsMINAReturns the smallest value in a list of arguments, including numbers, text, and logical valuesMINIFS (2019)Returns the minimum value among cells specified by a given set of conditions or criteria.MODE.MULT (2010)Returns a vertical array of the most frequently occurring, or repetitive values in an array or range of dataMODE.SNGL (2010)Returns the most common value in a data setNEGBINOM.DIST (2010)Returns the negative binomial distributionNORM.DIST (2010)Returns the normal cumulative distributionNORM.INV (2010)Returns the inverse of the normal cumulative distributionNORM.S.DIST (2010)Returns the standard normal cumulative distributionNORM.S.INV (2010)Returns the inverse of the standard normal cumulative distributionPEARSONReturns the Pearson product moment correlation coefficientPERCENTILE.EXC (2010)Returns the k-th percentile of values in a range, where k is in the range 0..1, exclusivePERCENTILE.INC (2010)Returns the k-th percentile of values in a rangePERCENTRANK.EXC (2010)Returns the rank of a value in a data set as a percentage (0..1, exclusive) of the data setPERCENTRANK.INC (2010)Returns the percentage rank of a value in a data setPERMUTReturns the number of permutations for a given number of objectsPERMUTATIONA (2013)Returns the number of permutations for a given number of objects (with repetitions) that can be selected from the total objectsPHI (2013)Returns the value of the density function for a standard normal distributionPOISSON.DIST (2010)Returns the Poisson distributionPROBReturns the probability that values in a range are between two limitsQUARTILE.EXC (2010)Returns the quartile of the data set, based on percentile values from 0..1, exclusiveQUARTILE.INC (2010)Returns the quartile of a data setRANK.AVG (2010)Returns the rank of a number in a list of numbersRANK.EQ (2010)Returns the rank of a number in a list of numbersRSQReturns the square of the Pearson product moment correlation coefficientSKEWReturns the skewness of a distributionSKEW.P (2013)Returns the skewness of a distribution based on a population: a characterization of the degree of asymmetry of a distribution around its meanSLOPEReturns the slope of the linear regression lineSMALLReturns the k-th smallest value in a data setSTANDARDIZEReturns a normalized valueSTDEV.P (2010)Calculates standard deviation based on the entire populationSTDEV.S (2010)Estimates standard deviation based on a sampleSTDEVAEstimates standard deviation based on a sample, including numbers, text, and logical valuesSTDEVPACalculates standard deviation based on the entire population, including numbers, text, and logical valuesSTEYXReturns the standard error of the predicted y-value for each x in the regressionT.DIST (2010)Returns the Percentage Points (probability) for the Student t-distributionT.DIST.2T (2010)Returns the Percentage Points (probability) for the Student t-distributionT.DIST.RT (2010)Returns the Student's t-distributionT.INV (2010)Returns the t-value of the Student's t-distribution as a function of the probability and the degrees of freedomT.INV.2T (2010)Returns the inverse of the Student's t-distributionT.TEST (2010)Returns the probability associated with a Student's t-testTRENDReturns values along a linear trendTRIMMEANReturns the mean of the interior of a data setVAR.P (2010)Calculates variance based on the entire populationVAR.S (2010)Estimates variance based on a sampleVARAEstimates variance based on a sample, including numbers, text, and logical valuesVARPACalculates variance based on the entire population, including numbers, text, and logical valuesWEIBULL.DIST (2010)Returns the Weibull distributionZ.TEST (2010)Returns the one-tailed probability-value of a z-test