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)
|