ExcelFlux

CHIDIST function

the one-tailed probability of the chi-squared distribution.

Compatibility · Guided Excel example

Where can you use it?

Teams maintaining legacy workbooks. Compare the example inputs and expected results with the formula in your workbook when checking a calculation made in an older version.

Scenario in the workbook

Find a legacy chi-square upper-tail probability with four degrees of freedom.

A worked example from the workbook

RowA
6Input
71
84
98
Record 1
=CHIDIST(A7,4)

Illustrative output0.9097959896

See the inputs and instructions for all 3 examples

Syntax

CHIDIST(x,deg_freedom)

Compatibility function for older workbooks.

Worked examples

Find a legacy chi-square upper-tail probability with four degrees of freedom.

Column F provides expressions as text. Satisfy the stated requirements, then paste into an empty Excel cell and compare with column G. The result was not verified in desktop Excel here.

Row A
6 Input
7 1
8 4
9 8
Trial Expression Sample output
Record 1 =CHIDIST(A7,4) 0.9097959896
Record 2 =CHIDIST(A8,4) 0.4060058497
Record 3 =CHIDIST(A9,4) 0.09157819444
Microsoft Excel reference