Documentation/Calc Functions/CHISQDIST

Function name:
CHISQDIST

Category:
Statistical Analysis

Summary:
Returns the value of the probability density function or the cumulative distribution function for the chi-square distribution.

Syntax:
CHISQDIST(Number; Degrees Of Freedom[; Cumulative])

Returns:
Returns a real number which is the chi-square distribution value for the given arguments. The function returns either a probability density function or cumulative distribution function which has a non-negative range, i.e. [0, +∞).

Arguments:
Number is a real number or a reference to the cell containing that number which is the chi-square value of the random sample used to determine the error probability.

Degrees Of Freedom is a positive integer or a reference to a cell containing that number which is the degrees of freedom of the experiment.

Cumulative can be 0 or False to calculate the probability density function. It can be any other value or True to calculate the cumulative distribution function.


 * If Number is less than or equal to 0, then, for valid values of DegreesFreedom, the function returns 1.
 * If DegreesFreedom is less than 1, the function returns an error value.
 * If DegreesFreedom is a non-integer numeric value, then the function truncates it in an integer.
 * If argument Cumulative is not passed then, the function calculates the cumulative distribution.

Additional details:
The formula for CHISQ.DIST is:

If Cumulative is FALSE, CHISQDIST returns 0 for x<=0 and the value

for x>0.

If Cumulative is TRUE, CHISQDIST returns 0 for x<=0 and the value

for x>0

Here x is the Number and n is the DegreesFreedom.

For more details on Chi distribution, visit Wikipedia.

Related LibreOffice functions:
[[Special:MyLanguage/Documentation/Calc_Functions/CHIDIST CHIDIST]

[[Special:MyLanguage/Documentation/Calc_Functions/CHIINV CHIINV]

[[Special:MyLanguage/Documentation/Calc_Functions/CHISQ.DIST CHISQ.DIST]

[[Special:MyLanguage/Documentation/Calc_Functions/CHISQ.DIST.RT CHISQ.DIST.RT]

[[Special:MyLanguage/Documentation/Calc_Functions/CHISQ.INV CHISQ.INV]

[[Special:MyLanguage/Documentation/Calc_Functions/CHISQ.INV.RT CHISQ.INV.RT]

[[Special:MyLanguage/Documentation/Calc_Functions/CHISQ.TEST CHISQ.TEST]

[[Special:MyLanguage/Documentation/Calc_Functions/CHISQINV CHISQINV]

[[Special:MyLanguage/Documentation/Calc_Functions/CHITEST CHITEST]

ODF standard:
Section 6.18.12, part 2

Equivalent Excel functions:
CHISQDIST