Home › Functions › Statistical › =CHISQ.DIST.RT()
Statistical Excel 2010 ◉ 53 views

=CHISQ.DIST.RT()

Returns the right-tailed probability of the chi-squared distribution. The χ2 distribution is associated with a χ2 test. Use the χ2 test to compare observed and expected values. For example, a genetic experiment might hypothesize that the next generation of plants will exhibit a certain set of colors. By comparing the observed results with the expected ones, you can decide whether your original hypothesis is valid.

Applies To: Excel for Microsoft 365Excel for Microsoft 365 for MacExcel 2024Excel 2024 for MacExcel 2021Excel 2021 for MacExcel 2019Excel 2016
=CHISQ.DIST.RT(x,deg_freedom)
Hover argument names in the table for details.
Output typeNumber
Popularity8 / 100
VolatileNo
Dynamic ArrayNo
Download sample .xlsx ▦ Try in Playground Dedicated file for this function — safe & lightweight · sample data + live formulas
Share:

⬇ Download Sample Workbook

A dedicated .xlsx for =CHISQ.DIST.RT() with Persian sample data & live formulas — open in Excel and practice.

  • Sheet “Sample” — data table + formula in place
  • Sheet “Guide” — syntax, arguments & tips from this page
  • Instant & secure (token + rate limit)
Download CHISQ.DIST.RT.xlsx ~ 8–12 KB · No macros

⇪ Share

Send this function to friends

Quiz this function

%d questions — syntax, example & errors — test yourself!

◧ Arguments

ArgumentTypeRequiredDescription
x Number Required The value at which you want to evaluate the distribution.
deg_freedom Number Required The number of degrees of freedom.

▣ Examples

▦ Data
CellValueDescription
A2 18.307 Value at which you want to evaluate the distribution
A3 10 Degrees of freedom
A4 18.307 Value at which you want to evaluate the distribution
A5 10 Degrees of freedom
One-tailed probability of the chi-squared distribution, for the arguments specified in A2 and A3. =CHISQ.DIST.RT(A2,A3)
Result: 0.0500006

§ Remarks

  • If either argument is nonnumeric, CHISQ.DIST.RT function returns the #VALUE! error value.
  • If any argument is nonnumeric, CHISQ.DIST.RT function returns the #VALUE! error value.
  • If deg_freedom is not an integer, it is truncated.
  • If deg_freedom < 1 or deg_freedom > 10^10, CHISQ.DIST.RT returns the #NUM! error value.

✦ Tips

  • If deg_freedom is not an integer, it is truncated.

⚠ Common Errors

#VALUE! If either argument is nonnumeric, CHISQ.DIST.RT function returns the #VALUE! error value. If any argument is nonnumeric, CHISQ.DIST.RT function returns the #VALUE! error value.
Fix: برای هر دو آرگومان مقدار عددی وارد کنید.
#NUM! If deg_freedom < 1 or deg_freedom > 10^10, CHISQ.DIST.RT returns the #NUM! error value.
Fix: Correct the input value

⇄ Related Functions

=CHISQ.DIST() Returns the chi-squared distribution. The chi-squared distribution is commonly used to study variation in the percentage of something across samples, such as the fraction of the day people spend watching television. =CHISQ.INV.RT() Returns the inverse of the right-tailed probability of the chi-squared distribution. If probability = CHISQ.DIST.RT(x,...), then CHISQ.INV.RT(probability,...) = x. Use this function to compare observed results with expected ones in order to decide whether your original hypothesis is valid. =CHISQ.TEST() The CHISQ.TEXT function returns the test for independence. It returns the value from the chi-squared (χ2) distribution for the statistic and the appropriate degrees of freedom. You can use χ2 tests to determine whether hypothesized results are verified by an experiment.

💬 Comments & Q&A 0 approved

🔒 Your comment will be published after review.

Share your thoughts — visible after admin approval

No comments yet — be the first!

✍️ Add comment / question

captcha
🔒 Your comment will be published after review.