CHIINV function returns the inverse of the right-hand probability of the distribution when squared. Compatibility function This application is much used in comparing observed results with expected results to determine whether your original hypothesis is valid or not. You can apply the CHIINV function on versions of Office 2013, Office 2010, Office 2007 and Office 2003
How to use the CHIINV function in Excel, for example
Instructions for using the CHIINV function in Excel – Example illustrations
Syntax: CHIINV (probability, deg_freedom)
– Probability : Must have – Is a Probability associated with the distribution when squared.
– Deg_freedom : Must have – Is Number of degrees of freedom.
You enter your actual values excel with the parameters of the function in the excel cells. In this example, we calculate with the parameter values: Probability associated with the distribution when the square is 0.0725 and the degrees of freedom is 9:
Enter the formula in the cell C8. And the calculated result of the function is 15.74060658:
So you already know how to use the CHIINV function in Excel already. Note that when entering data, the parameters in the function must always be numeric and the probability must also have a value between 0 and 1, and the degrees of freedom will be automatically converted to an integer if necessary.
If you want to get, cut a certain string of characters in a given string, use the MID function, after entering information, syntax of the MID function, you will get the characters or the string in the middle or the left and right are different in the character string of the given excel spreadsheet.
IF function helps you get any data present in a given Excel spreadsheet, users often combine the IF function with many other functions to solve the problem more quickly and appropriately.