Excel Statistical Functions

Excel provides an extensive range of Statistical Functions, that perform calculations from basic mean, median & mode to the more complex statistical distribution and probability tests.

The Excel Statistical functions are all listed in the tables below, grouped into categories, to help you to easily find the function you need. Selecting a function name will take you to a full description of the function, with examples of use and advice on common errors.

Note that some of the Statistical functions were introduced in recent versions of Excel, and so are not available in earlier versions.


Excel Statistical Functions

Count & Frequency
COUNTReturns the number of numerical values in a supplied set of cells or values
COUNTAReturns the number of non-blanks in a supplied set of cells or values
COUNTBLANKReturns the number of blank cells in a supplied range
COUNTIFReturns the number of cells (of a supplied range), that satisfy a given criteria
COUNTIFSReturns the number of cells (of a supplied range), that satisfy a set of given criteria (New in Excel 2007)
FREQUENCYReturns an array showing the number of values from a supplied array, which fall into specified ranges
Permutations
PERMUTReturns the number of permutations for a given number of objects
PERMUTATIONAReturns the number of permutations for a given number of objects (with repetitions) that can be selected from the total objects (New in Excel 2013)
Confidence Intervals
CONFIDENCEReturns the confidence interval for a population mean, using a normal distribution (Replaced by Confidence.Norm function in Excel 2010)
CONFIDENCE.NORMReturns the confidence interval for a population mean, using a normal distribution (New in Excel 2010 - replaces the Confidence function)
CONFIDENCE.TReturns the confidence interval for a population mean, using a Student's t distribution (New in Excel 2010)
Percentiles, Quartiles & Rank
PERCENTILEReturns the K'th percentile of values in a supplied range, where K is in the range 0 - 1 (inclusive) (Replaced by Percentile.Inc function in Excel 2010)
PERCENTILE.INCReturns the K'th percentile of values in a supplied range, where K is in the range 0 - 1 (inclusive) (New in Excel 2010 - replaces the Percentile function)
PERCENTILE.EXCReturns the K'th percentile of values in a supplied range, where K is in the range 0 - 1 (exclusive) (New in Excel 2010)
QUARTILEReturns the specified quartile of a set of supplied numbers, based on percentile value 0 - 1 (inclusive) (Replaced by Quartile.Inc function in Excel 2010)
QUARTILE.INCReturns the specified quartile of a set of supplied numbers, based on percentile value 0 - 1 (inclusive) (New in Excel 2010 - replaces the Quartile function)
QUARTILE.EXCReturns the specified quartile of a set of supplied numbers, based on percentile value 0 - 1 (exclusive) (New in Excel 2010)
RANKReturns the statistical rank of a given value, within a supplied array of values (Replaced by Rank.Eq function in Excel 2010)
RANK.EQReturns the Mode (the most frequently occurring value) of a list of supplied numbers (if more than one value has same rank, the top rank of that set is returned) (New in Excel 2010 - replaces the Rank function)
RANK.AVGReturns the statistical rank of a given value, within a supplied array of values (if more than one value has same rank, the average rank is returned) (New in Excel 2010)
PERCENTRANKReturns the rank of a value in a data set, as a percentage (0 - 1 inclusive) (Replaced by Percentrank.Inc function in Excel 2010)
PERCENTRANK.INCReturns the rank of a value in a data set, as a percentage (0 - 1 inclusive) (New in Excel 2010 - replaces the Percentrank function)
PERCENTRANK.EXCReturns the rank of a value in a data set, as a percentage (0 - 1 exclusive) (New in Excel 2010)
Deviation & Variance
AVEDEVReturns the average of the absolute deviations of data points from their mean
DEVSQReturns the sum of the squares of the deviations of a set of data points from their sample mean
STDEVReturns the standard deviation of a supplied set of values (which represent a sample of a population) (Replaced by Stdev.S function in Excel 2010)
STDEV.SReturns the standard deviation of a supplied set of values (which represent a sample of a population) (New in Excel 2010 - replaces the Stdev function)
STDEVAReturns the standard deviation of a supplied set of values (which represent a sample of a population), counting text and the logical value FALSE as the value 0 and counting the logical value TRUE as the value 1
STDEVPReturns the standard deviation of a supplied set of values (which represent an entire population) (Replaced by Stdev.P function in Excel 2010)
STDEV.PReturns the standard deviation of a supplied set of values (which represent an entire population) (New in Excel 2010 - replaces the Stdevp function)
STDEVPAReturns the standard deviation of a supplied set of values (which represent an entire population), counting text and the logical value FALSE as the value 0 and counting the logical value TRUE as the value 1
VARReturns the variance of a supplied set of values (which represent a sample of a population) (Replaced by Var.S function in Excel 2010)
VAR.SReturns the variance of a supplied set of values (which represent a sample of a population) (New in Excel 2010 - replaces the Var function)
VARAReturns the variance of a supplied set of values (which represent a sample of a population), counting text and the logical value FALSE as the value 0 and counting the logical value TRUE as the value 1
VARPReturns the variance of a supplied set of values (which represent an entire population) (Replaced by Var.P function in Excel 2010)
VAR.PReturns the variance of a supplied set of values (which represent an entire population) (New in Excel 2010 - replaces the Varp function)
VARPAReturns the variance of a supplied set of values (which represent an entire population), counting text and the logical value FALSE as the value 0 and counting the logical value TRUE as the value 1
COVARReturns population covariance (i.e. the average of the products of deviations for each pair within two supplied data sets) (Replaced by Covariance.P function in Excel 2010)
COVARIANCE.PReturns population covariance (i.e. the average of the products of deviations for each pair within two supplied data sets) (New in Excel 2010 - replaces the Covar function)
COVARIANCE.SReturns sample covariance (i.e. the average of the products of deviations for each pair within two supplied data sets) (New in Excel 2010)
Trend Line Functions
FORECASTPredicts a future point on a linear trend line fitted to a supplied set of x- and y- values (Replaced by Forecast.Linear function in Excel 2016)
FORECAST.ETSUses an exponential smoothing algorithm to predict a future value on a timeline, based on a series of existing values (New in Excel 2016 - not available in Excel 2016 for Mac)
FORECAST.ETS.CONFINTReturns a confidence interval for a forecast value at a specified target date (New in Excel 2016 - not available in Excel 2016 for Mac)
FORECAST.ETS.SEASONALITYReturns the length of the repetitive pattern Excel detects for a specified time series (New in Excel 2016 - not available in Excel 2016 for Mac)
FORECAST.ETS.STATReturns a statistical value relating to a time series forecasting (New in Excel 2016 - not available in Excel 2016 for Mac)
FORECAST.LINEARPredicts a future point on a linear trend line fitted to a supplied set of x- and y- values (New in Excel 2016 (not Excel 2016 for Mac) - replaces the Forecast function)
INTERCEPTCalculates the best fit regression line, through a supplied series of x- and y- values and returns the value at which this line intercepts the y-axis
LINESTReturns statistical information describing the trend of the line of best fit, through a supplied series of x- and y- values
SLOPEReturns the slope of the linear regression line through a supplied series of x- and y- values
TRENDCalculates the trend line through a given set of y-values and returns additional y-values for a supplied set of new x-values
GROWTHReturns numbers in a exponential growth trend, based on a set of supplied x- and y- values
LOGESTReturns the parameters of an exponential trend for a supplied set of x- and y- values
STEYXReturns the standard error of the predicted y-value for each x in the regression line for a set of supplied x- and y- values
Finding the Largest & Smallest Values
MAXReturns the largest value from a list of supplied numbers
MAXAReturns 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
MAXIFSReturns the largest value from a subset of values in a list that are specified according to one or more criteria. (New in Excel 2019)
MINReturns the smallest value from a list of supplied numbers
MINAReturns 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
MINIFSReturns the smallest value from a subset of values in a list that are specified according to one or more criteria. (New in Excel 2019)
LARGEReturns the Kth LARGEST value from a list of supplied numbers, for a given value K
SMALLReturns the Kth SMALLEST value from a list of supplied numbers, for a given value K
Averages
AVERAGEReturns the Average of a list of supplied numbers
AVERAGEAReturns 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
AVERAGEIFCalculates the Average of the cells in a supplied range, that satisfy a given criteria (New in Excel 2007)
AVERAGEIFSCalculates the Average of the cells in a supplied range, that satisfy multiple criteria (New in Excel 2007)
MEDIANReturns the Median (the middle value) of a list of supplied numbers
MODEReturns the Mode (the most frequently occurring value) of a list of supplied numbers (Replaced by Mode.Sngl function in Excel 2010)
MODE.SNGLReturns the Mode (the most frequently occurring value) of a list of supplied numbers (New in Excel 2010 - replaces the Mode function)
MODE.MULTReturns a vertical array of the most frequently occurring values in an array or range of data (New in Excel 2010)
GEOMEANReturns the geometric mean of a set of supplied numbers
HARMEANReturns the harmonic mean of a set of supplied numbers
TRIMMEANReturns the mean of the interior of a supplied set of values
Distribution & Tests of Probability
BETADISTReturns the cumulative beta probability density function (Replaced by Beta.Dist function in Excel 2010)
BETA.DISTReturns the cumulative beta distribution function or the beta probability density function (New in Excel 2010 - replaces the Betadist function)
BETAINVReturns the inverse of the cumulative beta probability density function (Replaced by Beta.Inv function in Excel 2010)
BETA.INVReturns the inverse of the cumulative beta probability density function (New in Excel 2010 - replaces the Betainv function)
BINOMDISTReturns the individual term binomial distribution probability (Replaced by Binom.Dist function in Excel 2010)
BINOM.DISTReturns the individual term binomial distribution probability (New in Excel 2010 - replaces the Binomdist function)
BINOM.DIST.RANGEReturns the probability of a trial result using a binomial distribution (New in Excel 2013)
NEGBINOMDISTReturns the negative binomial distribution (Replaced by Negbinom.Dist function in Excel 2010)
NEGBINOM.DISTReturns the negative binomial distribution (New in Excel 2010 - replaces the Negbinomdist function)
CRITBINOMReturns 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.INVReturns 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)
CHIDISTReturns the right-tailed probability of the chi-squared distribution (Replaced by Chisq.Dist.Rt function in Excel 2010)
CHISQ.DIST.RTReturns the right-tailed probability of the chi-squared distribution (New in Excel 2010 - replaces the Chidist function)
CHISQ.DISTReturns the chi-squared distribution (probability density or cumulative distribution function) (New in Excel 2010)
CHIINVReturns the inverse of the right-tailed probability of the chi-squared distribution (Replaced by Chisq.Inv.Rt function in Excel 2010)
CHISQ.INV.RTReturns the inverse of the right-tailed probability of the chi-squared distribution (New in Excel 2010 - replaces the Chiinv function)
CHISQ.INVReturns the inverse of the left-tailed probability of the chi-squared distribution (New in Excel 2010)
CHITESTReturns the chi-squared statistical test for independence (Replaced by Chisq.Test function in Excel 2010)
CHISQ.TESTReturns the chi-squared statistical test for independence (New in Excel 2010 - replaces the Chitest function)
CORRELReturns the correlation coefficient between two sets of values
EXPONDISTReturns the exponential distribution (Replaced by Expon.Dist function in Excel 2010)
EXPON.DISTReturns the exponential distribution (New in Excel 2010 - replaces the Expondist function)
FDISTReturns the right-tailed F probability distribution for two data sets (Replaced by F.Dist.Rt function in Excel 2010)
F.DIST.RTReturns the right-tailed F probability distribution for two data sets (New in Excel 2010 - replaces the Fdist function)
F.DISTReturns the F probability distribution (probability density or cumulative distribution function) (New in Excel 2010)
FINVReturns the inverse of the right-tailed F probability distribution for two data sets (Replaced by F.Inv.Rt function in Excel 2010)
F.INV.RTReturns the inverse of the right-tailed F probability distribution for two data sets (New in Excel 2010 - replaces the Finv function)
F.INVReturns the inverse of the Cumulative F distribution (New in Excel 2010)
FISHERReturns the Fisher transformation
FISHERINVReturns the inverse of the Fisher transformation
FTESTReturns the result of an F-Test for 2 supplied data sets (Replaced by F.Test function in Excel 2010)
F.TESTReturns the result of an F-Test for 2 supplied data sets (New in Excel 2010 - replaces the Ftest function)
GAMMADISTReturns the gamma distribution (Replaced by Gamma.Dist function in Excel 2010)
GAMMA.DISTReturns the gamma distribution (New in Excel 2010 - replaces the Gammadist function)
GAMMAINVReturns the inverse gamma cumulative distribution (Replaced by Gamma.Inv function in Excel 2010)
GAMMA.INVReturns the inverse gamma cumulative distribution (New in Excel 2010 - replaces the Gammainv function)
GAMMAReturn the gamma function value for a supplied number (New in Excel 2013)
GAMMALNCalculates the natural logarithm of the gamma function for a supplied value
GAMMALN.PRECISEReturns the natural logarithm of the gamma function for a supplied value (New in Excel 2010)
GAUSSCalculates 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)
HYPGEOMDISTReturns the hypergeometric distribution (Replaced by Hypgeom.Dist function in Excel 2010)
HYPGEOM.DISTReturns the hypergeometric distribution (New in Excel 2010 - replaces the Hypgeomdist function)
KURTReturns the kurtosis of a data set
LOGNORMDISTReturns the cumulative log-normal distribution (Replaced by Lognorm.Dist function in Excel 2010)
LOGNORM.DISTReturns the log-normal probability density function or the cumulative log- normal distribution (New in Excel 2010 - replaces the Lognormdist function)
LOGINVReturns the inverse of the lognormal distribution (Replaced by Lognorm.Inv function in Excel 2010)
LOGNORM.INVReturns the inverse of the lognormal distribution (New in Excel 2010 - replaces the Loginv function)
NORMDISTReturns the normal cumulative distribution (Replaced by Norm.Dist function in Excel 2010)
NORM.DISTReturns the normal cumulative distribution (New in Excel 2010 - replaces the Normdist function)
NORMINVReturns the inverse of the normal cumulative distribution (Replaced by Norm.Inv function in Excel 2010)
NORM.INVReturns the inverse of the normal cumulative distribution (New in Excel 2010 - replaces the Norminv function)
NORMSDISTReturns the standard normal cumulative distribution (Replaced by Norm.S.Dist function in Excel 2010)
NORM.S.DISTReturns the standard normal cumulative distribution (New in Excel 2010 - replaces the Normsdist function)
NORMSINVReturns the inverse of the standard normal cumulative distribution (Replaced by Norm.S.Inv function in Excel 2010)
NORM.S.INVReturns the inverse of the standard normal cumulative distribution (New in Excel 2010 - replaces the Normsinv function)
PEARSONReturns the Pearson product moment correlation coefficient
RSQReturns the square of the Pearson product moment correlation coefficient
PHIReturns the value of the density function for a standard normal distribution, for a supplied number (New in Excel 2013)
POISSONReturns the Poisson distribution (Replaced by Poisson.Dist function in Excel 2010)
POISSON.DISTReturns the Poisson distribution (New in Excel 2010 - replaces the Poisson function)
PROBReturns the probablity that values in a supplied range are within given limits
SKEWReturns the skewness of a distribution
SKEW.PReturns the skewness of a distribution based on a population (New in Excel 2013)
STANDARDIZEReturns a normalized value
TDISTReturns the Student's T-distribution (Replaced by T.Dist.2t & T.Dist.Rt functions in Excel 2010)
T.DIST.2TReturns the two-tailed Student's T-distribution (New in Excel 2010 - replaces the Tdist function)
T.DIST.RTReturns the right-tailed Student's T-distribution (New in Excel 2010 - replaces the Tdist function)
T.DISTReturns the Student's T-distribution (probability density or cumulative distribution function) (New in Excel 2010)
TINVReturns the two-tailed inverse of the Student's T-distribution (Replaced by T.Inv.2t function in Excel 2010)
T.INV.2TReturns the two-tailed inverse of the Student's T-distribution (New in Excel 2010 - replaces the Tinv function)
T.INVReturns the left-tailed inverse of the Student's T-distribution (New in Excel 2010)
TTESTReturns the probability associated with a Student's T-Test (Replaced by T.Test function in Excel 2010)
T.TESTReturns the probability associated with a Student's T-Test (New in Excel 2010 - replaces the Ttest function)
WEIBULLReturns the Weibull distribution (Replaced by Weibull.Dist function in Excel 2010)
WEIBULL.DISTReturns the Weibull distribution (New in Excel 2010 - replaces the Weibull function)
ZTESTReturns the one-tailed probability value of a z-test (Replaced by Z.Test function in Excel 2010)
Z.TESTReturns the one-tailed probability value of a z-test (New in Excel 2010 - replaces the Ztest function)