In: Statistics and Probability
A sample of parts provided the following contingency table data on 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 is independent of the production shift. What is your conclusion? Please explain the computation in Excel all the needed functions to resolve the solution so that I can understand the concept of Excel procedures. Explain the computation of the chi-square test statistics for determining whether the column variable independent of the row variable. As well as area in the upper tail and degree of freedom. Thank you very much for your support and help