CHISQ.TEST function | pearson's chi square excel
Returnsthetestforindependence.CHISQ.TESTreturnsthevaluefromthechi-squared(χ2)distributionforthestatisticandtheappropriatedegreesoffreedom.Youcanuseχ2teststodeterminewhetherhypothesizedresultsareverifiedbyanexperiment. Syntax CHISQ.TEST(actual_range,expected_range) TheCHISQ.TESTfunctionsyntaxhasthefollowingarguments: Actual_range Required.Therangeofdatathatcontainsobservationstotestagainstexpectedvalues. ...
Returns the test for independence. CHISQ.TEST 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.
SyntaxCHISQ.TEST(actual_range,expected_range)
The CHISQ.TEST function syntax has the following arguments:
Actual_range Required. The range of data that contains observations to test against expected values.
...