Documentation/How Tos/Calc: CHISQDIST function

This function is not yet implemented but expected for OpenOffice.org version 3.1.

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 values of the probability density function for the χ²-distribution:

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

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.

In the density case the internal calculation uses logarithmic- and exponential function, if x >1425 or x · k > 1391000. The results are less accurate in those cases.

See also:

CHISQINV, LEGACY.CHIDIST, LEGACY.CHIINV, CHITEST

Statistical functions

Functions listed alphabetically, Functions listed by category

Issues:

This function is not available in version 3.0 and earlier.