CHISQ.DIST.RT Function (LibreOffice Calc)

• Computes P(X ≥ x) for a chi-square distribution
• Used in hypothesis testing and model evaluation
• Modern replacement for CHIDIST
• Supports accurate, standards‑compliant statistical calculations

CHISQ.DIST.RT(x; degrees_freedom)

Arguments

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

• degrees_freedom:
  Degrees of freedom (must be ≥ 1).

Right‑tail probability

=CHISQ.DIST.RT(10; 5)
→ 0.075

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)

Goodness‑of‑fit test (manual)

=CHISQ.DIST.RT(TestStatistic; df)

Compute a two‑tailed region

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

Validate with CHISQ.INV.RT

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

Use in Monte Carlo simulations

=CHISQ.DIST.RT(RAND()*20; df)

Use in model rejection logic

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

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
• Replaces legacy CHIDIST

Invalid input → Err:502

CHISQ.DIST.RT of an error → error propagates

• 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

• 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.