Difference between revisions of "User:Regina"

Revision as of 22:12, 30 September 2008 (view source) Regina (Talk | contribs) (→‎Syntax) ← Older edit		Revision as of 22:26, 30 September 2008 (view source) Regina (Talk | contribs) Newer edit →
Line 59:		Line 59:
	: returns approximately 0.5597727056		: returns approximately 0.5597727056
−	.	+	=== Remarks ===
		+
		+	If you need <tt>CHISQDIST(x;k;TRUE())</tt> with a non integer parameter k, then use <tt>GAMMADIST(x;k/2;2)</tt> instead.
	=== See also: ===		=== See also: ===

---

Revision as of 22:26, 30 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 χ²-distribution.

Syntax

CHISQDIST(x; k; Cumulative)

x is the number, at which you will evaluate the χ²-distribution.

k sets the degrees of freedom for the χ²-distribution

Constraint: k must be a positive integer

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 χ²-distribution:

and

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

and

Semantic with forced pictures

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

and

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

and

Example

CHSQDIST(2.7;3;FALSE())

returns approximately 0.1699395239

CHSQDIST(2.7;3;TRUE())

returns approximately 0.5597727056

Remarks

If you need CHISQDIST(x;k;TRUE()) with a non integer parameter k, then use GAMMADIST(x;k/2;2) instead.

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 degrees of freedom for the χ²-distribution.

Constraint: k must be a positive integer

p is the given probability

Constraint: 0 ≤ p < 1

Semantic

CHISQINV(p; k) returns the value x, such that CHISQDIST(x; k;TRUE()) = 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

GAMMA

Returns the values of the Gamma function.

Syntax

GAMMA(x)

x is a number.

Constraint: If x is an integer, then x must be positive.

Semantic

GAMMA(x) calculates

.

Example

GAMMA(4) = 6.0 exact

GAMMA(34.56) ≈ 6.2336323276E+037

GAMMA(−4) not defined

Remarks

For x < 0.5 Eulers reflection formula is used.

The Gamma function has poles for negative integers and for zero. Near the poles the values are less accurate and will overflow easily.

If x is a positive integer, then

But be aware, that OpenOffice.org has only a precision of 15 digits, therefore the results for x > 21 are rounded.

See also:

GAMMALN, GAMMADIST, GAMMAINV, FACT

Mathematical functions

Statistical functions

Functions listed alphabetically, Functions listed by category

Issues:

This function is expected for OOo3.1.