How to use CHISQ.DIST.RT Function in Excel

The CHISQ.DIST.RT function returns the right-tailed probability of the chi-squared distribution. The X2 distribution is associated with a X2 test. Use the X2 test to compare observed and expected values. 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)

The CHISQ.DIST.RT function syntax has the following arguments:

  1. (required argument) – This is the value at which the chi-square distribution is to be evaluated. It should be greater than or equal to zero.
  2. Deg_freedom (required argument) – This is the number of degrees of freedom. It must be an integer between 1 and 1010.

Example: Let’s look at some Excel CHISQ.DIST.RT function examples and explore how to use the CHISQ.DIST.RT function as a worksheet function in Microsoft Excel:

CHISQ.DIST .RT Function - How to use CHISQ.DIST.RT Function in Excel

Syntax:  =CHISQ.DIST.RT(B1,B2)

Result: 0.050000589

CHISQ.DIST .RT Function in Excel - How to use CHISQ.DIST.RT Function in Excel

Based on the Excel spreadsheet above, the following CHISQ.DIST.RT examples would return:

Syntax: =CHISQ.DIST.RT(C1,C2)
Result: 0.000779573

Syntax: =CHISQ.DIST.RT(D1,D2)
Result: 0.113846298

Syntax: =CHISQ.DIST.RT(D1,D2)
Result: 0.113846298

Note:

  1. If the deg_freedom argument is not an integer, it is truncated by MS Excel.
  2. The function belongs to the CHISQ group of functions. It was introduced in MS Excel 2010 and hence is unavailable for earlier versions. The CHISQ.DIST.RT function is an updated version of the CHIDIST function.
  3. #VALUE! error – Occurs when any of the arguments provided is non-numeric. Remember, CHISQ.DIST.RT will accept only numeric datasets for both arguments and return numeric data.
  4. #NUM! error – Occurs when:
    1. The given value of x is negative.
    2. The deg_freedom argument is less than 1 or greater than 1010.

Add a Comment

Your email address will not be published. Required fields are marked *