Syntax
CHISQ.DIST.RT(x, deg_freedom)
| Parameter | Description |
|---|---|
| x | Parameter of the CHISQ.DIST.RT function. |
| deg_freedom | Parameter of the CHISQ.DIST.RT function. |
Examples
Test of independence p-value
Formula
=CHISQ.DIST.RT(9.49, 4)
Returns ~0.0500. A chi-squared value of 9.49 with 4 df is right at the 5% critical threshold.
Variance test
Formula
=CHISQ.DIST.RT(35, 20)
Returns ~0.0203. Testing whether a sample variance significantly exceeds the hypothesized variance with 20 df yields a significant result.
Weak evidence against null
Formula
=CHISQ.DIST.RT(3.2, 5)
Returns ~0.6694. A p-value of 67% means the observed data is consistent with the null hypothesis.
Common Errors
#NUM!
x must be non-negative and degrees of freedom must be at least 1.
#VALUE!
Occurs when arguments are non-numeric.
Tips
Most practical chi-squared function
For hypothesis testing, CHISQ.DIST.RT gives you the p-value directly without needing to subtract from 1.
Calculating degrees of freedom
For a test of independence on an r x c contingency table, df = (r-1)(c-1). For a goodness-of-fit test, df = number of categories - 1.
Critical value lookup
To find the critical chi-squared value at a given significance level, use CHISQ.INV.RT(alpha, df) instead.
Try CHISQ.DIST.RT in Viztab
Import your data and use CHISQ.DIST.RT with 370+ other formulas. No signup required.
Open Viztab