Excel Function : CHISQ.TEST

Download now!

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.