Documentation/Calc Functions/CHISQ.DIST

From The Document Foundation Wiki
Jump to navigation Jump to search


Function name:

CHISQ.DIST

Category:

Statistical Analysis

Summary:

Returns the right-tailed probability density function or the cumulative distribution function for the chi-square distribution.

Syntax:

CHISQ.DIST(Number; DegreesFreedom; Cumulative)

Returns:

Returns a real number which is the right-tailed 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.

DegreesFreedom 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 the function returns an error value.
  • 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 formula for CHISQ.DIST is:

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

Chisq.dist.png

for x>0.

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

Chidist.png

for x>0

Here x is the Number and n is the DegreesFreedom.

For more details on chi-square distribution, visit Wikipedia.

Examples:

Formula Description Returns
=CHISQ.DIST(3; 2; 0) The probability density function with 2 degrees of freedom, at Number = 3. 0.1115650801
=CHISQ.DIST(3; 2; 1) The cumulative chi-square distribution with 2 degrees of freedom, at the value Number = 3. 0.7768698399
=CHISQ.DIST(-3; 2; 0) Number is less than 0 hence the function returns an error value Err:502

Related LibreOffice functions:

CHIINV

CHISQDIST

CHISQ.DIST.RT

CHISQ.INV

CHISQ.INV.RT

CHISQ.TEST

CHISQDIST

CHISQINV

CHITEST

ODF standard:

None

Equivalent Excel functions:

CHISQ.DIST