Contact
12 programs
Explore the site

CHISQ.DIST.RT Function (LibreOffice Calc)

Statistical Intermediate LibreOffice Calc LibreOffice 4.2

CHISQ.DIST.RT returns chi-square right-tail probabilities in LibreOffice Calc. Learn its integer degree count, interval-tail calculations and relationship to CHIDIST.

Verification status: Consult the documentation, examples and any stated test scope below. How formula examples are checked

Availability and version history

  • Introduced: LibreOffice 4.2.
  • Availability: Supported in LibreOffice 26.8.1.1, verified against its function registry. This identifies a supported release, not a final working version.
  • Scope: Desktop Calc, using the English function name. Availability in other spreadsheet applications is separate.
  • Checked: 2026-10-14 — function reference; versioned support. Documentation/source check; not a new native test. Existing example-specific test claims below retain their stated scope.
The **CHISQ.DIST.RT** function returns the **right‑tailed probability** of the chi-square distribution. It is a separately documented compatibility name with a right-tail interpretation also used by CHIDIST. Their input contracts are not identical: this dotted entry rejects negative x in the cited release.

What the CHISQ.DIST.RT Function Does

  • Computes P(X ≥ x) for a chi-square distribution
  • Used in hypothesis testing and model evaluation
  • A separate compatibility entry with the same right-tail orientation as CHIDIST
  • Documented as the COM.MICROSOFT.CHISQ.DIST.RT extension, outside the OpenFormula 1.3 function set

Syntax

CHISQ.DIST.RT(x; degrees_freedom)

Arguments

  • x:
    The chi-square statistic (must be ≥ 0).

  • degrees_freedom:
    Positive integer degree count. The evaluator floors fractional input before requiring at least 1.

Both arguments are required. The official Help documents this name; the release evaluator and dispatcher distinguish its negative-x rule from CHIDIST.

Basic Examples

Right‑tail probability

=CHISQ.DIST.RT(10; 5)
→ approximately 0.075235246147

Using cell references

=CHISQ.DIST.RT(A1; B1)

Compare with left‑tail

=1 - CHISQ.DIST(x; df; TRUE)

Compare with legacy function

=CHIDIST(10; 5)

Advanced Examples

Goodness‑of‑fit test (manual)

=CHISQ.DIST.RT(TestStatistic; df)

Probability in two outside regions

=CHISQ.DIST.RT(upper; df) + CHISQ.DIST(lower; df; TRUE)

Use ordered bounds lower≤upper. For lower=2, upper=10 and df=5, the combined outside probability is approximately 0.226090210062. This is not automatically a calibrated two-sided test p-value; the chosen rejection regions and model matter.

Validate with CHISQ.INV.RT

=CHISQ.INV.RT(CHISQ.DIST.RT(x; df); df)

Generate a chi-square value by inversion

=CHISQ.INV.RT(1-RAND(); df)

The right-tail inverse needs a probability in (0,1]. Using 1−RAND() avoids passing RAND()’s possible zero directly into that inverse. Evaluating a CDF at RAND()*20 would not itself generate a chi-square-distributed x value.

Use in model rejection logic

=IF(CHISQ.DIST.RT(x; df) < 0.05; "Reject H0"; "Fail to Reject")

This decision rule needs a justified chi-square statistic and degrees of freedom, plus a significance level chosen before interpreting the data. Failing to reject is not proof that the hypothesis is true.

Edge Cases and Behavior Details

CHISQ.DIST.RT returns a probability between 0 and 1

Accepts:

  • x ≥ 0
  • degrees_freedom ≥ 1

Behavior details

  • Right‑tail only
  • Not symmetric
  • Uses gamma‑function internally
  • CHIDIST remains separately documented; no retirement is established here

Invalid input → Err:502

CHISQ.DIST.RT of an error → error propagates

Common Errors and Fixes

Err:502 — Invalid argument

Cause:

  • x < 0
  • degrees_freedom < 1

Fix:

  • Validate x ≥ 0
  • Ensure df ≥ 1
  • Validate imported text separately; the numeric guards do not establish every coercion result

Unexpected results

Cause:

  • Confusing left‑tail vs right‑tail

Fix:

  • Use CHISQ.DIST for left‑tail
  • Use CHISQ.DIST.RT for right‑tail

Best Practices

  • Use CHISQ.DIST.RT for right‑tail probabilities
  • Use CHISQ.DIST for left‑tail
  • Use CHISQ.TEST for full hypothesis testing
  • Validate degrees of freedom carefully
  • Use CHISQ.INV.RT for critical values
Choose a dedicated right-tail evaluation when the upper-tail probability is very small; subtracting a left-tail CDF rounded close to 1 can lose precision. These ordinary examples do not certify every extreme-tail calculation.
  • CHISQ.DIST — left‑tail chi-square
  • CHISQ.INV.RT — right‑tail inverse
  • CHISQ.INV — left‑tail inverse
  • CHISQ.TEST — full chi-square test
  • GAMMA / GAMMALN — underlying math

By mastering CHISQ.DIST.RT, you can build robust, modern statistical models and hypothesis tests in LibreOffice Calc.

Sources and verification scope

Official CHISQ.DIST.RT Help and LibreOffice 26.8.1.1 implementation. The displayed numeric cases were independently calculated; no new native-application result or all-locale/extreme-tail certification is claimed.