CHISQ.DIST in WPS Spreadsheet: Chi-Square Left-Tail Probability and Density

=CHISQ.DIST(2,2,TRUE) has an independent expected result of 0.632120558829. It gives P(X ≤ 2) for a chi-square variable with 2 degrees of freedom. Changing the final argument to FALSE gives the density, approximately 0.183939720586, rather than a tail probability.

CHISQ.DIST(x,deg_freedom,cumulative)

All three arguments are required. x is a numeric, nonnegative statistic value. deg_freedom is the numeric degrees of freedom; use positive integers. The source says fractional degrees of freedom are truncated. cumulative is a logical switch: TRUE returns the left cumulative distribution, FALSE the density. Do not omit this switch or confuse density with the chance of an exact value: an exact point in a continuous distribution has zero probability.

Enter 2 in B2, 2 in B3 and TRUE in B4, with labels Statistic, Degrees of freedom and Cumulative in A2:A4. In D2 enter =CHISQ.DIST(B2,B3,B4). The expected result is 0.632120558829, or about 63.21% when formatted as a percentage.

For two degrees of freedom, the lower CDF is 1−exp(−x/2), so the independent check is 1−exp(−1). The density is exp(−x/2)/2. With B4 set to FALSE, D2 should therefore be about 0.183939720586. That value is density per statistic unit; it is not 18.39% probability at x=2.

For the same model, the probability between 2 and 4 is found by subtraction:

=CHISQ.DIST(4,2,TRUE)-CHISQ.DIST(2,2,TRUE)

Independent expectation: 0.232544157935, because exp(−1)−exp(−2) gives the same area. The CDF at 4 is 0.864664716763, larger than at 2. A CDF must not decrease as x increases.

An ordinary upper-tail calculation is =1-CHISQ.DIST(2,2,TRUE), expected 0.367879441171. This guide does not promise high relative accuracy from subtraction in extreme tails. CHIDIST is documented separately as a right-tail function; its name is not interchangeable with CHISQ.DIST.

WPS documents #VALUE! for nonnumeric inputs and #NUM! for negative x or invalid degrees of freedom. A negative statistic in a chi-square workflow usually calls for checking the statistic’s construction before changing the function. Degrees of freedom are supplied by your model; the function does not derive them from a data range.

The source’s error paragraph allows an upper df boundary of 10^10, while its walkthrough excludes that endpoint. This guide deliberately uses small positive integer df and does not resolve the upper-bound contract. Keep cumulative explicitly TRUE or FALSE. A successful formula does not validate a goodness-of-fit test’s expected counts, independence, statistic or df.

The official WPS CHISQ.DIST lesson was checked on October 19, 2026. The captured source does not establish a specific edition or numeric build. This Chinese first-party documentation is not proof of universal English-global, Mac, Linux, web or mobile support. Introduction and retirement versions remain unknown. All numerical results in this guide are independently calculated expectations, not native WPS test results or borrowed Excel outputs. Current GUI access was unavailable; no current-application screenshots or native execution are claimed.

CHIDIST, CHIINV. Browse the WPS function library.