Documentation/Calc Functions/CHISQ.DIST.RT

From The Document Foundation Wiki
Jump to navigation Jump to search


Function name:

CHISQ.DIST.RT

Category:

Statistical Analysis

Summary:

Returns the probability value from the indicated Chi-square that a hypothesis is confirmed.

CHISQ.DIST.RT 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:

CHISQ.DIST.RT(Number; DegreesFreedom)

Returns:

Return a real number which is a right-tailed probability of the chi-squared 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 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 truncates it in an integer.

Additional details:

The probability determined by CHI.DIST.RT can also be determined by CHITEST.

The formula for Chi distribution is:

Chidist.png

where x>0 and returns 1 for x = 0 and an error value for x<0. Here x is the Number and n is the DegreesFreedom.

For more details on Chi distribution, visit Wikipedia.

Examples:

Formula Description Returns
=CHISQ.DIST.RT(13.27;5) If the Chi square value of the random sample is 13.27 and if the experiment has 5 degrees of freedom, then the hypothesis is assured with a probability of error of about 2%. 0.020975769403022
=CHISQ.DIST.RT(-13.27;5) Number is less than 0 so the function returns an error value Err:502

Related LibreOffice functions:

CHIDIST

CHIINV

CHISQ.DIST

CHISQ.INV

CHISQ.INV.RT

CHISQ.TEST

CHISQDIST

CHISQINV

CHITEST

ODF standard:

None

Equivalent Excel functions:

CHISQ.DIST.RT