# CHISQ.TEST

CHISQ.TEST(actual_range, expected_range)

Returns the probability value from a chi-squared distribution.

 actual_range The data containing observations to test against expected values. expected_range The data containing the ratio of the product of row totals and column totals to the grand total.

 REMARKS
 * This function was added in Excel 2010 to replace the CHITEST function.* The chi-squared distribution is a [[continuous distribution]]* You can use the CHISQ.DIST function to return the probability distribution function OR the cumulative probability function for a chi-squared distribution (left tailed).* You can use the CHISQ.DIST.RT function to return the probability distribution function for a chi-squared distribution (right tailed) (no cumulative).* You can use the CHISQ.INV function to return the inverse of the probability distribution function for a chi-squared distribution (left tailed).* You can use the CHISQ.INV.RT function to return the inverse of the probability distribution function for a chi-squared distribution (right tailed) (no cumulative).* This is similar to the F.TEST, T.TEST and Z.TEST functions.* For the Microsoft documentation refer to support.microsoft.com

 A B C D E 1 =CHISQ.TEST(B1:C3, D1:E3) = 1.00 10 40 10 40 2 blank 20 50 20 50 3 blank 30 60 30 60