CHISQ.DIST.RT
Formulas / CHISQ.DIST.RTCalculate 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.
