Calculates the inverse of the right-tailed probability of a chi-square distribution
Over 1.8 million professionals use CFI to learn accounting, financial analysis, modeling and more. Start with a free account to explore 20+ always-free courses and hundreds of finance templates and cheat sheets.
The CHISQ.INV.RT Function is categorized under Excel Statistical functions. It will calculate the inverse of the right-tailed probability of a chi-square distribution. We use this function to compare observed and expected values.
In financial analysis, the CHISQ.INV.RT function can be used to find out and compare observed and expected values. For example, a genetic experiment might hypothesize that the next generation of plants bearing fruits will exhibit a certain set of traits. By comparing the observed results with the expected ones, we can decide whether our hypothesis is valid or not.
The CHISQ.INV.RT function uses the following arguments:
Probability (required argument) – This is the probability of the right-tailed chi-square distribution, for which we want to find the value of x.
Deg_freedom (required argument) – This is the number of degree of freedoms. It must be a positive integer.
So, for a supplied probability, the CHISQ.INV.RT function finds the value of x such that CHISQ.DIST.RT(x,degrees_freedom) = probability. Hence, the precision of CHISQ.INV.RT depends on the precision of CHISQ.DIST.RT.
To understand the uses of the CHISQ.INV.RT function, let us consider an example:
Suppose we are given the following data with us:
The formula for calculating the one-tailed probability of the chi-squared distribution is:
We get the result below:
A few notes about the CHISQ.INV.RT Function
If the deg_freedom argument is not an integer, it is truncated by MS Excel.
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.
#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.
#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.
#NUM! Error – Occurs when:
The given value of probability is less than or equal to 0 or is greater than 1.
Thanks for reading this guide to important Excel functions! By taking the time to learn and master these functions, you’ll significantly speed up your financial analysis. To learn more, check out these additional CFI resources:
Take your learning and productivity to the next level with our Premium Templates.
Upgrading to a paid membership gives you access to our extensive collection of plug-and-play Templates designed to power your performance—as well as CFI's full course catalog and accredited Certification Programs.
Already have a Self-Study or Full-Immersion membership? Log in
Access Exclusive Templates
Gain unlimited access to more than 250 productivity Templates, CFI's full course catalog and accredited Certification Programs, hundreds of resources, expert reviews and support, the chance to work with real-world finance and research tools, and more.