CHISQ.TEST(actual_range, expected_range)

Returns the probability value from a chi-squared distribution.

actual_rangeThe data containing observations to test against expected values.
expected_rangeThe data containing the ratio of the product of row totals and column totals to the grand total.

* Added in Excel 2010.
* This function replaces the CHITEST function.
* The chi-squared distribution is a continuous distribution.
* You can use the F.TEST function to
* You can use the T.TEST function to
* You can use the Z.TEST function to
* For the Microsoft documentation refer to

1=CHISQ.TEST(B1:C3,D1:E3) = 1.0010401040

© 2022 Better Solutions Limited. All Rights Reserved. © 2022 Better Solutions Limited Top