Difference between revisions of "User:Regina"

From Apache OpenOffice Wiki
Jump to: navigation, search
(draft)
Line 6: Line 6:
  
 
[[Anleitung]]
 
[[Anleitung]]
 +
 +
==Sandbox==
 +
 +
__NOTOC__
 +
 +
== CHISQDIST ==
 +
Calculates values for a &chi;<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 &chi;<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 &chi;<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 &chi;<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


Anleitung

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

Statistical functions

Functions listed alphabetically, Functions listed by category

Issues:

This function is expected for OOo3.1

Personal tools