CHISQ.INV Function (LibreOffice Calc)

• Computes the inverse of the left‑tailed chi-square distribution
• Returns the critical chi-square value for a given probability
• Used in hypothesis testing and model evaluation
• Modern, standards‑compliant statistical function

CHISQ.INV(probability; degrees_freedom)

Arguments

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

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

Left‑tail critical value

=CHISQ.INV(0.95; 10)
→ 18.307

Using cell references

=CHISQ.INV(A1; B1)

Compare with right‑tail inverse

=CHISQ.INV.RT(0.05; 10)

Compare with legacy function

=CHIINV(1 - p; df)

Two‑tailed chi-square test

Upper tail:

=CHISQ.INV.RT(0.025; df)

Lower tail:

=CHISQ.INV(0.025; df)

Validate with CHISQ.DIST

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

Use in confidence interval calculations

=Variance * CHISQ.INV(0.975; df)

Use in Monte Carlo simulations

=CHISQ.INV(RAND(); df)

CHISQ.INV returns a positive real number

Accepts:

• 0 < probability < 1
• degrees_freedom ≥ 1

Behavior details

• Left‑tail only
• Not symmetric
• Uses gamma‑function internally
• Replaces legacy CHIINV for left‑tail calculations

Invalid input → Err:502

CHISQ.INV of an error → error propagates

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

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

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