Forum Discussion

elirodriguez2015's avatar
elirodriguez2015
Copper Contributor
Feb 14, 2025

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. 

Resources