Documentation/Calc Functions/CHIDIST

Function name:
CHIDIST

Category:
Statistical Analysis

Summary:
Returns the right-tailed probability value from the indicated chi-square that a hypothesis is confirmed.

The function calculates the area under the chi-square probability density function curve to the right of the specified chi-square value.

CHIDIST compares the chi-square value to be given for a random sample that is calculated from the sum of (observed value-expected value)^2/expected value for all values with the theoretical chi-square distribution and determines from this the probability of error for the hypothesis to be tested.

Syntax:
CHIDIST(Number; DegreesFreedom)

Returns:
Return a real number which is a right-tailed probability of the chi-square distribution. It is a probability hence it ranges from 0 to 1,i.e. [0,1].

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.

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


 * 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 uses its floor value, i.e. it is truncated to an integer.

Additional details:
The probability determined by CHIDIST can also be determined by CHITEST.

The formula for Chi distribution is:

where x>0 and returns 1 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/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/CHISQDIST CHISQDIST]

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

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

ODF standard:
Section 6.18.11

Equivalent Excel functions:
CHIDIST