|
|
Line 1: |
Line 1: |
− | {{Documentation/MasterTOC | + | {{DISPLAYTITLE:BETADIST function}} |
− | |bookid=1234'''
| + | {{Documentation/CalcFunc StatisticalTOC |
− | |booktitle=<div style="padding: 8px; font-size: 140%; font-weight: bold; background-color: #9BC0F5;">CALC FUNCTIONS</div>
| + | |ShowPrevNext=block |
− | |ShowParttitle=block|parttitle=[[Documentation/How_Tos/Calc:_Statistical_functions|<div style="font-size: 140%;">Statistical Functions]]
| + | |PrevPage=Documentation/How_Tos/Calc:_B_function |
− | |ShowNextPage=block|NextPage=Documentation/How_Tos/Calc:_BETAINV_function | + | |NextPage=Documentation/How_Tos/Calc:_BETAINV_function |
− | |ShowPrevPage=block|PrevPage=Documentation/How_Tos/Calc:_B_function
| + | }}__NOTOC__ |
− | |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%; border-style: double; border-color:#778899;">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%;">Chinv]]
| |
− | * [[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%;">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__ | |
| | | |
| == BETADIST == | | == BETADIST == |
Line 120: |
Line 26: |
| Constraints: | | Constraints: |
| # α > 0 , β > 0 , a < b | | # α > 0 , β > 0 , a < b |
− | # If α < 1, than the density function has a pole at x = a. | + | # If α < 1, then the density function has a pole at x = a. |
− | # If β < 1, than the density function has a pole at x = b. | + | # If β < 1, then the density function has a pole at x = b. |
| | | |
| === Semantic === | | === Semantic === |
FUNCTIONS
Spreadsheet Lookup functions
Measures of dispersion / spread
Probability and statistics
Correlation and line fitting
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
|
}}
>
|
BETADIST
Calculates the cumulative distribution function or the probability density function of a beta distribution.
Syntax
BETADIST(x; α; β; a; b; cumulative)
The beta distribution is a family of continuous probability distributions, where α and β are parameters controlling the shape of the distribution.
x is the number, at which you will evaluate the Beta distribution.
The parameters a and b are lower and upper bounds of the distribution. You can interpret the value a as location and the value b−a as scale.
a and b are optional parameters which default (if omitted) to 0 and 1.
cumulative is an optional, logical parameter which defaults to TRUE() if omitted.
Before OOo version 3.1 the parameter cumulative doesn't exist and only the cumulative probability function is calculated.
Constraints:
- α > 0 , β > 0 , a < b
- If α < 1, then the density function has a pole at x = a.
- If β < 1, then the density function has a pole at x = b.
Semantic
For cumulative = FALSE() the function BETADIST calculates the probability density function (besides the constraints given above):
For cumulative = TRUE() the function BETADIST calculates the cumulative distribution function:
Notice, that
where
and is the regularized incomplete Beta function.
Example
BETADIST(1;5;3;-2;4;FALSE())
- returns approximately 0.273
|
|
BETADIST(0.2;0.7;4;0;1;FALSE())
- returns approximately 1.644
|
|
BETADIST(1;1;0.5;0;1;FALSE())
- returns Invalid argument because there is a pole
BETADIST(1.1;1;0.5;0;1;FALSE())
- returns 0
|
|
BETADIST(1;5;3;-2;4;TRUE())
- returns approximately 0.227
call before version 3.1: BETADIST(1;5;3;-2;4)
|
|
BETADIST(0.2;0.7;4;0;1;TRUE())
- returns approximately 0.718
call before version 3.1: BETADIST(0.2;0.7:4;0;1)
other valid call: BETADIST(0.2;0.7;4)
|
|
BETADIST(1.1;1;0.5;0;1;TRUE())
- returns 1
before version 3.1: BETADIST(1.1;1;0.5;0;1)
- returns Invalid argument
|
|
{{#switch:EN
| RU = Смотрите также:
| UA = Дивіться також:
| EN = See Also
| PT = Ver também
| #default = See Also
}}