CHISQ.DIST.RT in Collabora Office: Calculate a Chi-Square Right-Tail Probability
Use Collabora CHISQ.DIST.RT for the probability above a chi-square statistic, with explicit degrees of freedom and careful hypothesis-test interpretation.
Verification status: See the evidence and test scope described in this guide. How formula examples are checked
Quick answer: =CHISQ.DIST.RT(6;2) has independently expected result approximately 0.049787068. It is the probability of a chi-square value at least as large as six under a two-degree-of-freedom model.
Syntax and meaning of RT
=CHISQ.DIST.RT(Number; DegreesFreedom)
Number is the nonnegative chi-square evaluation point, and DegreesFreedom identifies the reference distribution. Both arguments are required. RT means right tail; there is no cumulative-or-density flag in this function’s documented syntax.
Use positive whole-number degrees of freedom in these examples. A statistic must be calculated separately from the observed and expected data. The function does not inspect the data, estimate parameters or determine the correct degrees of freedom.
The dedicated help uses language about confirming a hypothesis. Interpret the output more carefully: it is a tail probability under the supplied reference model, not a posterior probability that a hypothesis is true or a guarantee that a conclusion is correct.
Example 1: verify a decreasing right-tail table
Put 0, 1, 2, 4, 6 in A2:A6. In B2 enter =CHISQ.DIST.RT(A2;2) and fill down. Independent targets are approximately 1, 0.606530660, 0.367879441, 0.135335283 and 0.049787068.
For two degrees of freedom the exact mathematical right-tail expression is EXP(-x/2). Enter =EXP(-A2/2) in C2 and fill down to verify the table independently.
Unlike a left-tail cumulative probability, the right tail decreases as the evaluation point increases. At zero its mathematical probability is one, because this continuous distribution has nonnegative support.
Example 2: compare the two tails
At x=4 and two degrees of freedom, the left-tail cumulative value is approximately 0.864664717, while the right tail is approximately 0.135335283. Their sum targets one.
Use =CHISQ.DIST(4;2;1)+CHISQ.DIST.RT(4;2) as a moderate-value complement check. The last argument in CHISQ.DIST must be one; adding its density would not yield the complementary relationship.
The right-tail output already is a probability. Applying another 1- changes it into the left tail rather than improving it.
Advanced application: calculate a goodness-of-fit statistic transparently
For a mathematical six-category example, put observed counts 195, 151, 148, 189, 183, 154 in A10:A15 and expected counts 170 in B10:B15. Use =(A10-B10)^2/B10 in C10 and fill down, then sum C10:C15.
The observations total 1020 and the independent statistic is approximately 13.270588235. With six fixed-probability categories and the usual total-count constraint, this example uses five degrees of freedom. Passing the unrounded sum to CHISQ.DIST.RT gives an independent tail near 0.02097.
The official documentation evaluates the rounded statistic 13.27 with five degrees of freedom and reports approximately 0.020975769. Small differences from using the unrounded statistic are expected. These calculations illustrate the formula, not a general endorsement of every dataset’s test assumptions.
Advanced application: check a right-tail critical threshold
=CHISQ.INV.RT(0.05;5) has independent target approximately 11.070497694. Evaluating CHISQ.DIST.RT at that stored threshold with five degrees of freedom should target 0.05.
Choose the testing rule and significance level before inspecting data if the calculation is being used in an actual test. Changing a threshold afterward changes the decision rule; the function does not manage that process.
Errors and troubleshooting
Check tail direction, degrees of freedom and statistic rounding. A right-tail probability of about 0.021 does not mean a hypothesis is 97.9% likely to be false or 2.1% likely to be true.
The dedicated help does not establish every invalid-input code, fractional-degree rule or extreme-tail accuracy bound. Use validated nonnegative statistics and positive integer degrees of freedom, and test numerically sensitive calculations in the actual application.
Availability and verification
The exact function is documented in Collabora Office 26.04 desktop help. Its source snapshot was retrieved on 2026-10-13 and hash-verified on October 15, 2026. Desktop documentation does not establish Online or mobile support. First introduced release and last functioning version are unknown; the dedicated source does not establish them.
No native Collabora Office run occurred. All worked values are independent mathematical expectations, not verification of native error codes or every numerical limit. Formulas use English names and semicolon separators.
The help identifies namespace COM.MICROSOFT.CHISQ.DIST.RT and places the function outside the cited OpenFormula 1.3 standard. This format disclosure does not prove identical behavior in another product.