Formualizer Docs

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

ArgumentTypeRequiredDefault
xnumberRequired—
deg_freedomnumberRequired—

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_freedom is truncated to an integer.

Error cases

  • Returns #NUM! when x < 0, deg_freedom < 1, or deg_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?.

Implementation

Engine source

On this page