Difference between revisions of "User:Regina"
From Apache OpenOffice Wiki
(draft) |
|||
Line 6: | Line 6: | ||
[[Anleitung]] | [[Anleitung]] | ||
+ | |||
+ | ==Sandbox== | ||
+ | |||
+ | __NOTOC__ | ||
+ | |||
+ | == CHISQDIST == | ||
+ | Calculates values for a χ<sup>2</sup>-distribution. | ||
+ | |||
+ | === Syntax === | ||
+ | <tt>'''CHISQDIST(x; k; Cumulative)'''</tt> | ||
+ | |||
+ | : <tt>'''x'''</tt> is a number. | ||
+ | |||
+ | : <tt>'''k'''</tt> is the (positive integer) degrees of freedom for the χ<sup>2</sup>-distribution. | ||
+ | |||
+ | : <tt>'''Cumulative'''</tt> is a logical value. In the case Cumulative=TRUE() the cumulative distribution function is used, in the case Cumulative=FALSE() the probability density function. This parameter is optional. It is set to TRUE() if missing. | ||
+ | |||
+ | === Formulas === | ||
+ | |||
+ | <tt>'''CHISQDIST(x; k; FALSE())'''</tt> returns the probability density function for the χ<sup>2</sup>-distribution: | ||
+ | |||
+ | :<math> 0 \; \mbox{if }x < 0 </math> | ||
+ | |||
+ | :<math> \frac {x^{\frac k 2 -1}\,e^{- \frac x 2}} {2^{\frac k 2}\,\Gamma(\frac k 2) } \; \mbox{if }x \ge 0 </math> | ||
+ | |||
+ | <tt>'''CHISQDIST(x; df; TRUE())'''</tt> returns the left tail probability for the χ<sup>2</sup>-distribution: | ||
+ | :<math>0</math> for <math>x<0</math> | ||
+ | and | ||
+ | :<math> \int_x^{\infty} \frac {t^{\frac k 2 -1}\,e^{- \frac t 2}} {2^{\frac k 2}\,\Gamma(\frac k 2) }\,dt</math> for <math>x \ge 0</math> | ||
+ | |||
+ | === Example === | ||
+ | <tt>'''CHSQDIST(2.7; 3;FALSE())'''</tt> | ||
+ | : returns approximately 0.1699395239 | ||
+ | |||
+ | <tt>'''CHSQDIST(2.7; 3;TRUE())'''</tt> | ||
+ | : returns approximately 0.5597727056 | ||
+ | |||
+ | . | ||
+ | |||
+ | === See also: === | ||
+ | [[Documentation/How_Tos/Calc: CHISQINV function|'''CHISQINV''']], | ||
+ | [[Documentation/How_Tos/Calc: CHIDIST function|'''LEGACY.CHIDIST''']], | ||
+ | [[Documentation/How_Tos/Calc: CHIINV function|'''LEGACY.CHIINV''']], | ||
+ | [[Documentation/How_Tos/Calc: CHITEST function|'''CHITEST''']] | ||
+ | |||
+ | [[Documentation/How_Tos/Calc: Statistical functions|'''Statistical functions''']] | ||
+ | |||
+ | [[Documentation/How_Tos/Calc: Functions listed alphabetically|'''Functions listed alphabetically''']], | ||
+ | [[Documentation/How_Tos/Calc: Functions listed by category|'''Functions listed by category''']] | ||
+ | |||
+ | === Issues: === | ||
+ | This function is expected for OOo3.1 |
Revision as of 22:35, 26 September 2008
- native language
- German
- active in project
- de, qa. sc
- OOo user name
- regina
- special interest
- www.ooowiki.de
Sandbox
CHISQDIST
Calculates values for a χ2-distribution.
Syntax
CHISQDIST(x; k; Cumulative)
- x is a number.
- k is the (positive integer) degrees of freedom for the χ2-distribution.
- Cumulative is a logical value. In the case Cumulative=TRUE() the cumulative distribution function is used, in the case Cumulative=FALSE() the probability density function. This parameter is optional. It is set to TRUE() if missing.
Formulas
CHISQDIST(x; k; FALSE()) returns the probability density function for the χ2-distribution:
CHISQDIST(x; df; TRUE()) returns the left tail probability for the χ2-distribution:
- for
and
- for
Example
CHSQDIST(2.7; 3;FALSE())
- returns approximately 0.1699395239
CHSQDIST(2.7; 3;TRUE())
- returns approximately 0.5597727056
.
See also:
CHISQINV, LEGACY.CHIDIST, LEGACY.CHIINV, CHITEST
Functions listed alphabetically, Functions listed by category
Issues:
This function is expected for OOo3.1