The `CHISQ.INV` function in Excel is used to calculate the inverse of the left-tailed probability of the chi-square distribution. This can be useful in various statistical analyses where you need to determine the critical value of a chi-square distribution given a probability.
Syntax
CHISQ.INV(probability, degrees_freedom)
- probability: A probability associated with the chi-square distribution. This should be a numeric value between 0 and 1.
- degrees_freedom: The number of degrees of freedom of the distribution. This must be a positive integer.
Usage Example
Suppose you want to find the chi-square critical value for a probability of 0.95 with 10 degrees of freedom:
- Click on the cell where you want the result to appear.
- Type `=CHISQ.INV(0.95, 10)` and press Enter.
- The cell will display the chi-square critical value corresponding to a 95% probability with 10 degrees of freedom.
Tips
- Ensure the `degrees_freedom` value is a positive integer; otherwise, the function will return an error.
- The `probability` parameter should be between 0 (exclusive) and 1 (inclusive).
- If you have a right-tailed probability, you can adjust it for left-tailed by 1 – probability.
Using `CHISQ.INV` is straightforward once you understand what it calculates and how the parameters affect the outcome. It is often used in hypothesis testing, particularly in Chi-square tests for independence or goodness of fit.
Unlock Your Potential
Excel
Access
Power BI
