Difference between revisions of "Documentation/How Tos/Calc: FDIST function"
From Apache OpenOffice Wiki
< Documentation | How Tos
Javier Lopez (talk | contribs) |
|||
Line 1: | Line 1: | ||
[[ru:RU/kb/00000130]] | [[ru:RU/kb/00000130]] | ||
− | + | {{Documentation/MasterTOC | |
+ | |bookid=1234''' | ||
+ | |booktitle=<div style="padding: 8px; font-size: 140%; font-weight: bold; background-color: #9BC0F5;">CALC FUNCTIONS</div> | ||
+ | |ShowParttitle=block|parttitle=[[Documentation/How_Tos/Calc:_Statistical_functions|<div style="font-size: 140%;">Statistical Functions]] | ||
+ | |ShowNextPage=block|NextPage=Documentation/How_Tos/Calc:_FTEST_function | ||
+ | |ShowPrevPage=block|PrevPage=Documentation/How_Tos/Calc:_FISHERINV_function | ||
+ | |ShowPrevPart=block|PrevPart=Documentation/How_Tos/Calc:_Spreadsheet_functions | ||
+ | |ShowNextPart=block|NextPart=Documentation/How_Tos/Calc:_Text_functions | ||
+ | |toccontent= <div style="padding: 4px; font-size: 130%; font-weight: hidden; background-color:#DCE9FC;">FUNCTIONS</div> | ||
+ | |||
+ | <div style="font-size: 140%; border-style: outset outset outset none; border-color:#DCE9FC;">Measures of Central Tendency</div> | ||
+ | * [[Documentation/How_Tos/Calc:_AVEDEV_function|<div style="font-size: 120%;">Avedev]] | ||
+ | * [[Documentation/How_Tos/Calc:_AVERAGE_function|<div style="font-size: 120%;">Average]] | ||
+ | * [[Documentation/How_Tos/Calc:_AVERAGEA_function|<div style="font-size: 120%;">Averagea]] | ||
+ | * [[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:_GEOMEAN_function|<div style="font-size: 120%;">Geomean]] | ||
+ | * [[Documentation/How_Tos/Calc:_HARMEAN_function|<div style="font-size: 120%;">Hearmean]] | ||
+ | * [[Documentation/How_Tos/Calc:_MEDIAN_function|<div style="font-size: 120%;">Median]] | ||
+ | * [[Documentation/How_Tos/Calc:_MODE_function|<div style="font-size: 120%;">Mode]] | ||
+ | * [[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> | ||
+ | * [[Documentation/How_Tos/Calc:_DEVSQ_function|<div style="font-size: 120%;">Devsq]] | ||
+ | * [[Documentation/How_Tos/Calc:_KURT_function|<div style="font-size: 120%;">Kurt]] | ||
+ | * [[Documentation/How_Tos/Calc:_SKEW_function|<div style="font-size: 120%;">Skew]] | ||
+ | * [[Documentation/How_Tos/Calc:_STDEV_function|<div style="font-size: 120%;">Stdev]] | ||
+ | * [[Documentation/How_Tos/Calc:_STDEVA_function|<div style="font-size: 120%;">Stedeva]] | ||
+ | * [[Documentation/How_Tos/Calc:_STDEVP_function|<div style="font-size: 120%;">Stdevp]] | ||
+ | * [[Documentation/How_Tos/Calc:_STDEVPA_function|<div style="font-size: 120%;">Stdevpa]] | ||
+ | * [[Documentation/How_Tos/Calc:_VAR_function|<div style="font-size: 120%;">Var]] | ||
+ | * [[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:_VARPA_function|<div style="font-size: 120%;">Varpa]] | ||
+ | |||
+ | <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:_BETADIST_function|<div style="font-size: 120%;">Betadist]] | ||
+ | * [[Documentation/How_Tos/Calc:_BETAINV_function|<div style="font-size: 120%;">Betainv]] | ||
+ | * [[Documentation/How_Tos/Calc:_BINOMDIST_function|<div style="font-size: 120%;">Binomdist]] | ||
+ | * [[Documentation/How_Tos/Calc:_CHIDIST_function|<div style="font-size: 120%;">Chidist]] | ||
+ | * [[Documentation/How_Tos/Calc:_CHIINV_function|<div style="font-size: 120%;">Chiinv]] | ||
+ | * [[Documentation/How_Tos/Calc:_CHISQINV_function|<div style="font-size: 120%;">Chisqinv]] | ||
+ | * [[Documentation/How_Tos/Calc:_CHITEST_function|<div style="font-size: 120%;">Chitest]] | ||
+ | * [[Documentation/How_Tos/Calc:_CONFIDENCE_function|<div style="font-size: 120%;">Confidence]] | ||
+ | * [[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:_FINV_function|<div style="font-size: 120%;">Finv]] | ||
+ | * [[Documentation/How_Tos/Calc:_FISHER_function|<div style="font-size: 120%;">Fisher]] | ||
+ | * [[Documentation/How_Tos/Calc:_FISHERINV_function|<div style="font-size: 120%;">Fisherinv]] | ||
+ | * [[Documentation/How_Tos/Calc:_FDIST_function|<div style="font-size: 120%; border-style: double; border-color:#778899;">Fdist]] | ||
+ | * [[Documentation/How_Tos/Calc:_FTEST_function|<div style="font-size: 120%;">Ftest]] | ||
+ | * [[Documentation/How_Tos/Calc:_GAMMA_function|<div style="font-size: 120%;">Gamma]] | ||
+ | * [[Documentation/How_Tos/Calc:_GAMMAINV_function|<div style="font-size: 120%;">Gammainv]] | ||
+ | * [[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:_GAUSS_function|<div style="font-size: 120%;">Gauss]] | ||
+ | * [[Documentation/How_Tos/Calc:_HYPGEOMDIST_function|<div style="font-size: 120%;">Hypgeomdist]] | ||
+ | * [[Documentation/How_Tos/Calc:_LOGINV_function|<div style="font-size: 120%;">Loginv]] | ||
+ | * [[Documentation/How_Tos/Calc:_LOGNORMDIST_function|<div style="font-size: 120%;">Lognormdist]] | ||
+ | * [[Documentation/How_Tos/Calc:_NEGBINOMDIST_function|<div style="font-size: 120%;">Negbinomdist]] | ||
+ | * [[Documentation/How_Tos/Calc:_NORMINV_function|<div style="font-size: 120%;">Norminv]] | ||
+ | * [[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:_NORMSDIST_function|<div style="font-size: 120%;">Normsdist]] | ||
+ | * [[Documentation/How_Tos/Calc:_PERMUT_function|<div style="font-size: 120%;">Permut]] | ||
+ | * [[Documentation/How_Tos/Calc:_PERMUTATIONA_function|<div style="font-size: 120%;">Permutationa]] | ||
+ | * [[Documentation/How_Tos/Calc:_PHI_function|<div style="font-size: 120%;">Phi]] | ||
+ | * [[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:_STANDARDIZE_function|<div style="font-size: 120%;">Standardize]] | ||
+ | * [[Documentation/How_Tos/Calc:_TDIST_function|<div style="font-size: 120%;">Tdist]] | ||
+ | * [[Documentation/How_Tos/Calc:_TINV_function|<div style="font-size: 120%;">Tinv]] | ||
+ | * [[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]] | ||
+ | |||
+ | <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:_SLOPE_function|<div style="font-size: 120%;">Slope]] | ||
+ | * [[Documentation/How_Tos/Calc:_STEYX_function|<div style="font-size: 120%;">Steyx]] | ||
+ | <div style="font-size: 110%;">''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: outset outset outset none; border-color:#DCE9FC;">Ranking</div> | ||
+ | * [[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:_MAXA_function|<div style="font-size: 120%;">Maxa]] | ||
+ | * [[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:_PERCENTILE_function|<div style="font-size: 120%;">Percentile]] | ||
+ | * [[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:_RANK_function|<div style="font-size: 120%;">Rank]] | ||
+ | * [[Documentation/How_Tos/Calc:_SMALL_function|<div style="font-size: 120%;">Small]] | ||
+ | }}__TOC__ | ||
== FDIST == | == FDIST == |
Revision as of 23:28, 1 June 2013
CALC FUNCTIONS
Measures of Central Tendency
Measures of dispersion / spread
Probability and statistics
Correlation and line fitting
See also (in the Array Function category); GROWTH, LINEST, LOGEST, TREND
Ranking
< {{#switch:Previous Page | Previous Section = Previous Section | Next Section = Next Section | Previous Page = Previous Page | Next Page = Next Page | }} | {{#switch:Next Page | Previous Section = Previous Section | Next Section = Next Section | Previous Page = Previous Page | Next Page = Next Page | }} > |
FDIST
Calculates values for an F-distribution.
Syntax:
FDIST(x; r1; r2)
- r1 and r2, which are positive integers, are the degrees of freedom parameters for the F-distribution.
- x must be greater than or equal to 0.
- FDIST returns the area of the right tail of the probability density function for the F-distribution, calculating:
Example:
FDIST(1; 4; 5)
- returns approximately 0.485657.
Issues:
- The forthcoming international standard ODFF calls this function LEGACY.FDIST, and defines a new FDIST function.