FR/Documentation/Calc: Fonctions statistiques
From Apache OpenOffice Wiki
< FR | Documentation
Liste des fonctions statistiques Calc
Les fonctions statistiques permettent une analyse statistique des données.
Mesures de tendance centrale | |
ECART.MOYEN | Renvoie la moyenne des déviations absolues de valeurs à partir de leur moyenne. |
MOYENNE | Renvoie la moyenne des arguments, en ignorant le texte. |
MOYENNEA | Renvoie la moyenne des arguments, incluant du texte (évalué comme 0). |
NB | Compte les nombres dans une liste d'arguments, ignorant le texte. |
NBVAL | Compte les valeurs non vided dans la liste des arguments. |
MOYENNE.GEOMETRIQUE | Renvoie la moyenne géométrique des arguments. |
MOYENNE.HARMONIQUE | Renvoie la moyenne harmonique des arguments. |
MEDIANE | Renvoie la médiane d'un ensemble de nombres. |
MODE | Renvoie la valeur commune dans un ensemble de nombres. |
MOYENNE.REDUITE | Renvoie la moyenne d'un ensemble de nombres, ignorant une proportion de valeurs hautes et basses. |
Mesures de dispersion / répartition | |
SOMME.CARRES.ECARTS | Renvoie la somme des carrés de la déviation de la moyenne. |
KURTOSIS | Renvoie le kurtosis, une mesure de la façon dont la distribution est pointue ou plate. |
COEFFICIENT.ASYMETRIE | Renvoie une mesure de la façon dont une distribution est asymétrique. |
ECARTYPE | Renvoie l'écart type de l'échantillon. |
ECARTYPEA | Renvoie l'écart type de l'échantillon (autorisant du texte et des valeurs logiques). |
ECARTYPEP | Renvoie l'écart type de la population. |
ECARTYPEPA | Renvoie l'écart type de la population (autorisant du texte et des valeurs logiques). |
VAR | Renvoie la variance de l'échantillon. |
VARA | Renvoie la variance de l'échantillon (autorisant du texte et des valeurs logiques). |
VAR.P | Renvoie la variance de la population. |
VAR.PA | Renvoie la variance de la population (autorisant du texte et des valeurs logiques). |
Probability and statistics | |
B | Calculates probabilities for a binomial distribution. |
BETADIST | Calculates the cumulative distribution function of a beta distribution. |
BETAINV | Calculates the inverse of the BETADIST function. |
BINOMDIST | Calculates probabilities for a binomial distribution. |
CHIDIST | Calculates values for a χ2-distribution. |
CHIINV | Calculates the inverse of the CHIDIST function. |
CHITEST | Returns a measure of χ2 'goodness of fit'. |
CONFIDENCE | Returns a confidence interval. |
CRITBINOM | Returns the smallest value for which the cumulative binomial distribution is greater than or equal to a criterion value. |
EXPONDIST | Calculates values for an exponential distribution. |
FINV | Returns the inverse of the F probability distribution. |
FISHER | Calculates values for the Fisher transformation. |
FISHERINV | Calculates the inverse of the FISHER transformation. |
FDIST | Calculates the values of an F distribution. |
FTEST | Returns the result of an F test. |
GAMMAINV | Calculates the inverse of the cumulative GAMMADIST function. |
GAMMALN | Returns the natural logarithm of the gamma function. |
GAMMADIST | Calculates values for a gamma distribution. |
GAUSS | Returns the standard normal cumulative distribution. |
HYPGEOMDIST | Calculates values for a hypergeometric distribution. |
LOGINV | Returns the inverse of the lognormal distribution. |
LOGNORMDIST | Returns the cumulative lognormal distribution. |
NEGBINOMDIST | Calculates probabilities for a negative binomial distribution. |
NORMINV | Returns the inverse of the normal cumulative distribution. |
NORMDIST | Calculates values for a normal distribution. |
NORMSINV | Returns the inverse of the standard normal cumulative distribution. |
NORMSDIST | Calculates values for the standard normal cumulative distribution. |
PERMUT | Returns the number of permutations for a given number of objects. |
PERMUTATIONA | Returns the number of permutations for a given number of objects (repetition allowed). |
PHI | Calculates values for the standard normal probability distribution. |
POISSON | Calculates values for a Poisson distribution. |
PROB | Returns a result from a list of probabilities. |
STANDARDIZE | Converts a random variable to a normalized value. |
TDIST | Returns the t-distribution. |
TINV | Returns the inverse of the t-distribution. |
TTEST | Returns the probability associated with a Student's t-Test. |
WEIBULL | Returns the values of the Weibull distribution. |
ZTEST | Returns the two-tailed P value of a z test with standard distribution. |
Correlation and line fitting | |
CORREL | Returns the correlation coefficient between two data sets. |
COVAR | Returns the covariance of the product of paired deviations. |
FORECAST | Extrapolates future values based on existing x and y values. |
INTERCEPT | Calculates the point at which a line will intersect the y-values by using known x-values and y-values. |
PEARSON | Returns the Pearson product moment correlation coefficient r. |
RSQ | Returns the square of the Pearson correlation coefficient based on the given values. |
SLOPE | Returns the slope of the linear regression line for a data set. |
STEYX | Returns the standard error of the predicted y value for each x in the regression. |
see also (in the Array Function category) | |
GROWTH | returns an array of values for an exponential least squares fit to known data pairs. |
LINEST | returns an array of statistics for a straight line that best fits a data set. |
LOGEST | returns an array of statistics for an exponential curve that best fits a data set. |
TREND | fits a straight line to a data set using linear regression and returns points on that line. |
Ranking | |
LARGE | Returns the nth largest value in a list of numbers. |
MAX | Returns the maximum value in a list of arguments. |
MAXA | Returns the maximum value in a list of arguments including text. |
MIN | Returns the minimum value in a list of arguments. |
MINA | Returns the minimum value in a list of arguments, including text. |
PERCENTILE | Returns a specified percentile in a list of numbers. |
PERCENTRANK | Returns the percentage rank of a number in a list of numbers. |
QUARTILE | Returns a specified quartile in a list of numbers. |
RANK | Returns the rank of a number in a list of numbers. |
SMALL | Returns the nth smallest value in a list of numbers. |