See attached file for table.
Please solve the exercise below in Excel and show your work (and formulas)
4. Consider the 3X2 contingency table below
Factor A B1 B2
A1 16 14
A2 15 25
A3 9 21
At a significance level of 0.10, test H0: the factors A and B are independent
The solution provides step by step method for the calculation of chi square test for association. Formula for the calculation and Interpretations of the results are also included. Interactive excel sheet is included. The user can edit the inputs and obtain the complete results for a new set of data.