Buzz
The CHIINV function returns the inverse value of right-tailed probability distribution when squared. This compatible function is widely used to compare observed outcomes with expected results to determine the validity of your initial hypothesis. You can apply the CHIINV function across Office 2013, Office 2010, Office 2007, and Office 2003 versions.
How to Use CHIINV Function in Excel: Illustrated Example
Guide to Using CHIINV Function in Excel - Illustrated Example
Syntax: CHIINV(probability,deg_freedom)
Where:
- Probability : Mandatory – It is a probability associated with the chi-squared distribution.
- Deg_freedom : Mandatory – It represents the Degrees of Freedom.
Consider an Example:
You input the actual values corresponding to the function parameters into Excel cells. In this example, we calculate with the parameter values: Probability associated with the chi-squared distribution is 0.0725 and Degrees of Freedom is 9 :
Enter the formula in cell C8. And the calculated result of the function is 15.74060658 :
So now you know how to use the CHIINV function in Excel. Note that when entering data, the parameters in the function must always be in numerical form and the probability must have a value ranging from 0 to 1, while the degrees of freedom will be automatically converted to an integer if necessary.
To extract or cut a specific substring from a given string in Excel, use the MID function. After entering the information, the MID function syntax, you will be able to retrieve characters or different substrings from the left, right, or middle of the given string in the Excel worksheet.
The IF function helps you retrieve any data present in the Excel worksheet. Users often combine the IF function with various other functions to solve problems quickly and efficiently. The TRUNC function is also a useful function in Excel, and you can refer to this TRUNC function for effective use in your work.
