5. A car manufacturer has four plants, say Plants A,B,C and D. The CEO would like to know if worker ratings differ among the four plants. You (VP of HR) must decide if the workers rating differ proportionately among the plants. You randomly select 239 worker ratings from the four plants. The table below shows the number of workers rated as exceeding expectations, meeting expectations, or below expectations.
Rating PLANT A PLANT B PLANT C PLANT D
Exceeds expectations 13 12 10 9
Meets expectations 34 36 46 33
Below expectations 6 15 14 11
A.) STATE THE NULL AND ALTERNATE HYPOTHESIS
B.) IF H0 IS TRUE, WHAT IS THE EXPECTED NUMBER OF WORKERS RATED "EXCEEDS EXPECTATIONS" IN PLANT C?
C.) WHAT DO YOU REPORT TO THE CEO AND WHY?
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.