How to use CHISQ.INV.RT Function in Excel

This function returns the inverse of the right-tailed probability of the chi-square distribution. If probability = CHISQ.DIST.RT(x,…) then CHI.INV(probability,…) = x. Use this function to compare the observed results with the expected results in order to decide whether your original hypothesis is valid.

Syntax:= CHISQ.INV.RT(probability,deg_freedom)

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

  1. Probability (required argument) – This is the probability of the right-tailed chi-square distribution, for which we want to find the value of x.
  2. Deg_freedom (required argument) – This is the number of degree of freedoms. It must be a positive integer.

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

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

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

Result18.30697346

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

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

Syntax: =CHISQ.INV.RT(C1,C2)
Result: 0.101531044

Syntax: =CHISQ.INV.RT(D1,D2)
Result: 4.605170186

Syntax: =CHISQ.INV.RT(E1,E2)
Result: 0.446287103

Syntax: =CHISQ.INV.RT(F1,F2)
Result: 4.13604396

Note:

  1. If the deg_freedom argument is not an integer, it is truncated by MS Excel.
  2. The CHISQ.INV.RT function belongs to the CHISQ family of functions. The function was introduced in Excel 2010 and hence is unavailable in earlier versions. It is an updated version of the CHIINV function.
  3. #VALUE! error – Occurs when any of the arguments provided is non-numeric. Remember, the function will accept only numeric data sets for both arguments and return numeric data.
  4. #N/A error – CHISQ.INV.RT uses an iterative search technique. If the search is not converged after 64 iterations, the function will return this error.
  5. #NUM! Error – Occurs when:
    1. The given value of probability is less than or equal to 0 or is greater than 1.
    2. The deg_freedom argument is less than 1.

Add a Comment

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