Statistical functions

Functions in EnglishFunctions in FrenchDescription of Function
AVEDEVECART.MOYENReturns the average of the absolute deviations of data points from their mean.
AVERAGEMOYENNEReturns the average of its arguments.
AVERAGEAAVERAGEAReturns the average of its arguments, including numbers, text, and logical values.
AVERAGEIFMOYENNE.SIReturns the average (arithmetic mean) of all the cells in a range that meet a given criteria.
AVERAGEIFSMOYENNE.SI.ENSReturns the average (arithmetic mean) of all cells that meet multiple criteria.
BETA.DISTLOI.BETA.NReturns the beta cumulative distribution function.
BETA.INVBETA.INVERSE.NReturns the inverse of the cumulative distribution function for a specified beta distribution.
BINOM.DISTLOI.BINOMIALE.NReturns the individual term binomial distribution probability.
BINOM.DIST.RANGELOI.BINOMIALE.SERIEReturns the probability of a trial result using a binomial distribution (2013).
BINOM.INVLOI.BINOMIALE.INVERSEReturns the smallest value for which the cumulative binomial distribution is less than or equal to a criterion value.
CHISQ.DISTLOI.KHIDEUX.NReturns the cumulative beta probability density function.
CHISQ.DIST.RTLOI.KHIDEUX.DROITEReturns the one-tailed probability of the chi-squared distribution.
CHISQ.INVLOI.KHIDEUX.INVERSEReturns the cumulative beta probability density function.
CHISQ.INV.RTLOI.KHIDEUX.INVERSE.DROITEReturns the inverse of the one-tailed probability of the chi-squared distribution.
CHISQ.TESTCHISQ.TESTReturns the test for independence.
CONFIDENCE.NORMINTERVALLE.CONFIANCE.NORMALReturns the confidence interval for a population mean.
CONFIDENCE.TINTERVALLE.CONFIANCE.STUDENTReturns the confidence interval for a population mean, using a Student's t distribution.
CORRELCOEFFICIENT.CORRELATIONReturns the correlation coefficient between two data sets.
COUNTNBCounts how many numbers are in the list of arguments.
COUNTANBVALCounts how many values are in the list of arguments.
COUNTBLANKNB.VIDECounts the number of blank cells within a range.
COUNTIFNB.SICounts the number of cells within a range that meet the given criteria.
COUNTIFSNB.SI.ENSCounts the number of cells within a range that meet multiple criteria.
COVARIANCE.PCOVARIANCE.PEARSONReturns covariance, the average of the products of paired deviations.
COVARIANCE.SCOVARIANCE.STANDARDReturns the sample covariance, the average of the products deviations for each data point pair in two data sets.
DEVSQSOMME.CARRES.ECARTSReturns the sum of squares of deviations.
EXPON.DISTLOI.EXPONENTIELLE.NReturns the exponential distribution.
F.DISTLOI.F.NReturns the F probability distribution.
F.DIST.RTLOI.F.DROITEReturns the F probability distribution.
F.INVINVERSE.LOI.F.NReturns the inverse of the F probability distribution.
F.INV.RTINVERSE.LOI.F.DROITEReturns the inverse of the F probability distribution.
F.TESTF.TESTReturns the result of an F-test.
FISHERFISHERReturns the Fisher transformation.
FISHERINVFISHER.INVERSEReturns the inverse of the Fisher transformation.
FORECASTPREVISIONReturns a value along a linear trend.
FORECAST.ETSPREVISION.ETSReturns a future value based on existing (historical) values by using the AAA version of the Exponential Smoothing (ETS) algorithm (2016).
FORECAST.ETS.CONFINTPREVISION.ETS.CONFINTReturns a confidence interval for the forecast value at the specified target date (2016).
FORECAST.ETS.SEASONALITYPREVISION.ETS.CARACTERESAISONNIERReturns the length of the repetitive pattern Excel detects for the specified time series (2016).
FORECAST.ETS.STATPREVISION.ETS.STATReturns a statistical value as a result of time series forecasting (2016).
FORECAST.LINEARPREVISION.LINEAIREReturns a future value based on existing values (2016).
FREQUENCYFREQUENCEReturns a frequency distribution as a vertical array.
GAMMAGAMMAReturns the Gamma function value (2013).
GAMMA.DISTLOI.GAMMA.NReturns the gamma distribution.
GAMMA.INVLOI.GAMMA.INVERSE.NReturns the inverse of the gamma cumulative distribution.
GAMMALNLNGAMMAReturns the natural logarithm of the gamma function, G(x).
GAMMALN.PRECISELNGAMMA.PRECISReturns the natural logarithm of the gamma function, G(x).
GAUSSGAUSSReturns 0.5 less than the standard normal cumulative distribution (2013).
GEOMEANMOYENNE.GEOMETRIQUEReturns the geometric mean.
GROWTHCROISSANCEReturns values along an exponential trend.
HARMEANMOYENNE.HARMONIQUEReturns the harmonic mean.
HYPGEOM.DISTLOI.HYPERGEOMETRIQUE.NReturns the hypergeometric distribution.
INTERCEPTORDONNEE.ORIGINEReturns the intercept of the linear regression line.
KURTKURTOSISReturns the kurtosis of a data set.
LARGEGRANDE.VALEURReturns the k-th largest value in a data set.
LINESTDROITEREGReturns the parameters of a linear trend.
LOGESTLOGREGReturns the parameters of an exponential trend.
LOGNORM.DISTLOI.LOGNORMALE.NReturns the cumulative lognormal distribution.
LOGNORM.INVLOI.LOGNORMALE.INVERSE.NReturns the inverse of the lognormal cumulative distribution.
MAXMAXReturns the maximum value in a list of arguments.
MAXAMAXAReturns the maximum value in a list of arguments, including numbers, text, and logical values.
MAXIFSMAX.SIReturns the maximum value among cells specified by a given set of conditions or criteria (2016).
MEDIANMEDIANEReturns the median of the given numbers.
MINMINReturns the minimum value in a list of arguments.
MINAMINAReturns the smallest value in a list of arguments, including numbers, text, and logical values.
MINIFSMIN.SIReturns the minimum value among cells specified by a given set of conditions or criteria (2016).
MODE.MULTMODE.MULTIPLEReturns a vertical array of the most frequently occurring, or repetitive values in an array or range of data.
MODE.SNGLMODE.SIMPLEReturns the most common value in a data set.
NEGBINOM.DISTLOI.BINOMIALE.NEG.NReturns the negative binomial distribution.
NORM.DISTLOI.NORMALE.NReturns the normal cumulative distribution.
NORM.INVLOI.NORMALE.INVERSE.NReturns the inverse of the normal cumulative distribution.
NORM.S.DISTLOI.NORMALE.STANDARD.NReturns the standard normal cumulative distribution.
NORM.S.INVLOI.NORMALE.STANDARD.INVERSE.NReturns the inverse of the standard normal cumulative distribution.
PEARSONPEARSONReturns the Pearson product moment correlation coefficient.
PERCENTILE.EXCCENTILE.EXCLUREReturns the k-th percentile of values in a range, where k is in the range 0..1, exclusive..
PERCENTILE.INCCENTILE.INCLUREReturns the k-th percentile of values in a range.
PERCENTRANK.EXCRANG.POURCENTAGE.EXCLUREReturns the rank of a value in a data set as a percentage (0..1, exclusive) of the data set.
PERCENTRANK.INCRANG.POURCENTAGE.INCLUREReturns the percentage rank of a value in a data set.
PERMUTPERMUTATIONReturns the number of permutations for a given number of objects.
PERMUTATIONAPERMUTATIONAReturns the number of permutations for a given number of objects (with repetitions) that can be selected from the total objects (2013).
PHIPHIReturns the value of the density function for a standard normal distribution (2013).
POISSON.DISTLOI.POISSON.NReturns the Poisson distribution.
PROBPROBABILITEReturns the probability that values in a range are between two limits.
QUARTILE.EXCQUARTILE.EXCLUREReturns the quartile of the data set, based on percentile values from 0..1, exclusive.
QUARTILE.INCQUARTILE.INCLUREReturns the quartile of a data set.
RANK.AVGMOYENNE.RANGReturns the rank of a number in a list of numbers.
RANK.EQEQUATION.RANGReturns the rank of a number in a list of numbers.
RSQCOEFFICIENT.DETERMINATIONReturns the square of the Pearson product moment correlation coefficient.
SKEWCOEFFICIENT.ASYMETRIEReturns the skewness of a distribution.
SKEW.PCOEFFICIENT.ASYMETRIE.PReturns the skewness of a distribution based on a population: a characterization of the degree of asymmetry of a distribution around its mean (2013).
SLOPEPENTEReturns the slope of the linear regression line.
SMALLPETITE.VALEURReturns the k-th smallest value in a data set.
STANDARDIZECENTREE.REDUITEReturns a normalized value.
STDEV.PECARTYPE.PEARSONCalculates standard deviation based on the entire population.
STDEV.SECARTYPE.STANDARDEstimates standard deviation based on a sample.
STDEVASTDEVAEstimates standard deviation based on a sample, including numbers, text, and logical values.
STDEVPASTDEVPACalculates standard deviation based on the entire population, including numbers, text, and logical values.
STEYXERREUR.TYPE.XYReturns the standard error of the predicted y-value for each x in the regression.
T.DISTLOI.STUDENT.NReturns the Percentage Points (probability) for the Student t-distribution.
T.DIST.2TLOI.STUDENT.BILATERALEReturns the Percentage Points (probability) for the Student t-distribution.
T.DIST.RTLOI.STUDENT.DROITEReturns the Student's t-distribution.
T.INVLOI.STUDENT.INVERSE.NReturns the t-value of the Student's t-distribution as a function of the probability and the degrees of freedom.
T.INV.2TLOI.STUDENT.INVERSE.BILATERALEReturns the inverse of the Student's t-distribution.
T.TESTT.TESTReturns the probability associated with a Student's t-test.
TRENDTENDANCEReturns values along a linear trend.
TRIMMEANMOYENNE.REDUITEReturns the mean of the interior of a data set.
VAR.PVAR.P.NCalculates variance based on the entire population.
VAR.SVAR.SEstimates variance based on a sample.
VARAVARAEstimates variance based on a sample, including numbers, text, and logical values.
VARPAVARPACalculates variance based on the entire population, including numbers, text, and logical values.
WEIBULL.DISTLOI.WEIBULL.NReturns the Weibull distribution.
Z.TESTZ.TESTReturns the one-tailed probability-value of a z-test.