CHISQ.DIST in Collabora Office: Calculate Left-Tail Chi-Square Probability or Density
Use Collabora CHISQ.DIST to distinguish density from left-tail probability, reproduce a simple distribution and audit probability bands.
Verification status: See the evidence and test scope described in this guide. How formula examples are checked
Quick answer: =CHISQ.DIST(3;2;1) has independently expected result approximately 0.776869840. It is the cumulative probability through three for a chi-square distribution with two degrees of freedom.
Syntax and tail direction
=CHISQ.DIST(Number; DegreesFreedom; Cumulative)
Number is the nonnegative evaluation point. DegreesFreedom is the distribution’s degrees of freedom; use positive whole-number values in these examples. Cumulative is required: zero or FALSE selects density, while the dedicated Collabora help says other values or TRUE select the cumulative distribution. Supply an explicit zero or one.
Cumulative mode gives a left-tail probability, P(X<=x). It is not the right-tail probability above x. Density mode gives the height of a continuous probability curve, not the probability of exactly x.
Degrees of freedom must come from a valid model or test design. This function does not infer them from observations and does not calculate a chi-square test statistic from an input table.
Example 1: build a two-degree distribution table
Put 0, 1, 2, 4, 6 in A2:A6. Enter =CHISQ.DIST(A2;2;1) in B2 and fill down. Independent cumulative targets are approximately 0, 0.393469340, 0.632120559, 0.864664717 and 0.950212932.
For two degrees of freedom, the independent cumulative formula is 1-EXP(-x/2). Use =1-EXP(-A2/2) in C2 and fill down for a simple mathematical check.
The cumulative values increase with x and stay between zero and one. If the table decreases, check whether a right-tail function was used instead.
Example 2: contrast the documented density and probability
The official examples use x=3 and two degrees of freedom. =CHISQ.DIST(3;2;0) has independent density approximately 0.111565080, while the cumulative form has probability approximately 0.776869840.
For this particular distribution, the density is 0.5*EXP(-x/2). It is measured per unit of the chi-square variable. It must be integrated over a range to become a probability.
Changing the last argument changes the mathematical question. Label each output explicitly rather than applying a percentage format to every result and assuming they are comparable probabilities.
Advanced application: calculate a probability band
The probability between two and six is =CHISQ.DIST(6;2;1)-CHISQ.DIST(2;2;1), independently approximately 0.318092373.
The probability above six is the complement of the left tail, approximately 0.049787068. For moderate values, =1-CHISQ.DIST(6;2;1) verifies this; a direct right-tail function expresses that event more clearly and can avoid subtracting from a near-one cumulative value in extreme cases.
Endpoint allocation does not change a continuous model probability. This differs from discrete counts, where including the threshold itself can matter.
Advanced application: verify a quantile
For two degrees of freedom, the 95th percentile is approximately 5.991464547. Put =CHISQ.INV(0.95;2) in F2, then evaluate =CHISQ.DIST(F2;2;1) in F3. The independent round-trip target is 0.95.
Use the stored F2 value rather than a rounded threshold. This checks consistent probability direction and degrees of freedom; it does not certify numerical behavior for every extreme probability.
Errors and troubleshooting
Validate a nonnegative evaluation point and positive integer degrees of freedom. The dedicated section does not specify every upper limit, fractional-degree coercion, endpoint density or native error display; those cases remain unverified.
A small right-tail probability is not the probability that a hypothesis is false, and a large cumulative value does not confirm one. Distribution calculations require an appropriate statistic and justified assumptions before they have a test interpretation. This guide supplies reference arithmetic rather than a statistical decision for real data.
Availability and verification
The exact function is documented in Collabora Office 26.04 desktop help. Its source snapshot was retrieved on 2026-10-13 and hash-verified on October 15, 2026. Desktop documentation does not establish Online or mobile support. First introduced release and last functioning version are unknown; the dedicated source does not establish them.
No native Collabora Office run occurred. All worked values are independent mathematical expectations, not verification of native error codes or every numerical limit. Formulas use English names and semicolon separators.
The help identifies namespace COM.MICROSOFT.CHISQ.DIST and places the function outside the cited OpenFormula 1.3 standard. This format disclosure does not prove identical behavior in another product.