CHISQ.DIST.RT Function

Returns the right-tailed chi-square distribution — a chi-square test p-value.

Category

Statistical

Available in

Excel 2010+, Microsoft 365

Returns

A number

Want to practice CHISQ.DIST.RT in a real spreadsheet? Open a blank sheet in our Practice Sandbox and try it with live data, with the AI Excel tutor beside you. No Excel needed — just a free account.Try it free in the Sandbox

Overview

The chi-square distribution describes sums of squared differences — it underlies tests of whether counts match what you expected and of whether two categories are related. It's always positive and skewed to the right.

CHISQ.DIST.RT returns the probability of a value greater than x: the p-value for a chi-square statistic you've calculated yourself. A p-value is the chance of seeing a difference at least this big if there were really no difference. Below 0.05 is the usual cut-off for calling a result statistically significant.

Syntax

=CHISQ.DIST.RT(x, deg_freedom) Explain

Arguments

ArgumentRequired?What it does
xYesThe chi-square statistic; can't be negative.
deg_freedomYesDegrees of freedom — usually the sample size minus 1 (decimals are truncated); must be at least 1.

Examples

Example 1 — Are tickets spread evenly across the week?

120 support tickets would be 24 a day if spread evenly. The statistic adds up (observed − expected)² ÷ expected.

E2fx=SUMPRODUCT((B2:B6-C2:C6)^2/C2:C6)
ABCDE
1DayTicketsExpectedMeasureResult
2Mon2824Statistic3.75
3Tue2224p-value0.4409
4Wed1924
5Thu2124
6Fri3024
=SUMPRODUCT((B2:B6-C2:C6)^2/C2:C6) Explain

With 5 days there are 4 degrees of freedom. p ≈ 0.44, so the busier Monday and Friday could easily be chance — the same answer CHISQ.TEST gives in one step.

Common mistakes

  • #NUM! x is negative, or deg_freedom is less than 1.
  • Degrees of freedom. For a list of categories it's the count minus 1; for a table, (rows − 1) × (columns − 1).

Notes

Kyle Stott

Author

Kyle Stott

Certified Microsoft Excel Expert

Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.