CHISQ.DIST Function (LibreOffice Calc)

• Computes P(X ≤ x) for a chi-square distribution
• Used in statistical modeling and hypothesis testing
• Modern replacement for legacy chi-square functions
• Supports both PDF and CDF modes

CHISQ.DIST(x; degrees_freedom; cumulative)

Arguments

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

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

• cumulative:
  TRUE → returns the cumulative distribution function (CDF)
  FALSE → returns the probability density function (PDF)

Left‑tail probability (CDF)

=CHISQ.DIST(10; 5; TRUE)
→ 0.924

Probability density (PDF)

=CHISQ.DIST(10; 5; FALSE)

Using cell references

=CHISQ.DIST(A1; B1; TRUE)

Compare with right‑tail

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

Goodness‑of‑fit test (manual CDF)

=CHISQ.DIST(TestStatistic; df; TRUE)

Convert to right‑tail probability

=CHISQ.DIST.RT(x; df)

Compute a two‑tailed region

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

Validate with CHISQ.INV

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

Use in Monte Carlo simulations

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

CHISQ.DIST returns:

• A probability (0–1) when cumulative = TRUE
• A density value when cumulative = FALSE

Accepts:

• x ≥ 0
• degrees_freedom ≥ 1

Behavior details

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

Invalid input → Err:502

CHISQ.DIST of an error → error propagates

• Use CHISQ.DIST for left‑tail probabilities
• Use CHISQ.DIST.RT for right‑tail
• Use CHISQ.TEST for full hypothesis testing
• Validate degrees of freedom carefully
• Use CHISQ.INV for critical values

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

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