Excel Function : CHISQ.TEST
Category
Statistical
Description
Returns the test for independence
Microsoft Excel Reference Page
https://support.office.com/en-us/article/CHISQTEST-function-2e8a7861-b14a-4985-aa93-fb88de3f260f
Syntax and Description of the CHISQ.TEST Excel Function
. =CHISQ.TEST(actual_range, expected_range)
About CHISQ.TEST Excel Function
The CHISQ.TEST function in Excel calculates the probability that the observed frequencies in a data set are from a certain distribution. The function takes two arguments: the data set and the expected frequencies. The data set must be a one-dimensional array of positive integers. The expected frequencies can be either a one-dimensional array or a two-dimensional array. If the expected frequencies are a one-dimensional array, the array must have the same length as the data set. If the expected frequencies are a two-dimensional array, the array must have the same number of rows as the data set and the same number of columns as the expected frequencies.
