# New Functions in 2010

Excel 2010 introducted 61 new worksheet functions.

 AGGREGATEReturns an aggregate in a list or database. Replaces SUBTOTAL BETA.DISTReturns the cumulative beta probability density function. Replaces BETADIST BETA.INVReturns the inverse of the cumulative beta probability density function. Replaces BETAINV BINOM.DISTReturns the individual term binomial distribution probability. Replaces BINOMDIST BINOM.INVReturns the smallest number which is the cumulative binomial distribution that is greater than a criterion value. Replaces CRITBINOM CEILING.PRECISERounds a number the nearest integer or to the nearest multiple of significance. Regardless of the sign of the number, the number is rounded up. CHISQ.DISTReturns the cumulative beta probability density function. CHISQ.DIST.RTReturns the one tailed probability of the chi-squared distribution. Replaces CHIDIST CHISQ.INVReturns the random variable where the probability of getting 'less than' it is P. CHISQ.INV.RTReturns the inverse of the one tailed probability of the chi-squared distribution. Replaces CHIINV CHISQ.TESTReturns the probability value from a chi-squared distribution. Replaces CHITEST CONFIDENCE.NORMReturns the confidence interval for a population mean. Replaces CONFIDENCE CONFIDENCE.TReturns the confidence interval for a population mean, using a Student's t distribution. COVARIANCE.PReturns the covariance of two lists of numbers. Replaces COVAR COVARIANCE.SReturns the sample covariance, the average of the products deviations for each data point pair in two data sets. ERF.PRECISEReturns the error function. ERFC.PRECISEReturns the complementary ERF function integrated between x and infinity. EXPON.DISTReturns the exponential distribution. Replaces EXPONDIST F.DISTReturns the F probability distribution. F.DIST.RTReturns the F probability distribution. Replaces FDIST F.INVReturns the inverse of the F probability distribution. F.INV.RTReturns the inverse of the F probability distribution. Replaces FINV F.TESTReturns the probability value from an F distribution. Replaces FTEST FLOOR.PRECISERounds a number the nearest integer or to the nearest multiple of significance. Regardless of the sign of the number, the number is rounded up. GAMMA.DISTReturns the gamma distribution. Replaces GAMMADIST GAMMA.INVReturns the inverse of the gamma distribution. Replaces GAMMAINV GAMMALN.PRECISEReturns the natural logarithm of the gamma function, G(x). HYPGEOM.DISTReturns the hyper geometric distribution for a finite population. Replaces HYPGEOMDIST ISO.CEILINGRounds a number up to the nearest integer or to the nearest multiple of significance. LOGNORM.DISTReturns the cumulative lognormal distribution of x, where ln(x) is normally distributed with parameters mean and standard_dev. Replaces LOGNORMDIST LOGNORM.INVReturns the inverse of the lognormal cumulative distribution function of x, where ln(x) is normally distributed with parameters mean and standard_dev. Replaces LOGINV MODE.MULTReturns a vertical array of the most frequently occurring, or repetitive values in an array or range of data. MODE.SNGLReturns the number that occurs most frequently in a range. Replaces MODE NEGBINOM.DISTReturns the negative binomial distribution. Replaces NEGBINOMDIST NETWORKDAYS.INTLReturns the number of whole workdays between two dates using parameters to indicate which and how many days are weekend days. Replaces NETWORKDAYS NORM.DISTReturns the normal cumulative distribution. Replaces NORMDIST NORM.INVReturns the inverse of the normal cumulative distribution. Replaces NORMINV NORM.S.DISTReturns the standard normal cumulative distribution. Replaces NORMSDIST NORM.S.INVReturns the inverse of the standard normal cumulative distribution. Replaces NORMSINV PERCENTILE.EXCReturns the Kth percentile of values in a range, where k is in the range 0..1, exclusive. PERCENTILE.INCThe Kth percentile of values in an array of numbers. Replaces PERCENTILE PERCENTRANK.EXCReturns the rank of a value in a data set as a percentage (0..1, exclusive) of the data set. PERCENTRANK.INCReturns the rank of a value in a data set as a percentage of the data set. Replaces PERCENTRANK POISSON.DISTReturns the Poisson distribution. Replaces POISSON QUARTILE.EXCReturns the quartile of the data set, based on percentile values from 0..1, exclusive. QUARTILE.INCReturns the quartile of a data set. Replaces QUARTILE RANK.AVGReturns the rank of a number in a list of numbers: its size relative to other values in the list; if more than one value has the same rank, the average rank is returned. RANK.EQReturns the rank of a number in a list of numbers. Replaces RANK STDEV.PReturns the standard deviation based on the entire population. Replaces STDEVP STDEV.SReturns the standard deviation based on a sample. Replaces STDEV T.DISTReturns the Percentage Points (probability) for the Student's t-distribution. T.DIST.2TReturns the two-tailed Student's t-distribution. Replaces TDIST T.DIST.RTReturns the right-tailed Student's t-distribution. Replaces TDIST T.INVReturns the T-value of the Student's t-distribution as a function of the probability and the degrees of freedom. T.INV.2TReturns the t-value of the Student's t-distribution as a function of the probability and the degrees of freedom. Replaces TINV T.TESTReturns the probability value from a T distribution. Replaces TTEST VAR.PReturns the variance based on the entire population. Replaces VARP VAR.SReturns the variance based on a sample. Replaces VAR WEIBULL.DISTReturns the Weibull distribution. Replaces WEIBULL WORKDAY.INTLReturns the serial number that is a given number of days before or after a date. Replaces WORKDAY Z.TESTReturns the probability value from a Normal distribution. Replaces ZTEST