CHIDIST
Returns the right-tailed chi-squared probability (legacy name).
CHIDIST(x, deg_freedom) is P(X > x), the same as CHISQ.DIST.RT.
The Formualizer engine in this repository at 0.14.0 plus unreleased changes computes the example results. Known differences from Excel are listed on this page.
Syntax
=CHIDIST(x, deg_freedom)
Arguments
| Argument | Type | Required | Default |
|---|---|---|---|
x | number | Required | — |
deg_freedom | number | Required | — |
How it works
Maps to CHISQ.DIST.RT(x, degrees_freedom), with both arguments in the same order. Integrates the chi-squared density above nonnegative x, with positive degrees of freedom.
Remarks
deg_freedomis truncated to an integer.
Error cases
- Returns
#NUM!whenx < 0,deg_freedom < 1, ordeg_freedom > 10^10.
Examples
Use the legacy name to integrate the chi-square tail above four.
Formula =CHIDIST(4,3)
Expected result 0.261464129949111
Try this formula
This editor runs the published Formualizer 0.14.0 package, so the last digits can differ and functions newer than that release return #NAME?.
Increase the degrees of freedom from three to ten while holding the tail cutoff fixed.
Formula =CHIDIST(4,10)
Expected result 0.947346982656289
Try this formula
This editor runs the published Formualizer 0.14.0 package, so the last digits can differ and functions newer than that release return #NAME?.
The legacy upper-tail probability above zero is one.
Formula =CHIDIST(0,3)
Expected result 1
Try this formula
This editor runs the published Formualizer 0.14.0 package, so the last digits can differ and functions newer than that release return #NAME?.
A negative statistic is outside the chi-square domain.
Formula =CHIDIST(-1,3)
Expected result #NUM!
Try this formula
This editor runs the published Formualizer 0.14.0 package, so the last digits can differ and functions newer than that release return #NAME?.
Find the chi-square probability above 18.307 with ten degrees of freedom.
Formula =CHIDIST(18.307,10)
Expected result 0.0500005890913982
Try this formula
This editor runs the published Formualizer 0.14.0 package, so the last digits can differ and functions newer than that release return #NAME?.