Functions in English | Functions in French | Description of Function |
---|
AVEDEV | ECART.MOYEN | Returns the average of the absolute deviations of data points from their mean. |
AVERAGE | MOYENNE | Returns the average of its arguments. |
AVERAGEA | AVERAGEA | Returns the average of its arguments, including numbers, text, and logical values. |
AVERAGEIF | MOYENNE.SI | Returns the average (arithmetic mean) of all the cells in a range that meet a given criteria. |
AVERAGEIFS | MOYENNE.SI.ENS | Returns the average (arithmetic mean) of all cells that meet multiple criteria. |
BETA.DIST | LOI.BETA.N | Returns the beta cumulative distribution function. |
BETA.INV | BETA.INVERSE.N | Returns the inverse of the cumulative distribution function for a specified beta distribution. |
BINOM.DIST | LOI.BINOMIALE.N | Returns the individual term binomial distribution probability. |
BINOM.DIST.RANGE | LOI.BINOMIALE.SERIE | Returns the probability of a trial result using a binomial distribution (2013). |
BINOM.INV | LOI.BINOMIALE.INVERSE | Returns the smallest value for which the cumulative binomial distribution is less than or equal to a criterion value. |
CHISQ.DIST | LOI.KHIDEUX.N | Returns the cumulative beta probability density function. |
CHISQ.DIST.RT | LOI.KHIDEUX.DROITE | Returns the one-tailed probability of the chi-squared distribution. |
CHISQ.INV | LOI.KHIDEUX.INVERSE | Returns the cumulative beta probability density function. |
CHISQ.INV.RT | LOI.KHIDEUX.INVERSE.DROITE | Returns the inverse of the one-tailed probability of the chi-squared distribution. |
CHISQ.TEST | CHISQ.TEST | Returns the test for independence. |
CONFIDENCE.NORM | INTERVALLE.CONFIANCE.NORMAL | Returns the confidence interval for a population mean. |
CONFIDENCE.T | INTERVALLE.CONFIANCE.STUDENT | Returns the confidence interval for a population mean, using a Student's t distribution. |
CORREL | COEFFICIENT.CORRELATION | Returns the correlation coefficient between two data sets. |
Functions in English | Functions in French | Description of Function |
---|
COUNT | NB | Counts how many numbers are in the list of arguments. |
COUNTA | NBVAL | Counts how many values are in the list of arguments. |
COUNTBLANK | NB.VIDE | Counts the number of blank cells within a range. |
COUNTIF | NB.SI | Counts the number of cells within a range that meet the given criteria. |
COUNTIFS | NB.SI.ENS | Counts the number of cells within a range that meet multiple criteria. |
COVARIANCE.P | COVARIANCE.PEARSON | Returns covariance, the average of the products of paired deviations. |
COVARIANCE.S | COVARIANCE.STANDARD | Returns the sample covariance, the average of the products deviations for each data point pair in two data sets. |
DEVSQ | SOMME.CARRES.ECARTS | Returns the sum of squares of deviations. |
EXPON.DIST | LOI.EXPONENTIELLE.N | Returns the exponential distribution. |
F.DIST | LOI.F.N | Returns the F probability distribution. |
F.DIST.RT | LOI.F.DROITE | Returns the F probability distribution. |
F.INV | INVERSE.LOI.F.N | Returns the inverse of the F probability distribution. |
F.INV.RT | INVERSE.LOI.F.DROITE | Returns the inverse of the F probability distribution. |
F.TEST | F.TEST | Returns the result of an F-test. |
FISHER | FISHER | Returns the Fisher transformation. |
FISHERINV | FISHER.INVERSE | Returns the inverse of the Fisher transformation. |
FORECAST | PREVISION | Returns a value along a linear trend. |
FORECAST.ETS | PREVISION.ETS | Returns a future value based on existing (historical) values by using the AAA version of the Exponential Smoothing (ETS) algorithm (2016). |
FORECAST.ETS.CONFINT | PREVISION.ETS.CONFINT | Returns a confidence interval for the forecast value at the specified target date (2016). |
FORECAST.ETS.SEASONALITY | PREVISION.ETS.CARACTERESAISONNIER | Returns the length of the repetitive pattern Excel detects for the specified time series (2016). |
FORECAST.ETS.STAT | PREVISION.ETS.STAT | Returns a statistical value as a result of time series forecasting (2016). |
FORECAST.LINEAR | PREVISION.LINEAIRE | Returns a future value based on existing values (2016). |
FREQUENCY | FREQUENCE | Returns a frequency distribution as a vertical array. |
GAMMA | GAMMA | Returns the Gamma function value (2013). |
GAMMA.DIST | LOI.GAMMA.N | Returns the gamma distribution. |
GAMMA.INV | LOI.GAMMA.INVERSE.N | Returns the inverse of the gamma cumulative distribution. |
GAMMALN | LNGAMMA | Returns the natural logarithm of the gamma function, G(x). |
GAMMALN.PRECISE | LNGAMMA.PRECIS | Returns the natural logarithm of the gamma function, G(x). |
GAUSS | GAUSS | Returns 0.5 less than the standard normal cumulative distribution (2013). |
GEOMEAN | MOYENNE.GEOMETRIQUE | Returns the geometric mean. |
GROWTH | CROISSANCE | Returns values along an exponential trend. |
HARMEAN | MOYENNE.HARMONIQUE | Returns the harmonic mean. |
HYPGEOM.DIST | LOI.HYPERGEOMETRIQUE.N | Returns the hypergeometric distribution. |
INTERCEPT | ORDONNEE.ORIGINE | Returns the intercept of the linear regression line. |
KURT | KURTOSIS | Returns the kurtosis of a data set. |
LARGE | GRANDE.VALEUR | Returns the k-th largest value in a data set. |
LINEST | DROITEREG | Returns the parameters of a linear trend. |
LOGEST | LOGREG | Returns the parameters of an exponential trend. |
LOGNORM.DIST | LOI.LOGNORMALE.N | Returns the cumulative lognormal distribution. |
LOGNORM.INV | LOI.LOGNORMALE.INVERSE.N | Returns the inverse of the lognormal cumulative distribution. |
MAX | MAX | Returns the maximum value in a list of arguments. |
MAXA | MAXA | Returns the maximum value in a list of arguments, including numbers, text, and logical values. |
MAXIFS | MAX.SI.ENS | Returns the maximum value among cells specified by a given set of conditions or criteria (2019). |
MEDIAN | MEDIANE | Returns the median of the given numbers. |
MIN | MIN | Returns the minimum value in a list of arguments. |
MINA | MINA | Returns the smallest value in a list of arguments, including numbers, text, and logical values. |
MINIFS | MIN.SI.ENS | Returns the minimum value among cells specified by a given set of conditions or criteria (2019). |
MODE.MULT | MODE.MULTIPLE | Returns a vertical array of the most frequently occurring, or repetitive values in an array or range of data. |
MODE.SNGL | MODE.SIMPLE | Returns the most common value in a data set. |
NEGBINOM.DIST | LOI.BINOMIALE.NEG.N | Returns the negative binomial distribution. |
NORM.DIST | LOI.NORMALE.N | Returns the normal cumulative distribution. |
NORM.INV | LOI.NORMALE.INVERSE.N | Returns the inverse of the normal cumulative distribution. |
NORM.S.DIST | LOI.NORMALE.STANDARD.N | Returns the standard normal cumulative distribution. |
NORM.S.INV | LOI.NORMALE.STANDARD.INVERSE.N | Returns the inverse of the standard normal cumulative distribution. |
Functions in English | Functions in French | Description of Function |
---|
PEARSON | PEARSON | Returns the Pearson product moment correlation coefficient. |
PERCENTILE.EXC | CENTILE.EXCLURE | Returns the k-th percentile of values in a range, where k is in the range 0..1, exclusive.. |
PERCENTILE.INC | CENTILE.INCLURE | Returns the k-th percentile of values in a range. |
PERCENTRANK.EXC | RANG.POURCENTAGE.EXCLURE | Returns the rank of a value in a data set as a percentage (0..1, exclusive) of the data set. |
PERCENTRANK.INC | RANG.POURCENTAGE.INCLURE | Returns the percentage rank of a value in a data set. |
PERMUT | PERMUTATION | Returns the number of permutations for a given number of objects. |
PERMUTATIONA | PERMUTATIONA | Returns the number of permutations for a given number of objects (with repetitions) that can be selected from the total objects (2013). |
PHI | PHI | Returns the value of the density function for a standard normal distribution (2013). |
POISSON.DIST | LOI.POISSON.N | Returns the Poisson distribution. |
PROB | PROBABILITE | Returns the probability that values in a range are between two limits. |
QUARTILE.EXC | QUARTILE.EXCLURE | Returns the quartile of the data set, based on percentile values from 0..1, exclusive. |
QUARTILE.INC | QUARTILE.INCLURE | Returns the quartile of a data set. |
RANK.AVG | MOYENNE.RANG | Returns the rank of a number in a list of numbers. |
RANK.EQ | EQUATION.RANG | Returns the rank of a number in a list of numbers. |
RSQ | COEFFICIENT.DETERMINATION | Returns the square of the Pearson product moment correlation coefficient. |
SKEW | COEFFICIENT.ASYMETRIE | Returns the skewness of a distribution. |
SKEW.P | COEFFICIENT.ASYMETRIE.P | Returns the skewness of a distribution based on a population: a characterization of the degree of asymmetry of a distribution around its mean (2013). |
SLOPE | PENTE | Returns the slope of the linear regression line. |
SMALL | PETITE.VALEUR | Returns the k-th smallest value in a data set. |
STANDARDIZE | CENTREE.REDUITE | Returns a normalized value. |
STDEV.P | ECARTYPE.PEARSON | Calculates standard deviation based on the entire population. |
STDEV.S | ECARTYPE.STANDARD | Estimates standard deviation based on a sample. |
STDEVA | STDEVA | Estimates standard deviation based on a sample, including numbers, text, and logical values. |
STDEVPA | STDEVPA | Calculates standard deviation based on the entire population, including numbers, text, and logical values. |
STEYX | ERREUR.TYPE.XY | Returns the standard error of the predicted y-value for each x in the regression. |
T.DIST | LOI.STUDENT.N | Returns the Percentage Points (probability) for the Student t-distribution. |
T.DIST.2T | LOI.STUDENT.BILATERALE | Returns the Percentage Points (probability) for the Student t-distribution. |
T.DIST.RT | LOI.STUDENT.DROITE | Returns the Student's t-distribution. |
T.INV | LOI.STUDENT.INVERSE.N | Returns the t-value of the Student's t-distribution as a function of the probability and the degrees of freedom. |
T.INV.2T | LOI.STUDENT.INVERSE.BILATERALE | Returns the inverse of the Student's t-distribution. |
T.TEST | T.TEST | Returns the probability associated with a Student's t-test. |
TREND | TENDANCE | Returns values along a linear trend. |
TRIMMEAN | MOYENNE.REDUITE | Returns the mean of the interior of a data set. |
VAR.P | VAR.P.N | Calculates variance based on the entire population. |
VAR.S | VAR.S | Estimates variance based on a sample. |
VARA | VARA | Estimates variance based on a sample, including numbers, text, and logical values. |
VARPA | VARPA | Calculates variance based on the entire population, including numbers, text, and logical values. |
WEIBULL.DIST | LOI.WEIBULL.N | Returns the Weibull distribution. |
Z.TEST | Z.TEST | Returns the one-tailed probability-value of a z-test. |