CHISQ.DIST.RT

Formulas / CHISQ.DIST.RT
Calculate the right-tailed probability for the chi-squared distribution.
=CHISQ.DIST.RT(x,deg_freedom)
  • x - [REQUIRED] the value to evaluate the distribution on
  • deg_freedom - [REQUIRED] the number of degrees of freedom

Examples

  • =CHISQ.DIST.RT(5, 8)

    This would return the probability of the chi-squared distribution with 5 degrees of freedom and a chi-square statistic of 8.

  • =CHISQ.DIST.RT(2, 5)

    This would return the probability of the chi-squared distribution with 2 degrees of freedom and a chi-square statistic of 5.


Summary

The CHISQ.DIST.RT function returns the right-tailed probability of the chi-squared distribution, which is commonly used in a χ2 test. It will throw an error if any of the arguments are not a number.

  • CHISQ.DIST.RT calculates the right-tailed probability for the chi-squared distribution, which is used in a χ2 test.
  • The function returns an error value if any argument is not numeric and truncates deg_freedom if it is not an integer.
  • CHISQ.DIST.RT also returns the #NUM! error value if deg_freedom is greater than 10^10 or less than 1.

Frequently Asked Questions

What is the CHISQ.DIST.RT function?
The CHISQ.DIST.RT function returns the right-tailed probability of the chi-squared distribution.
What is the chi-squared distribution used for?
The chi-squared distribution is used in a χ2 test.
What is a χ2 test?
A χ2 test compares observed and expected values.
What happens if I give the CHISQ.DIST.RT function non-numeric arguments?
The CHISQ.DIST.RT function returns an error if any argument is not numeric.
What happens if I give the CHISQ.DIST.RT function non-integer deg_freedom?
The CHISQ.DIST.RT function truncates deg_freedom if it is not an integer.
What happens if I give the CHISQ.DIST.RT function deg_freedom that is too small or too large?
The CHISQ.DIST.RT function throws an error if deg_freedom is less than 1 or greater than 10^10.

Related Functions

Sourcetable Logo

Work smarter

Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.

Drop CSV