Difference between revisions of "User:Regina"

From Apache OpenOffice Wiki
Jump to: navigation, search
(Semantic)
Line 71: Line 71:
 
=== Issues: ===
 
=== Issues: ===
 
This function is expected for OOo3.1
 
This function is expected for OOo3.1
 +
 +
__NOTOC__
 +
 +
== CHISQINV ==
 +
Calculates the inverse of the CHISQDIST function.
 +
 +
=== Syntax ===
 +
<tt>'''CHISQINV(p; k)'''</tt>
 +
: <tt>'''k'''</tt> is the (positive integer) degrees of freedom for the &chi;<sup>2</sup>-distribution.
 +
 +
: <tt>'''p'''</tt> is the given probability, a number with <math>0 \le p<1</math>
 +
 +
=== Semantic ===
 +
 +
: <tt>'''CHISQINV(p; k)'''</tt> returns the value <tt>'''x'''</tt>, such that <tt>'''CHIDIST(x; k;TRUE())'''</tt> is <tt>'''p'''</tt>.
 +
 +
=== Example ===
 +
<tt>'''CHISQINV(0.5724; 3)'''</tt>
 +
: returns approximately 2.
 +
 +
=== See also: ===
 +
[[Documentation/How_Tos/Calc: CHISQDIST function|'''CHISQDIST''']]
 +
[[Documentation/How_Tos/Calc: CHIDIST function|'''CHIDIST''']]
 +
[[Documentation/How_Tos/Calc: CHIINV function|'''CHIINV''']]
 +
 +
[[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 21:19, 27 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.

Semantic

CHISQDIST(x; k; FALSE()) returns the probability density function for the χ2-distribution:

and

CHISQDIST(x; df; TRUE()) returns the left tail probability for the χ2-distribution:

and

Semantic with forced pictures

CHISQDIST(x; k; FALSE()) returns the probability density function for the χ2-distribution:

and

CHISQDIST(x; df; TRUE()) returns the left tail probability for the χ2-distribution:

and

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


CHISQINV

Calculates the inverse of the CHISQDIST function.

Syntax

CHISQINV(p; k)

k is the (positive integer) degrees of freedom for the χ2-distribution.
p is the given probability, a number with

Semantic

CHISQINV(p; k) returns the value x, such that CHIDIST(x; k;TRUE()) is p.

Example

CHISQINV(0.5724; 3)

returns approximately 2.

See also:

CHISQDIST CHIDIST CHIINV

Statistical functions

Functions listed alphabetically, Functions listed by category

Issues:

  • This function is expected for OOo3.1
Personal tools