Compatibility - CHIDIST Function

The CHIDIST function replaces the CHISQ.DIST.RT function from Excel 2010.

Description

The function returns the right-tailed probability of the chi-squared distribution. The X² distribution is associated with a X² test. Use the X² test to compare the observed and the expected values. By comparing the observed results with the expected ones, you can decide whether your original hypothesis is valid.

Syntax

CHIDIST(x,deg_freedom)

Arguments

Argument	Description	Required/ Optional
X	The value at which you want to evaluate the distribution.	Required
Deg_freedom	The number of degrees of freedom.	Required

Notes

CHIDIST is calculated as CHIDIST = P(X > x), where X is a X² random variable.
If deg_freedom is not an integer, it is truncated.
If either argument is nonnumeric, CHIDIST returns the #VALUE! error value.
If x is negative, CHIDIST returns the #NUM! error value.
If deg_freedom < 1 or deg_freedom > 10^10, CHIDIST returns the #NUM! error value.

Example

advanced_excel_compatibility_functions.htm