Functions in English | Functions in French | Description of Function |
---|
BETADIST | LOI.BETA | Returns the beta cumulative distribution function. |
BETAINV | BETA.INVERSE | Returns the inverse of the cumulative distribution function for a specified beta distribution. |
BINOMDIST | LOI.BINOMIALE | Returns the individual term binomial distribution probability. |
CEILING | PLAFOND | Rounds a number to the nearest integer or to the nearest multiple of significance. |
CHIDIST | LOI.KHIDEUX | Returns the one-tailed probability of the chi-squared distribution. |
CHIINV | KHIDEUX.INVERSE | Returns the inverse of the one-tailed probability of the chi-squared distribution. |
CHITEST | TEST.KHIDEUX | Returns the test for independence. |
CONCATENATE | CONCATENER | Joins several text items into one text item. |
CONFIDENCE | INTERVALLE.CONFIANCE | Returns the confidence interval for a population mean. |
COVAR | COVARIANCE | Returns covariance, the average of the products of paired deviations. |
CRITBINOM | CRITERE.LOI.BINOMIALE | Returns the smallest value for which the cumulative binomial distribution is less than or equal to a criterion value. |
EXPONDIST | LOI.EXPONENTIELLE | Returns the exponential distribution. |
FDIST | LOI.F | Returns the F probability distribution. |
FINV | INVERSE.LOI.F | Returns the inverse of the F probability distribution. |
FLOOR | PLANCHER | Rounds a number down, toward zero. |
FORECAST | PREVISION | Returns a value along a linear trend. |
FTEST | TEST.F | Returns the result of an F-test. |
GAMMADIST | LOI.GAMMA | Returns the gamma distribution. |
GAMMAINV | LOI.GAMMA.INVERSE | Returns the inverse of the gamma cumulative distribution. |
HYPGEOMDIST | LOI.HYPERGEOMETRIQUE | Returns the hypergeometric distribution. |
LOGINV | LOI.LOGNORMALE.INVERSE | Returns the inverse of the lognormal cumulative distribution function. |
LOGNORMDIST | LOI.LOGNORMALE | Returns the cumulative lognormal distribution. |
Functions in English | Functions in French | Description of Function |
---|
MODE | MODE | Returns the most common value in a data set. |
NEGBINOMDIST | LOI.BINOMIALE.NEG | Returns the negative binomial distribution. |
NORMDIST | LOI.NORMALE | Returns the normal cumulative distribution. |
NORMINV | LOI.NORMALE.INVERSE | Returns the inverse of the normal cumulative distribution. |
NORMSDIST | LOI.NORMALE.STANDARD | Returns the standard normal cumulative distribution. |
NORMSINV | LOI.NORMALE.STANDARD.INVERSE | Returns the inverse of the standard normal cumulative distribution. |
PERCENTILE | CENTILE | Returns the k-th percentile of values in a range. |
PERCENTRANK | RANG.POURCENTAGE | Returns the percentage rank of a value in a data set. |
POISSON | LOI.POISSON | Returns the Poisson distribution. |
QUARTILE | QUARTILE | Returns the quartile of a data set. |
RANK | RANG | Returns the rank of a number in a list of numbers. |
STDEV | ECARTYPE | Estimates standard deviation based on a sample. |
STDEVP | ECARTYPEP | Calculates standard deviation based on the entire population. |
TDIST | LOI.STUDENT | Returns the Student's t-distribution. |
TINV | LOI.STUDENT.INVERSE | Returns the inverse of the Student's t-distribution. |
TTEST | TEST.STUDENT | Returns the probability associated with a Student's t-test. |
VAR | VAR | Estimates variance based on a sample. |
VARP | VAR.P | Calculates variance based on the entire population. |
WEIBULL | LOI.WEIBULL | Returns the Weibull distribution. |
ZTEST | TEST.Z | Returns the one-tailed probability-value of a z-test. |