English: Comparison of mean, median and mode o...

Comparison of mean, median and mode of two log-normal distributions with different skewness. 

Excel provides a large selection of Statistical Functions, that perform most of the common statistical calculations, from basic mean, median & mode calculations to the more complex statistical distribution and probability tests. Please note that some of the functions are new to Excel 2007 or Excel 2010, so are not available in earlier versions of Excel.

The Excel Statistical functions are all listed in the table below. The functions have been grouped into categories, to enable you to easily find the function you need to perform a specific task. Selecting a function name will take you to a full description, with examples of use, and common errors.

FunctionCategoryDescription
AVEDEVDeviation & VarianceReturns the average of the absolute deviations of data points from their mean
AVERAGEAverages, Frequency & RankReturns the Average of a list of supplied numbers
AVERAGEAAverages, Frequency & RankReturns 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
AVERAGEIFAverages, Frequency & RankCalculates the Average of the cells in a supplied range, that satisfy a given criteria (New in Excel 2007)
AVERAGEIFSAverages, Frequency & RankCalculates the Average of the cells in a supplied range, that satisfy multiple criteria (New in Excel 2007)
BETA.DISTDistribution & Probability TestsReturns the cumulative beta distribution function or the beta probability density function (New in Excel 2010 - replaces BETADIST function)
BETA.INVDistribution & Probability TestsReturns the inverse of the cumulative beta probability density function (New in Excel 2010 - replaces BETAINV function)
BINOM.DISTDistribution & Probability TestsReturns the individual term binomial distribution probability (New in Excel 2010 - replaces BINOMDIST function)
BINOM.DIST.RANGEDistribution & Probability TestsReturns the probability of a trial result using a binomial distribution (New in Excel 2013)
BINOM.INVDistribution & Probability TestsReturns the smallest value for which the cumulative binomial distribution is greater than or equal to a criterion value (New in Excel 2010 - replaces CRITBINOM function)
CHISQ.DISTDistribution & Probability TestsReturns the chi-squared distribution (probability density or cumulative distribution function) (New in Excel 2010)
CHISQ.DIST.RTDistribution & Probability TestsReturns the right-tailed probability of the chi-squared distribution (New in Excel 2010 - replaces CHIDIST function)
CHISQ.INVDistribution & Probability TestsReturns the inverse of the left-tailed probability of the chi-squared distribution (New in Excel 2010)
CHISQ.INV.RTDistribution & Probability TestsReturns the inverse of the right-tailed probability of the chi-squared distribution (New in Excel 2010 - replaces CHIINV function)
CHISQ.TESTDistribution & Probability TestsReturns the chi-squared statistical test for independence (New in Excel 2010 - replaces CHITEST function)
CONFIDENCE.NORMDeviation & VarianceReturns the confidence interval for a population mean, using a normal distribution (New in Excel 2010 - replaces CONFIDENCE function)
CONFIDENCE.TDeviation & VarianceReturns the confidence interval for a population mean, using a Student's t distribution (New in Excel 2010)
CORRELDistribution & Probability TestsReturns the correlation coefficient between two sets of values
COUNTCounting CellsReturns the number of numerical values in a supplied set of cells or values
COUNTACounting CellsReturns the number of non-blanks in a supplied set of cells or values
COUNTBLANKCounting CellsReturns the number of blank cells in a supplied range
COUNTIFCounting CellsReturns the number of cells (of a supplied range), that satisfy a given criteria
COUNTIFSCounting CellsReturns the number of cells (of a supplied range), that satisfy a set of given criteria (New in Excel 2007)
COVARIANCE.PDeviation & VarianceReturns population covariance (ie. the average of the products of deviations for each pair within two supplied data sets) (New in Excel 2010 - replaces COVAR function)
COVARIANCE.SDeviation & VarianceReturns sample covariance (ie. the average of the products of deviations for each pair within two supplied data sets) (New in Excel 2010)
DEVSQDeviation & VarianceReturns the sum of the squares of the deviations of a set of data points from their sample mean
EXPON.DISTDistribution & Probability TestsReturns the exponential distribution (New in Excel 2010 - replaces EXPONDIST function)
F.DISTDistribution & Probability TestsReturns the F probability distribution (probability density or cumulative distribution function) (New in Excel 2010)
F.DIST.RTDistribution & Probability TestsReturns the right-tailed F probability distribution for two data sets (New in Excel 2010 - replaces FDIST function)
F.INVDistribution & Probability TestsReturns the inverse of the Cumulative F distribution (New in Excel 2010)
F.INV.RTDistribution & Probability TestsReturns the inverse of the right-tailed F probability distribution for two data sets (New in Excel 2010 - replaces FINV function)
F.TESTDistribution & Probability TestsReturns the result of an F-Test for 2 supplied data sets (New in Excel 2010 - replaces FTEST function)
FISHERDistribution & Probability TestsReturns the Fisher transformation
FISHERINVDistribution & Probability TestsReturns the inverse of the Fisher transformation
FORECASTTrend Line FunctionsPredicts a future point on a linear trend line fitted to a supplied set of x- and y- values (Replaced with FORECAST.LINEAR function in Excel 2016)
FORECAST.ETSTrend Line FunctionsReturns a future value based on existing (historical) values by using the AAA version of the Exponential Smoothing (ETS) algorithm (New in Excel 2016 - NOTE: This function is not available in Excel 2016 for Mac)
FORECAST.ETS.CONFINTTrend Line FunctionsReturns a confidence interval for the forecast value at the specified target date (New in Excel 2016 - NOTE: This function is not available in Excel 2016 for Mac)
FORECAST.ETS.SEASONALITYTrend Line FunctionsReturns the length of the repetitive pattern Excel detects for the specified time series (New in Excel 2016 - NOTE: This function is not available in Excel 2016 for Mac)
FORECAST.ETS.STATTrend Line FunctionsReturns a statistical value as a result of time series forecasting (New in Excel 2016 - NOTE: This function is not available in Excel 2016 for Mac)
FORECAST.LINEARTrend Line FunctionsReturns a future value based on existing values (New in Excel 2016 - NOTE: This function isn't available in Excel 2016 for Mac)
FREQUENCYAverages, Frequency & RankReturns an array showing the number of values from a supplied array, which fall into specified ranges
GAMMADistribution & Probability TestsReturns the Gamma function value (New in Excel 2013)
GAMMA.DISTDistribution & Probability TestsReturns the gamma distribution (New in Excel 2010 - replaces GAMMADIST function)
GAMMA.INVDistribution & Probability TestsReturns the inverse gamma cumulative distribution (New in Excel 2010 - replaces GAMMAINV function)
GAMMALNDistribution & Probability TestsCalculates the natural logarithm of the gamma function for a supplied value
GAMMALN.PRECISEDistribution & Probability TestsReturns the natural logarithm of the gamma function for a supplied value (New in Excel 2010)
GAUSSDistribution & Probability TestsReturns 0.5 less than the standard normal cumulative distribution (New in Excel 2013)
GEOMEANAverages, Frequency & RankReturns the geometric mean of a set of supplied numbers
GROWTHTrend Line FunctionsReturns numbers in a exponential growth trend, based on a set of supplied x- and y- values
HARMEANAverages, Frequency & RankReturns the harmonic mean of a set of supplied numbers
HYPGEOM.DISTDistribution & Probability TestsReturns the hypergeometric distribution (New in Excel 2010 - replaces HYPGEOMDIST function)
INTERCEPTTrend Line FunctionsCalculates 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
KURTAverages, Frequency & RankReturns the kurtosis of a data set
LARGEFinding the largest and smallestReturns the Kth LARGEST value from a list of supplied numbers, for a given value K
LINESTTrend Line FunctionsReturns statistical information describing the trend of the line of best fit, through a supplied series of x- and y- values
LOGESTTrend Line FunctionsReturns the parameters of an exponential trend for a supplied set of x- and y- values
LOGNORM.DISTDistribution & Probability TestsReturns the log-normal probability density function or the cumulative log- normal distribution (New in Excel 2010 - replaces LOGNORMDIST function)
LOGNORM.INVDistribution & Probability TestsReturns the inverse of the lognormal distribution (New in Excel 2010 - replaces LOGINV function)
MAXFinding the largest and smallestReturns the largest value from a list of supplied numbers
MAXAFinding the largest and smallestReturns 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
MEDIANAverages, Frequency & RankReturns the Median (the middle value) of a list of supplied numbers
MINFinding the largest and smallestReturns the smallest value from a list of supplied numbers
MINAFinding the largest and smallestReturns 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
MODE.MULTAverages, Frequency & RankReturns a vertical array of the most frequently occurring values in an array or range of data (New in Excel 2010)
MODE.SNGLAverages, Frequency & RankReturns the Mode (the most frequently occurring value) of a list of supplied numbers (New in Excel 2010 - replaces MODE function)
NEGBINOM.DISTDistribution & Probability TestsReturns the negative binomial distribution (New in Excel 2010 - replaces NEGBINOMDIST function)
NORM.DISTDistribution & Probability TestsReturns the normal cumulative distribution (New in Excel 2010 - replaces NORMDIST function)
NORM.INVDistribution & Probability TestsReturns the inverse of the normal cumulative distribution (New in Excel 2010 - replaces NORMINV function)
NORM.S.DISTDistribution & Probability TestsReturns the standard normal cumulative distribution (New in Excel 2010 - replaces NORMSDIST function)
NORM.S.INVDistribution & Probability TestsReturns the inverse of the standard normal cumulative distribution (New in Excel 2010 - replaces NORMSINV function)
PEARSONDistribution & Probability TestsReturns the Pearson product moment correlation coefficient
PERCENTILE.EXCAverages, Frequency & RankReturns the K'th percentile of values in a supplied range, where K is in the range 0 - 1 (exclusive) (New in Excel 2010)
PERCENTILE.INCAverages, Frequency & RankReturns the K'th percentile of values in a supplied range, where K is in the range 0 - 1 (inclusive) (New in Excel 2010 - replaces PERCENTILE function)
PERCENTRANK.EXCAverages, Frequency & RankReturns the rank of a value in a data set, as a percentage (0 - 1 exclusive) (New in Excel 2010)
PERCENTRANK.INCAverages, Frequency & RankReturns the rank of a value in a data set, as a percentage (0 - 1 inclusive) (New in Excel 2010 - replaces PERCENTRANK function)
PERMUTMiscReturns the number of permutations for a given number of objects
PERMUTATIONAMiscReturns the number of permutations for a given number of objects (with repetitions) that can be selected from the total objects (New in Excel 2013)
PHIMiscReturns the value of the density function for a standard normal distribution (New in Excel 2013)
POISSON.DISTDistribution & Probability TestsReturns the Poisson distribution (New in Excel 2010 - replaces POISSON function)
PROBDistribution & Probability TestsReturns the probablity that values in a supplied range are within given limits
QUARTILE.EXCAverages, Frequency & RankReturns the specified quartile of a set of supplied numbers, based on percentile value 0 - 1 (exclusive) (New in Excel 2010)
QUARTILE.INCAverages, Frequency & RankReturns the specified quartile of a set of supplied numbers, based on percentile value 0 - 1 (inclusive) (New in Excel 2010 - replaces QUARTILE function)
RANK.AVGAverages, Frequency & RankReturns 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)
RANK.EQAverages, Frequency & RankReturns 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 RANK function)
RSQDistribution & Probability TestsReturns the square of the Pearson product moment correlation coefficient
SKEWDistribution & Probability TestsReturns the skewness of a distribution
SKEW.PDistribution & Probability TestsReturns the skewness of a distribution based on a population: a characterization of the degree of asymmetry of a distribution around its mean (New in Excel 2013)
SLOPETrend Line FunctionsReturns the slope of the linear regression line through a supplied series of x- and y- values
SMALLFinding the largest and smallestReturns the Kth SMALLEST value from a list of supplied numbers, for a given value K
STANDARDIZEDistribution & Probability TestsReturns a normalized value
STDEV.PDeviation & VarianceReturns the standard deviation of a supplied set of values (which represent an entire population) (New in Excel 2010 - replaces STDEVP function)
STDEV.SDeviation & VarianceReturns the standard deviation of a supplied set of values (which represent a sample of a population) (New in Excel 2010 - replaces STDEV function)
STDEVADeviation & VarianceReturns 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
STDEVPADeviation & VarianceReturns 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
STEYXTrend Line FunctionsReturns the standard error of the predicted y-value for each x in the regression line for a set of supplied x- and y- values
T.DISTDistribution & Probability TestsReturns the Student's T-distribution (probability density or cumulative distribution function) (New in Excel 2010)
T.DIST.2TDistribution & Probability TestsReturns the two-tailed Student's T-distribution (New in Excel 2010 - replaces TDIST function)
T.DIST.RTDistribution & Probability TestsReturns the right-tailed Student's T-distribution (New in Excel 2010 - replaces TDIST function)
T.INVDistribution & Probability TestsReturns the left-tailed inverse of the Student's T-distribution (New in Excel 2010)
T.INV.2TDistribution & Probability TestsReturns the two-tailed inverse of the Student's T-distribution (New in Excel 2010 - replaces TINV function)
T.TESTDistribution & Probability TestsReturns the probability associated with a Student's T-Test (New in Excel 2010 - replaces TTEST function)
TRENDTrend Line FunctionsCalculates the trend line through a given set of y-values and returns additional y-values for a supplied set of new x-values
TRIMMEANAverages, Frequency & RankReturns the mean of the interior of a supplied set of values
VAR.PDeviation & VarianceReturns the variance of a supplied set of values (which represent an entire population) (New in Excel 2010 - replaces VARP function)
VAR.SDeviation & VarianceReturns the variance of a supplied set of values (which represent a sample of a population) (New in Excel 2010 - replaces VAR function)
VARADeviation & VarianceReturns 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
VARPADeviation & VarianceReturns 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
WEIBULL.DISTDistribution & Probability TestsReturns the Weibull distribution (New in Excel 2010 - replaces WEIBULL function)
Z.TESTDistribution & Probability TestsReturns the one-tailed probability value of a z-test (New in Excel 2010 - replaces ZTEST function)