A sample of parts provided the following contingency table dataon part quality by production shift.
Shift Number Good Number Defective
First 368 32
Second 285 Â Â 15
Third 176 24
Use a=.05 and test the hypothesis that part quality isindependent of the production shift. What is your conclusion?Please explain the computation in Excel all the needed functions toresolve the solution so that I can understand the concept of Excelprocedures. Explain the computation of the chi-square teststatistics for determining whether the column variable independentof the row variable. As well as area in the upper tail and degreeof freedom. Thank you very much for your support and help
