Home › Functions › Statistical › CHISQ.TEST
fx
CHISQ.TEST
Statistical  ·  Since: Excel 2003  ·  9 languages

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.

🌐 Translations

English CHISQ.TEST
Deutsch CHIQU.TEST
Français CHISQ.TEST
Español PRUEBA.CHICUAD
Italiano TEST.CHI.QUAD
Português TESTE.QUIQUA
Nederlands CHIKW.TEST
Polski CHI.TEST
Русский ХИ2.ТЕСТ

📦 Availability

Excel versionAvailable
Excel 2007 ✓
Excel 2013 ✓
Excel 2019 ✓
Excel 2021 ✓
Microsoft 365 ✓
Translate a formula with this function
fx EN
fx DE

⌨ Syntax

CHISQ.TEST(actual_range,expected_range)

Arguments

actual_range (required) — The range of data that contains observations to test against expected values.
expected_range (required) — The range of data that contains the ratio of the product of row totals and column totals to the grand total.

▶ Examples

=CHISQ.TEST(A2:B4,A6:B8)

Related functions

Copied to clipboard