CHIINV Excel Formula

Author Zaheer    Category Formulas     Tags ,

Excel Statistical Functions is provided in a very wide range. The function ranges from computing the mean, median, and mode, statistical distribution, and probability tests. Some of the Excel Statistical Functions are pre-installed in new versions of Excel and some are not available in older versions.

These functions are already categorized for the functions are easy to find. One of the subgroups of Excel Statistical Functions is the Distribution and Tests of Probability which includes the function CHIINV function.

The CHIINV function computes the one-tailed probability of the chi-square distribution. The function is also used compare the expected results to know if the original hypothesis is valid. The syntax for the CHIINV function is =CHIINV(probability,degrees_freedom). The probability argument is the probability of chi-square distribution where you want to find the value of x. The argument degrees_freedom is the numerical value of the degrees of freedom.

Take heed that the function usually has some errors. These errors are #VALUE! and #NUM! error. The #VALUE! error occurs when the given data of the arguments are non-numeric. The #NUM! error occurs in the function when the value of the probability is lesser than 0 or greater than 1. Also, the #NUM! error will occur if the given value of the argument degrees_freedom is lesser than 1 or equal to or grater than 10^10.

The relationship of Chiinv and Chidist function is that the Chiinv function is the opposite of the Chidist function. That is the Chiinv function in a probability uses the iterative process in finding the value of x.

To test the function open a blank spreadsheet or worksheet in Excel and in cell A2 input the value 0.050001 which will be the probability related to the distribution in the chi-square. In cell A3 input the value 10 which is the value of the degree of freedom. Input the formula =CHIINV(A2,A3) and the result will be 18.3069735. This example is using source cells with the given value. You can also input the value in the formula such as; =CHIINV(0.5,1) and the result will be 0.454936423.

To view the results from formulas to results and vice-versa you can hit the Ctrl+` (grave accent). You can also do this by hitting the Formulas tab and selecting the Formulas Auditing group and select the Show Formulas.

 

Post comment