Difference between revisions of "Documentation/How Tos/Calc: Statistical functions"
From Apache OpenOffice Wiki
< Documentation | How Tos
Javier Lopez (Talk | contribs) |
Javier Lopez (Talk | contribs) |
||
Line 15: | Line 15: | ||
* [[Documentation/How_Tos/Calc:_COUNT_function|<div style="font-size: 120%;">Count]] | * [[Documentation/How_Tos/Calc:_COUNT_function|<div style="font-size: 120%;">Count]] | ||
* [[Documentation/How_Tos/Calc:_COUNTA_function|<div style="font-size: 120%;">Counta]] | * [[Documentation/How_Tos/Calc:_COUNTA_function|<div style="font-size: 120%;">Counta]] | ||
− | * [[Documentation/How_Tos/Calc:_GEOMEAN_function|<div style="font-size: 120%;"> | + | * [[Documentation/How_Tos/Calc:_GEOMEAN_function|<div style="font-size: 120%;">Geomean]] |
− | * [[Documentation/How_Tos/Calc:_HARMEAN_function|<div style="font-size: 120%;"> | + | * [[Documentation/How_Tos/Calc:_HARMEAN_function|<div style="font-size: 120%;">Hearmean]] |
− | * [[Documentation/How_Tos/Calc:_MEDIAN_function|<div style="font-size: 120%;"> | + | * [[Documentation/How_Tos/Calc:_MEDIAN_function|<div style="font-size: 120%;">Median]] |
− | * [[Documentation/How_Tos/Calc:_MODE_function|<div style="font-size: 120%;"> | + | * [[Documentation/How_Tos/Calc:_MODE_function|<div style="font-size: 120%;">Mode]] |
− | * [[Documentation/How_Tos/Calc:_TRIMMEAN_function|<div style="font-size: 120%;"> | + | * [[Documentation/How_Tos/Calc:_TRIMMEAN_function|<div style="font-size: 120%;">Trimmean]] |
<div style="font-size: 140%; border-style: outset outset outset none; border-color:#DCE9FC;">Measures of dispersion / spread</div> | <div style="font-size: 140%; border-style: outset outset outset none; border-color:#DCE9FC;">Measures of dispersion / spread</div> | ||
− | * [[Documentation/How_Tos/Calc:_DEVSQ_function|<div style="font-size: 120%;"> | + | * [[Documentation/How_Tos/Calc:_DEVSQ_function|<div style="font-size: 120%;">Devsq]] |
− | * [[Documentation/How_Tos/Calc:_KURT_function|<div style="font-size: 120%;"> | + | * [[Documentation/How_Tos/Calc:_KURT_function|<div style="font-size: 120%;">Kurt]] |
− | * [[Documentation/How_Tos/Calc:_SKEW_function|<div style="font-size: 120%;"> | + | * [[Documentation/How_Tos/Calc:_SKEW_function|<div style="font-size: 120%;">Skew]] |
− | * [[Documentation/How_Tos/Calc:_STDEV_function|<div style="font-size: 120%;"> | + | * [[Documentation/How_Tos/Calc:_STDEV_function|<div style="font-size: 120%;">Stdev]] |
− | * [[Documentation/How_Tos/Calc:_STDEVA_function|<div style="font-size: 120%;"> | + | * [[Documentation/How_Tos/Calc:_STDEVA_function|<div style="font-size: 120%;">Stedeva]] |
− | * [[Documentation/How_Tos/Calc:_STDEVP_function|<div style="font-size: 120%;"> | + | * [[Documentation/How_Tos/Calc:_STDEVP_function|<div style="font-size: 120%;">Stdevp]] |
− | * [[Documentation/How_Tos/Calc:_STDEVPA_function|<div style="font-size: 120%;"> | + | * [[Documentation/How_Tos/Calc:_STDEVPA_function|<div style="font-size: 120%;">Stdevpa]] |
− | * [[Documentation/How_Tos/Calc:_VAR_function|<div style="font-size: 120%;"> | + | * [[Documentation/How_Tos/Calc:_VAR_function|<div style="font-size: 120%;">Var]] |
− | * [[Documentation/How_Tos/Calc:_VARA_function|<div style="font-size: 120%;"> | + | * [[Documentation/How_Tos/Calc:_VARA_function|<div style="font-size: 120%;">Vara]] |
− | + | * [[Documentation/How_Tos/Calc:_VARP_function|<div style="font-size: 120%;">Varp]] | |
− | * [[Documentation/How_Tos/Calc:_VARP_function|<div style="font-size: 120%;"> | + | * [[Documentation/How_Tos/Calc:_VARPA_function|<div style="font-size: 120%;">Varpa]] |
− | * [[Documentation/How_Tos/Calc:_VARPA_function|<div style="font-size: 120%;"> | + | |
− | + | ||
− | + | ||
<div style="font-size: 140%; border-style: outset outset outset none; border-color:#DCE9FC;">Probability and statistics</div> | <div style="font-size: 140%; border-style: outset outset outset none; border-color:#DCE9FC;">Probability and statistics</div> | ||
− | + | * [[Documentation/How_Tos/Calc:_B_function|<div style="font-size: 120%;">B]] | |
− | * [[Documentation/How_Tos/Calc:_B_function|<div style="font-size: 120%;"> | + | * [[Documentation/How_Tos/Calc:_BETADIST_function|<div style="font-size: 120%;">Betadist]] |
− | * [[Documentation/How_Tos/Calc:_BETADIST_function|<div style="font-size: 120%;"> | + | * [[Documentation/How_Tos/Calc:_BETAINV_function|<div style="font-size: 120%;">Betainv]] |
− | * [[Documentation/How_Tos/Calc:_BETAINV_function|<div style="font-size: 120%;"> | + | * [[Documentation/How_Tos/Calc:_BINOMDIST_function|<div style="font-size: 120%;">Binomdist]] |
− | * [[Documentation/How_Tos/Calc:_BINOMDIST_function|<div style="font-size: 120%;"> | + | * [[Documentation/How_Tos/Calc:_CHIDIST_function|<div style="font-size: 120%;">Chidist]] |
− | * [[Documentation/How_Tos/Calc:_CHIDIST_function|<div style="font-size: 120%;"> | + | * [[Documentation/How_Tos/Calc:_CHIINV_function|<div style="font-size: 120%;">Chinv]] |
− | * [[Documentation/How_Tos/Calc:_CHIINV_function|<div style="font-size: 120%;"> | + | * [[Documentation/How_Tos/Calc:_CHISQINV_function|<div style="font-size: 120%;">Chisqinv]] |
− | * [[Documentation/How_Tos/Calc:_CHISQINV_function|<div style="font-size: 120%;"> | + | * [[Documentation/How_Tos/Calc:_CHITEST_function|<div style="font-size: 120%;">Chitest]] |
− | * [[Documentation/How_Tos/Calc:_CHITEST_function|<div style="font-size: 120%;"> | + | * [[Documentation/How_Tos/Calc:_CONFIDENCE_function|<div style="font-size: 120%;">Confidence]] |
− | * [[Documentation/How_Tos/Calc:_CONFIDENCE_function|<div style="font-size: 120%;"> | + | * [[Documentation/How_Tos/Calc:_CRITBINOM_function|<div style="font-size: 120%;">Critbinom]] |
− | + | * [[Documentation/How_Tos/Calc:_EXPONDIST_function|<div style="font-size: 120%;">Expondist]] | |
− | * [[Documentation/How_Tos/Calc:_CRITBINOM_function|<div style="font-size: 120%;"> | + | * [[Documentation/How_Tos/Calc:_FINV_function|<div style="font-size: 120%;">Finv]] |
− | * [[Documentation/How_Tos/Calc:_EXPONDIST_function|<div style="font-size: 120%;"> | + | * [[Documentation/How_Tos/Calc:_FISHER_function|<div style="font-size: 120%;">Fisher]] |
− | * [[Documentation/How_Tos/Calc:_FINV_function|<div style="font-size: 120%;"> | + | * [[Documentation/How_Tos/Calc:_FISHERINV_function|<div style="font-size: 120%;">Fisherinv]] |
− | * [[Documentation/How_Tos/Calc:_FISHER_function|<div style="font-size: 120%;"> | + | * [[Documentation/How_Tos/Calc:_FDIST_function|<div style="font-size: 120%;">Fdist]] |
− | * [[Documentation/How_Tos/Calc:_FISHERINV_function|<div style="font-size: 120%;"> | + | * [[Documentation/How_Tos/Calc:_FTEST_function|<div style="font-size: 120%;">Ftest]] |
− | * [[Documentation/How_Tos/Calc:_FDIST_function|<div style="font-size: 120%;"> | + | * [[Documentation/How_Tos/Calc:_GAMMA_function|<div style="font-size: 120%;">Gamma]] |
− | * [[Documentation/How_Tos/Calc:_FTEST_function|<div style="font-size: 120%;"> | + | * [[Documentation/How_Tos/Calc:_GAMMAINV_function|<div style="font-size: 120%;">Gammainv]] |
− | * [[Documentation/How_Tos/Calc:_GAMMA_function|<div style="font-size: 120%;"> | + | * [[Documentation/How_Tos/Calc:_GAMMALN_function|<div style="font-size: 120%;">Gammaln]] |
− | + | * [[Documentation/How_Tos/Calc:_GAMMADIST_function|<div style="font-size: 120%;">Gammadist]] | |
− | * [[Documentation/How_Tos/Calc:_GAMMAINV_function|<div style="font-size: 120%;"> | + | * [[Documentation/How_Tos/Calc:_GAUSS_function|<div style="font-size: 120%;">Gauss]] |
− | * [[Documentation/How_Tos/Calc:_GAMMALN_function|<div style="font-size: 120%;"> | + | * [[Documentation/How_Tos/Calc:_HYPGEOMDIST_function|<div style="font-size: 120%;">Hypgeomdist]] |
− | * [[Documentation/How_Tos/Calc:_GAMMADIST_function|<div style="font-size: 120%;"> | + | * [[Documentation/How_Tos/Calc:_LOGINV_function|<div style="font-size: 120%;">Loginv]] |
− | * [[Documentation/How_Tos/Calc:_GAUSS_function|<div style="font-size: 120%;"> | + | * [[Documentation/How_Tos/Calc:_LOGNORMDIST_function|<div style="font-size: 120%;">Lognormdist]] |
− | * [[Documentation/How_Tos/Calc:_HYPGEOMDIST_function|<div style="font-size: 120%;"> | + | * [[Documentation/How_Tos/Calc:_NEGBINOMDIST_function|<div style="font-size: 120%;">Negbinomdist]] |
− | * [[Documentation/How_Tos/Calc:_LOGINV_function|<div style="font-size: 120%;"> | + | * [[Documentation/How_Tos/Calc:_NORMINV_function|<div style="font-size: 120%;">Norminv]] |
− | * [[Documentation/How_Tos/Calc:_LOGNORMDIST_function|<div style="font-size: 120%;"> | + | * [[Documentation/How_Tos/Calc:_NORMDIST_function|<div style="font-size: 120%;">Normdist]] |
− | + | * [[Documentation/How_Tos/Calc:_NORMSINV_function|<div style="font-size: 120%;">Normsinv]] | |
− | * [[Documentation/How_Tos/Calc:_NEGBINOMDIST_function|<div style="font-size: 120%;"> | + | * [[Documentation/How_Tos/Calc:_NORMSDIST_function|<div style="font-size: 120%;">Normsdist]] |
− | + | * [[Documentation/How_Tos/Calc:_PERMUT_function|<div style="font-size: 120%;">Permut]] | |
− | * [[Documentation/How_Tos/Calc:_NORMINV_function|<div style="font-size: 120%;"> | + | * [[Documentation/How_Tos/Calc:_PERMUTATIONA_function|<div style="font-size: 120%;">Permutationa]] |
− | * [[Documentation/How_Tos/Calc:_NORMDIST_function|<div style="font-size: 120%;"> | + | * [[Documentation/How_Tos/Calc:_PHI_function|<div style="font-size: 120%;">Phi]] |
− | * [[Documentation/How_Tos/Calc:_NORMSINV_function|<div style="font-size: 120%;"> | + | * [[Documentation/How_Tos/Calc:_POISSON_function|<div style="font-size: 120%;">Poisson]] |
− | + | * [[Documentation/How_Tos/Calc:_PROB_function|<div style="font-size: 120%;">Prob]] | |
− | * [[Documentation/How_Tos/Calc:_NORMSDIST_function|<div style="font-size: 120%;"> | + | * [[Documentation/How_Tos/Calc:_STANDARDIZE_function|<div style="font-size: 120%;">Standardize]] |
− | + | * [[Documentation/How_Tos/Calc:_TDIST_function|<div style="font-size: 120%;">Tdist]] | |
− | * [[Documentation/How_Tos/Calc:_PERMUT_function|<div style="font-size: 120%;"> | + | * [[Documentation/How_Tos/Calc:_TINV_function|<div style="font-size: 120%;">Tinv]] |
− | * [[Documentation/How_Tos/Calc:_PERMUTATIONA_function|<div style="font-size: 120%;"> | + | * [[Documentation/How_Tos/Calc:_TTEST_function|<div style="font-size: 120%;">Ttest]] |
− | + | * [[Documentation/How_Tos/Calc:_WEIBULL_function|<div style="font-size: 120%;">Weibull]] | |
− | + | * [[Documentation/How_Tos/Calc:_ZTEST_function|<div style="font-size: 120%;">Ztest]] | |
− | * [[Documentation/How_Tos/Calc:_PHI_function|<div style="font-size: 120%;"> | + | |
− | * [[Documentation/How_Tos/Calc:_POISSON_function|<div style="font-size: 120%;"> | + | |
− | + | ||
− | * [[Documentation/How_Tos/Calc:_PROB_function|<div style="font-size: 120%;"> | + | |
− | + | ||
− | * [[Documentation/How_Tos/Calc:_STANDARDIZE_function|<div style="font-size: 120%;"> | + | |
− | * [[Documentation/How_Tos/Calc:_TDIST_function|<div style="font-size: 120%;"> | + | |
− | + | ||
− | + | ||
− | + | ||
− | * [[Documentation/How_Tos/Calc:_TINV_function|<div style="font-size: 120%;"> | + | |
− | * [[Documentation/How_Tos/Calc:_TTEST_function|<div style="font-size: 120%;"> | + | |
− | * [[Documentation/How_Tos/Calc:_WEIBULL_function|<div style="font-size: 120%;"> | + | |
− | + | ||
− | * [[Documentation/How_Tos/Calc:_ZTEST_function|<div style="font-size: 120%;"> | + | |
<div style="font-size: 140%; border-style: outset outset outset none; border-color:#DCE9FC;">Correlation and line fitting</div> | <div style="font-size: 140%; border-style: outset outset outset none; border-color:#DCE9FC;">Correlation and line fitting</div> | ||
+ | * [[Documentation/How_Tos/Calc:_CORREL_function|<div style="font-size: 120%;">Correl]] | ||
+ | * [[Documentation/How_Tos/Calc:_COVAR_function|<div style="font-size: 120%;">Covar]] | ||
+ | * [[Documentation/How_Tos/Calc:_FORECAST_function|<div style="font-size: 120%;">Forecast]] | ||
+ | * [[Documentation/How_Tos/Calc:_INTERCEPT_function|<div style="font-size: 120%;">Intercept]] | ||
+ | * [[Documentation/How_Tos/Calc:_PEARSON_function|<div style="font-size: 120%;">Pearson]] | ||
+ | * [[Documentation/How_Tos/Calc:_RSQ_function|<div style="font-size: 120%;">Rsq]] | ||
+ | * [[Documentation/How_Tos/Calc:_SLOPEL_function|<div style="font-size: 120%;">Slopel]] | ||
+ | * [[Documentation/How_Tos/Calc:_STEYX_function|<div style="font-size: 120%;">Steyx]] | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
<div style="font-size: 140%; border-style: bloc; border-color:#DCE9FC;">''See also (in the [[Documentation/How_Tos/Calc:_Array_functions|Array Function]] category); GROWTH, LINEST, LOGEST, TREND''</div> | <div style="font-size: 140%; border-style: bloc; border-color:#DCE9FC;">''See also (in the [[Documentation/How_Tos/Calc:_Array_functions|Array Function]] category); GROWTH, LINEST, LOGEST, TREND''</div> | ||
Line 126: | Line 92: | ||
* [[Documentation/How_Tos/Calc:_LARGE_function|<div style="font-size: 120%;">Large]] | * [[Documentation/How_Tos/Calc:_LARGE_function|<div style="font-size: 120%;">Large]] | ||
* [[Documentation/How_Tos/Calc:_MAX_function|<div style="font-size: 120%;">Max]] | * [[Documentation/How_Tos/Calc:_MAX_function|<div style="font-size: 120%;">Max]] | ||
− | |||
− | |||
− | |||
− | |||
− | |||
* [[Documentation/How_Tos/Calc:_MAXA_function|<div style="font-size: 120%;">Maxa]] | * [[Documentation/How_Tos/Calc:_MAXA_function|<div style="font-size: 120%;">Maxa]] | ||
* [[Documentation/How_Tos/Calc:_MIN_function|<div style="font-size: 120%;">Min]] | * [[Documentation/How_Tos/Calc:_MIN_function|<div style="font-size: 120%;">Min]] | ||
* [[Documentation/How_Tos/Calc:_MINA_function|<div style="font-size: 120%;">Mina]] | * [[Documentation/How_Tos/Calc:_MINA_function|<div style="font-size: 120%;">Mina]] | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
* [[Documentation/How_Tos/Calc:_PERCENTILE_function|<div style="font-size: 120%;">Percentile]] | * [[Documentation/How_Tos/Calc:_PERCENTILE_function|<div style="font-size: 120%;">Percentile]] | ||
* [[Documentation/How_Tos/Calc:_PERCENTRANK_function|<div style="font-size: 120%;">Percentrank]] | * [[Documentation/How_Tos/Calc:_PERCENTRANK_function|<div style="font-size: 120%;">Percentrank]] | ||
* [[Documentation/How_Tos/Calc:_QUARTILE_function|<div style="font-size: 120%;">Quartile]] | * [[Documentation/How_Tos/Calc:_QUARTILE_function|<div style="font-size: 120%;">Quartile]] | ||
− | |||
− | |||
− | |||
− | |||
− | |||
* [[Documentation/How_Tos/Calc:_RANK_function|<div style="font-size: 120%;">Rank]] | * [[Documentation/How_Tos/Calc:_RANK_function|<div style="font-size: 120%;">Rank]] | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
* [[Documentation/How_Tos/Calc:_SMALL_function|<div style="font-size: 120%;">Small]] | * [[Documentation/How_Tos/Calc:_SMALL_function|<div style="font-size: 120%;">Small]] | ||
}} | }} |