The CHISQ.INV function in Google Sheets is a powerful statistical tool used to determine the inverse of the left-tailed chi-squared distribution. This function is especially useful in hypothesis testing, confidence interval construction, and other applications requiring statistical analysis.

Syntax

CHISQ.INV(probability, deg_freedom)

• probability: A numeric value representing the probability associated with the chi-squared distribution.
• deg_freedom: An integer representing the degrees of freedom for the distribution.

Example #1

CHISQ.INV(0.05, 10)

This function call computes the chi-squared value at 5% probability for 10 degrees of freedom. The result is approximately 18.307.

Example #2

CHISQ.INV(0.95, 20)

This function call calculates the chi-squared value at a 95% probability with 20 degrees of freedom, resulting in about 31.410.

Example #3

CHISQ.INV(0.50, 15)

This call finds the chi-squared value at a 50% probability for 15 degrees of freedom, yielding approximately 10.645.

Error handling

• NUM!: This error occurs when the probability is less than 0 or greater than 1, or when the degrees of freedom are less than 1.
• VALUE!: This error suggests that the function received a non-numeric value for either parameter.

Conclusion

In summary, the CHISQ.INV function is an essential statistical tool in Google Sheets for researchers and analysts who need to perform chi-squared distribution analyses. By understanding its syntax and parameters, one can apply this function effectively in various statistical contexts to derive meaningful results.