Excel > Function References > Statistical Functions

CHISQ.DIST.RT function

Returns the right-tailed probability of the chi-squared (χ2) distribution. The χ2 distribution is associated with a χ2 test. Use the χ2 test to compare observed and expected values. For example, a genetic experiment might hypothesize that the next generation of plants will exhibit a certain set of colors. By comparing the observed results with the expected ones, you can decide whether your original hypothesis is valid.

Syntax

CHISQ.DIST.RT(x,deg_freedom)

Argument	Description	Remarks
x	The value at which you want to evaluate the distribution.	If this argument is nonnumeric, this function returns the #VALUE! error value.
deg_freedom	The number of degrees of freedom.	If this argument is less than 1, this function returns the #NUM! error value. If this argument > 10^10, this function returns the #NUM! error value. If this argument is nonnumeric, this function returns the #VALUE! error value. If this argument contains a decimal value, this function ignores the numbers to the right side of the decimal point.

Example

To make the following example easier to understand, you can copy the data to a blank sheet and then enter the function underneath the data. Do not select the row or column headings (1, 2, 3... A, B, C...) when you copy the sample data to a blank sheet.

A	B
Data	Description
18.307	Value at which you want to evaluate the distribution
10	Degrees of freedom
Formula	Description (Result)
=CHISQ.DIST.RT(A2,A3)	One-tailed probability of the chi-squared (χ2) distribution, for the above terms (0.050001)

See also
CHISQ.INV.RT function
CHISQ.INV function
CHISQ.TEST function
List of all functions (by category)

Share your feedback about this topic

Rate this content: