Forum Discussion
elirodriguez2015
Feb 14, 2025Copper Contributor
Analysis ToolPak Chi Squared test for independence
I recently had someone show me that through Analysis ToolPak, a chi-squared test can be performed in excel similar to other statistical programs such as SPSS. She just created the 2 x 2 contingency table and used data analysis to perform the function; however, after adding it into my personal computer (i have microsoft 365 Family), i cannot find the function under the data analysis section. Is there an easier way to do a chi squared test for independence that does not include working through all of the steps in excel or a good statistical add in which will perform the functions for me so I can work through the data analysis quickly.
- JKPieterseSilver Contributor
Have you tried to google for this? I get a number of seemingly relevant hits, including this one: https://real-statistics.com/chi-square-and-f-distributions/independence-testing/