CHITEST(actual_range, expected_range)

Returns the value from the 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.

Remarks

* CHISQ.TEST was added in Excel 2010 to replace this function.
* The ch-squared distribution is a continuous distribution.
* Returns the test for independence.
* This function returns the value from the chi-squared (?2) distribution for the statistic and the appropriate degrees of freedom.
* You can use ?2 tests to determine whether hypothesized results are verified by an experiment.
* If "actual_range" and "expected_range" have a different number of data points, then #N/A is returned.
* In Excel 2010 the accuracy of this function was improved.
* For the Microsoft documentation refer to support.office.com

 AB
1=CHITEST({2,3,4,5,6},{1,2,3,4,5}) = 0.6810
2=CHITEST(B1:B2,B1:B2) = 120
3=CHITEST(B1:B2,B3) = #N/A30
4=CHITEST(1,"some text") = #N/A 


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