|
MAX | Returns the largest value from a list of supplied numbers |
MAXA | Returns the largest value from a list of supplied values, counting text and the logical value FALSE as the value 0 and counting the logical value TRUE as the value 1 |
MAXIFS | Returns the largest value from a subset of values in a list that are specified according to one or more criteria. (New in Excel 2019) |
MIN | Returns the smallest value from a list of supplied numbers |
MINA | Returns the smallest value from a list of supplied values, counting text and the logical value FALSE as the value 0 and counting the logical value TRUE as the value 1 |
MINIFS | Returns the smallest value from a subset of values in a list that are specified according to one or more criteria. (New in Excel 2019) |
LARGE | Returns the Kth LARGEST value from a list of supplied numbers, for a given value K |
SMALL | Returns the Kth SMALLEST value from a list of supplied numbers, for a given value K |
|
|
AVERAGE | Returns the Average of a list of supplied numbers |
AVERAGEA | Returns the Average of a list of supplied numbers, counting text and the logical value FALSE as the value 0 and counting the logical value TRUE as the value 1 |
AVERAGEIF | Calculates the Average of the cells in a supplied range, that satisfy a given criteria (New in Excel 2007) |
AVERAGEIFS | Calculates the Average of the cells in a supplied range, that satisfy multiple criteria (New in Excel 2007) |
MEDIAN | Returns the Median (the middle value) of a list of supplied numbers |
MODE | Returns the Mode (the most frequently occurring value) of a list of supplied numbers (Replaced by Mode.Sngl function in Excel 2010) |
MODE.SNGL | Returns the Mode (the most frequently occurring value) of a list of supplied numbers (New in Excel 2010 - replaces the Mode function) |
MODE.MULT | Returns a vertical array of the most frequently occurring values in an array or range of data (New in Excel 2010) |
GEOMEAN | Returns the geometric mean of a set of supplied numbers |
HARMEAN | Returns the harmonic mean of a set of supplied numbers |
TRIMMEAN | Returns the mean of the interior of a supplied set of values |
|
|
BETADIST | Returns the cumulative beta probability density function (Replaced by Beta.Dist function in Excel 2010) |
BETA.DIST | Returns the cumulative beta distribution function or the beta probability density function (New in Excel 2010 - replaces the Betadist function) |
BETAINV | Returns the inverse of the cumulative beta probability density function (Replaced by Beta.Inv function in Excel 2010) |
BETA.INV | Returns the inverse of the cumulative beta probability density function (New in Excel 2010 - replaces the Betainv function) |
BINOMDIST | Returns the individual term binomial distribution probability (Replaced by Binom.Dist function in Excel 2010) |
BINOM.DIST | Returns the individual term binomial distribution probability (New in Excel 2010 - replaces the Binomdist function) |
BINOM.DIST.RANGE | Returns the probability of a trial result using a binomial distribution (New in Excel 2013) |
NEGBINOMDIST | Returns the negative binomial distribution (Replaced by Negbinom.Dist function in Excel 2010) |
NEGBINOM.DIST | Returns the negative binomial distribution (New in Excel 2010 - replaces the Negbinomdist function) |
CRITBINOM | Returns the smallest value for which the cumulative binomial distribution is greater than or equal to a criterion value (Replaced by Binom.Inv function in Excel 2010) |
BINOM.INV | Returns the smallest value for which the cumulative binomial distribution is greater than or equal to a criterion value (New in Excel 2010 - replaces the Critbinom function) |
CHIDIST | Returns the right-tailed probability of the chi-squared distribution (Replaced by Chisq.Dist.Rt function in Excel 2010) |
CHISQ.DIST.RT | Returns the right-tailed probability of the chi-squared distribution (New in Excel 2010 - replaces the Chidist function) |
CHISQ.DIST | Returns the chi-squared distribution (probability density or cumulative distribution function) (New in Excel 2010) |
CHIINV | Returns the inverse of the right-tailed probability of the chi-squared distribution (Replaced by Chisq.Inv.Rt function in Excel 2010) |
CHISQ.INV.RT | Returns the inverse of the right-tailed probability of the chi-squared distribution (New in Excel 2010 - replaces the Chiinv function) |
CHISQ.INV | Returns the inverse of the left-tailed probability of the chi-squared distribution (New in Excel 2010) |
CHITEST | Returns the chi-squared statistical test for independence (Replaced by Chisq.Test function in Excel 2010) |
CHISQ.TEST | Returns the chi-squared statistical test for independence (New in Excel 2010 - replaces the Chitest function) |
CORREL | Returns the correlation coefficient between two sets of values |
EXPONDIST | Returns the exponential distribution (Replaced by Expon.Dist function in Excel 2010) |
EXPON.DIST | Returns the exponential distribution (New in Excel 2010 - replaces the Expondist function) |
FDIST | Returns the right-tailed F probability distribution for two data sets (Replaced by F.Dist.Rt function in Excel 2010) |
F.DIST.RT | Returns the right-tailed F probability distribution for two data sets (New in Excel 2010 - replaces the Fdist function) |
F.DIST | Returns the F probability distribution (probability density or cumulative distribution function) (New in Excel 2010) |
FINV | Returns the inverse of the right-tailed F probability distribution for two data sets (Replaced by F.Inv.Rt function in Excel 2010) |
F.INV.RT | Returns the inverse of the right-tailed F probability distribution for two data sets (New in Excel 2010 - replaces the Finv function) |
F.INV | Returns the inverse of the Cumulative F distribution (New in Excel 2010) |
FISHER | Returns the Fisher transformation |
FISHERINV | Returns the inverse of the Fisher transformation |
FTEST | Returns the result of an F-Test for 2 supplied data sets (Replaced by F.Test function in Excel 2010) |
F.TEST | Returns the result of an F-Test for 2 supplied data sets (New in Excel 2010 - replaces the Ftest function) |
GAMMADIST | Returns the gamma distribution (Replaced by Gamma.Dist function in Excel 2010) |
GAMMA.DIST | Returns the gamma distribution (New in Excel 2010 - replaces the Gammadist function) |
GAMMAINV | Returns the inverse gamma cumulative distribution (Replaced by Gamma.Inv function in Excel 2010) |
GAMMA.INV | Returns the inverse gamma cumulative distribution (New in Excel 2010 - replaces the Gammainv function) |
GAMMA | Return the gamma function value for a supplied number (New in Excel 2013) |
GAMMALN | Calculates the natural logarithm of the gamma function for a supplied value |
GAMMALN.PRECISE | Returns the natural logarithm of the gamma function for a supplied value (New in Excel 2010) |
GAUSS | Calculates the probability that a member of a standard normal population will fall between the mean and z standard deviations from the mean (New in Excel 2013) |
HYPGEOMDIST | Returns the hypergeometric distribution (Replaced by Hypgeom.Dist function in Excel 2010) |
HYPGEOM.DIST | Returns the hypergeometric distribution (New in Excel 2010 - replaces the Hypgeomdist function) |
KURT | Returns the kurtosis of a data set |
LOGNORMDIST | Returns the cumulative log-normal distribution (Replaced by Lognorm.Dist function in Excel 2010) |
LOGNORM.DIST | Returns the log-normal probability density function or the cumulative log- normal distribution (New in Excel 2010 - replaces the Lognormdist function) |
LOGINV | Returns the inverse of the lognormal distribution (Replaced by Lognorm.Inv function in Excel 2010) |
LOGNORM.INV | Returns the inverse of the lognormal distribution (New in Excel 2010 - replaces the Loginv function) |
NORMDIST | Returns the normal cumulative distribution (Replaced by Norm.Dist function in Excel 2010) |
NORM.DIST | Returns the normal cumulative distribution (New in Excel 2010 - replaces the Normdist function) |
NORMINV | Returns the inverse of the normal cumulative distribution (Replaced by Norm.Inv function in Excel 2010) |
NORM.INV | Returns the inverse of the normal cumulative distribution (New in Excel 2010 - replaces the Norminv function) |
NORMSDIST | Returns the standard normal cumulative distribution (Replaced by Norm.S.Dist function in Excel 2010) |
NORM.S.DIST | Returns the standard normal cumulative distribution (New in Excel 2010 - replaces the Normsdist function) |
NORMSINV | Returns the inverse of the standard normal cumulative distribution (Replaced by Norm.S.Inv function in Excel 2010) |
NORM.S.INV | Returns the inverse of the standard normal cumulative distribution (New in Excel 2010 - replaces the Normsinv function) |
PEARSON | Returns the Pearson product moment correlation coefficient |
RSQ | Returns the square of the Pearson product moment correlation coefficient |
PHI | Returns the value of the density function for a standard normal distribution, for a supplied number (New in Excel 2013) |
POISSON | Returns the Poisson distribution (Replaced by Poisson.Dist function in Excel 2010) |
POISSON.DIST | Returns the Poisson distribution (New in Excel 2010 - replaces the Poisson function) |
PROB | Returns the probablity that values in a supplied range are within given limits |
SKEW | Returns the skewness of a distribution |
SKEW.P | Returns the skewness of a distribution based on a population (New in Excel 2013) |
STANDARDIZE | Returns a normalized value |
TDIST | Returns the Student's T-distribution (Replaced by T.Dist.2t & T.Dist.Rt functions in Excel 2010) |
T.DIST.2T | Returns the two-tailed Student's T-distribution (New in Excel 2010 - replaces the Tdist function) |
T.DIST.RT | Returns the right-tailed Student's T-distribution (New in Excel 2010 - replaces the Tdist function) |
T.DIST | Returns the Student's T-distribution (probability density or cumulative distribution function) (New in Excel 2010) |
TINV | Returns the two-tailed inverse of the Student's T-distribution (Replaced by T.Inv.2t function in Excel 2010) |
T.INV.2T | Returns the two-tailed inverse of the Student's T-distribution (New in Excel 2010 - replaces the Tinv function) |
T.INV | Returns the left-tailed inverse of the Student's T-distribution (New in Excel 2010) |
TTEST | Returns the probability associated with a Student's T-Test (Replaced by T.Test function in Excel 2010) |
T.TEST | Returns the probability associated with a Student's T-Test (New in Excel 2010 - replaces the Ttest function) |
WEIBULL | Returns the Weibull distribution (Replaced by Weibull.Dist function in Excel 2010) |
WEIBULL.DIST | Returns the Weibull distribution (New in Excel 2010 - replaces the Weibull function) |
ZTEST | Returns the one-tailed probability value of a z-test (Replaced by Z.Test function in Excel 2010) |
Z.TEST | Returns the one-tailed probability value of a z-test (New in Excel 2010 - replaces the Ztest function) |