CHISQ.INV.RT Function (LibreOffice Calc)

• Computes the inverse of the right‑tailed chi-square distribution
• Returns the critical chi-square value for hypothesis testing
• Modern, standards‑compliant replacement for CHIINV
• Used in model evaluation, variance tests, and confidence intervals

CHISQ.INV.RT(probability; degrees_freedom)

Arguments

• probability:
  Right‑tail probability (0 < p < 1).

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

Right‑tail critical value

=CHISQ.INV.RT(0.05; 10)
→ 18.307

Using cell references

=CHISQ.INV.RT(A1; B1)

Compare with left‑tail inverse

=CHISQ.INV(0.95; 10)

Compare with legacy function

=CHIINV(0.05; 10)

Two‑tailed chi-square test

Upper tail:

=CHISQ.INV.RT(0.025; df)

Lower tail:

=CHISQ.INV(0.975; df)

Validate with CHISQ.DIST.RT

=CHISQ.DIST.RT(CHISQ.INV.RT(p; df); df)
→ returns p

Use in confidence interval calculations

=Variance * CHISQ.INV.RT(0.025; df)

Use in Monte Carlo simulations

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

CHISQ.INV.RT returns a positive real number

Accepts:

• 0 < probability < 1
• degrees_freedom ≥ 1

Behavior details

• Right‑tail only
• Not symmetric
• Uses gamma‑function internally
• Replaces legacy CHIINV for right‑tail calculations

Invalid input → Err:502

CHISQ.INV.RT of an error → error propagates

• Use CHISQ.INV.RT for right‑tail critical values
• Use CHISQ.INV for left‑tail
• Validate probability inputs carefully
• Use CHISQ.TEST for full hypothesis testing
• Use CHISQ.DIST.RT for probability calculations

• CHISQ.INV — left‑tail inverse
• CHISQ.DIST.RT — right‑tail probability
• CHISQ.DIST — left‑tail probability
• CHISQ.TEST — full chi-square test
• GAMMA / GAMMALN — underlying math

By mastering CHISQ.INV.RT, you can compute accurate chi-square critical values for any statistical model or hypothesis test in LibreOffice Calc.