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.

 1 2 3
 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)
 Rate this content: