PLEASE SHOW ALL EXCEL WORK INCLUDING THE FIRST PART, CATEGORIZING THE EMPLOYEES INTO 1, 2, 3, 4. 1-7 ARE CLERICAL OR TECHNICAL, 8-9 ARE SKILLED 10-12 ARE SUPERVISORY, 13-17 ARE MANAGEMENT.

Problem 2: Is there a significant difference, at 5% level of significance, in the average evaluation scores of employees of different job types? The type of job contained in a variable called "JOB", type where a " 1 " indicates clerical and technical staff, a " 2 " indicates skilled employees, a " 3 " indicates supervisory positions, and a " 4 " indicates management positions. 1. State the null and alternative hypotheses. (5 points) 2. Calculate the test statistic. (5 points) 3. Find the critical value or the p-value. ( 5 points) 4. State your decision and conclusion in the context of the problem. (5 points) \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|c|} \hline A & B & C & D & E & F & G & H & 1 & J & K & L \\ \hline SCORE & AG & EMP@EO & POS@EO & DEPT & GRADE & EDUC & EMP@EV/ & POS@E/ & TYPE & JOB & HERE \\ \hline 184 & -7 & 7.29 & 7.29 & 40 & 8 & 13 & 7.12 & 7.12 & 1 & 2 & 1 \\ \hline 155 & 9 & 2.92 & 2.12 & 55 & 13 & 13 & 1.82 & 1.02 & 1 & 4 & 1 \\ \hline 132 & 21 & 0.77 & 0.77 & 55 & 13 & 16 & 0.31 & 0.31 & 0 & 4 & 1 \\ \hline 118 & -7 & 0.8 & 0.8 & 55 & 4 & 13 & 0.23 & 0.23 & 0 & 1 & 1 \\ \hline 102 & 15 & 13.78 & 4.7 & 41 & 2 & 12 & 13.16 & 4.07 & 1 & 1 & 1 \\ \hline 178 & 4 & 9.65 & 9.65 & 64 & 3 & 12 & 9.02 & 9.01 & 1 & 1 & 1 \\ \hline 115 & 2 & 2.19 & 2.19 & 41 & 9 & 16 & 2.15 & 2.15 & 1 & 2 & 1 \\ \hline 128 & 13 & 0.5 & 0.5 & 62 & 8 & 16 & 0.29 & 0.29 & 0 & 2 & 1 \\ \hline 99 & 35 & 12.76 & 2.73 & 62 & 2 & 12 & 12.1 & 2.07 & 1 & 1 & 1 \\ \hline 133 & -2 & 4.49 & 0.51 & 71 & 11 & 16 & 4.23 & 0.25 & 0 & 3 & 1 \\ \hline 158 & 12 & 5.14 & 2.04 & 55 & 10 & 12 & 4.13 & 1.03 & 1 & 3 & 1 \\ \hline 125 & 0 & 6.94 & 6.94 & 62 & 8 & 16 & 6 & 6 & 1 & 2 & 1 \\ \hline 113 & 2 & 1.88 & 0.39 & 73 & 8 & 14 & 1.75 & 0.26 & 0 & 2 & 1 \\ \hline 121 & -12 & 6.35 & 0.28 & 73 & 17 & 18 & 6.29 & 0.22 & 0 & 4 & 1 \\ \hline 172 & 10 & 3.78 & 3.78 & 72 & 8 & 16 & 3.03 & 3.03 & 1 & 2 & 1 \\ \hline 159 & 49 & 11.7 & 11.7 & 64 & 8 & 14 & 11.67 & 11.67 & 1 & 2 & 1 \\ \hline 135 & 14 & 6.1 & 3.17 & 55 & 4 & 13 & 5.83 & 2.9 & 1 & 1 & 1 \\ \hline 155 & 7 & 7.59 & 5.29 & 55 & 10 & 18 & 7.32 & 5.02 & 1 & 3 & 1 \\ \hline 128 & 22 & 0.56 & 0.56 & 41 & 2 & 13 & 0.31 & 0.31 & 0 & 1 & 1 \\ \hline 127 & 62 & 3.42 & 3.42 & 73 & 10 & 16 & 3.17 & 3.17 & 1 & 3 & 1 \\ \hline 134 & 45 & 0.31 & 0.31 & 62 & 8 & 16 & 0.37 & 0.37 & 0 & 2 & 1 \\ \hline 126 & 13 & 0.77 & 0.44 & 55 & 2 & 12 & 0.29 & 0.05 & 0 & 1 & 1 \\ \hline 131 & 16 & 4.24 & 4.24 & 41 & 10 & 18 & 4.05 & 4.05 & 1 & 3 & 1 \\ \hline 136 & -2 & 0.96 & 0.96 & 55 & 2 & 12 & 0.24 & 0.24 & 0 & 1 & 1 \\ \hline 155 & 8 & 0.37 & 0.37 & 41 & 11 & 16 & 0.27 & 0.27 & 0 & 3 & 1 \\ \hline 125 & 17 & 0.42 & 0.42 & 40 & 13 & 16 & 0.3 & 0.3 & 0 & 4 & 1 \\ \hline 128 & 21 & 0.39 & 0.39 & 72 & 8 & 14 & 0.31 & 0.31 & 0 & 2 & 1 \\ \hline 164 & 3 & 4.87 & 4.87 & 64 & 8 & 14 & 4.01 & 4.01 & 1 & 2 & 1 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|c|} \hline A & B & C & D & & & G & H & 1 & & K & L \\ \hline 121 & 23 & 1.69 & 0.71 & 55 & 2 & 14 & 1.29 & 0.31 & 0 & 1 & 1 \\ \hline 160 & -14 & 1.42 & 1.42 & 72 & 8 & 14 & 0.96 & 0.96 & 1 & 2 & 1 \\ \hline 162 & -1 & 12.58 & 3.99 & 72 & 13 & 14 & 11.59 & 3 & 1 & 4 & 1 \\ \hline 155 & 4 & 2.86 & 2.86 & 72 & 8 & 14 & 2.01 & 2.01 & 1 & 2 & 1 \\ \hline 124 & -2 & 5.32 & 0.51 & 73 & 10 & 16 & 5.05 & 0.25 & 0 & 3 & 1 \\ \hline 141 & 12 & 1.42 & 0.74 & 73 & 5 & 14 & 0.96 & 0.28 & 0 & 1 & 1 \\ \hline 124 & 13 & 1.24 & 1.24 & 61 & 8 & 14 & 1.04 & 1.04 & 1 & 2 & 1 \\ \hline 131 & 79 & 4.76 & 4.76 & 63 & 8 & 14 & 4.22 & 4.22 & 1 & 2 & 1 \\ \hline 111 & 9 & 4.35 & 2.69 & 73 & 3 & 12 & 3.69 & 2.02 & 1 & 1 & 1 \\ \hline 135 & 10 & 4.01 & 0.56 & 62 & 10 & 14 & 3.7 & 0.28 & 0 & 3 & 1 \\ \hline 164 & 33 & 7.64 & 7.64 & 64 & 8 & 14 & 7.6 & 7.6 & 1 & 2 & 1 \\ \hline 127 & 5 & 0.46 & 0.46 & 62 & 8 & 14 & 0.27 & 0.27 & 0 & 2 & 1 \\ \hline 111 & 3 & 4.91 & 0.51 & 73 & 10 & 16 & 4.67 & 0.26 & 0 & 3 & 1 \\ \hline 171 & 31 & 8.1 & 6.5 & 61 & 3 & 12 & 7.68 & 6.09 & 1 & 1 & 1 \\ \hline 123 & 27 & 2.73 & 2.73 & 74 & 8 & 14 & 2.07 & 2.07 & 1 & 2 & 1 \\ \hline 128 & 15 & 0.94 & 0.94 & 62 & 8 & 16 & 0.29 & 0.29 & 0 & 2 & 1 \\ \hline 128 & -6 & 0.63 & 0.63 & 62 & 8 & 16 & 0.24 & 0.24 & 0 & 2 & 1 \\ \hline 132 & -12 & 0.88 & 0.88 & 70 & 6 & 16 & 0.21 & 0.21 & 1 & 1 & 1 \\ \hline 173 & 34 & 8.73 & 8.73 & 63 & 8 & 14 & 8.1 & 8.1 & 1 & 2 & 1 \\ \hline 126 & 36 & 0.9 & 0.54 & 72 & 3 & 12 & 0.72 & 0.35 & 0 & 1 & 1 \\ \hline 120 & 8 & 2.96 & 1.13 & 62 & 8 & 14 & 2.02 & 0.2 & 0 & 2 & 1 \\ \hline 121 & 30 & 0.96 & 0.96 & 65 & 3 & 12 & 0.33 & 0.33 & 0 & 1 & 1 \\ \hline 111 & 12 & 0.92 & 0.92 & 74 & 8 & 14 & 0.28 & 0.28 & 0 & 2 & 1 \\ \hline 129 & 58 & 0.96 & 0.96 & 61 & 3 & 14 & 0.41 & 0.41 & 0 & 1 & 1 \\ \hline 132 & 9 & 2.52 & 2.52 & 71 & 10 & 16 & 2.07 & 2.07 & 1 & 3 & 1 \\ \hline 75 & 10 & 10.9 & 6.5 & 55 & 10 & 16 & 10.92 & 6.53 & 1 & 3 & 1 \\ \hline 157 & 6 & 12.76 & 12.76 & 73 & 4 & 12 & 12.02 & 12.02 & 1 & 1 & 1 \\ \hline 155 & 20 & 7.39 & 3.12 & 73 & 13 & 16 & 7.33 & 3.05 & 1 & 4 & 1 \\ \hline 152 & -2 & 3.28 & 3.28 & 62 & 8 & 14 & 2.99 & 2.99 & 1 & 2 & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|c|} \hline A & B & C & D & E & F & G & H & 1 & & K & L \\ \hline 152 & 8 & 1.96 & 1.96 & 62 & 2 & 12 & 1.02 & 1.02 & 1 & 1 & 1 \\ \hline 115 & 69 & 0.46 & 0.32 & 72 & 3 & 12 & 0.58 & 0.44 & 0 & 1 & 1 \\ \hline 80 & 8 & 0.48 & 0.48 & 41 & 4 & 12 & 0.27 & 0.27 & 0 & 1 & 1 \\ \hline 115 & 15 & 2.13 & 0.36 & 41 & 5 & 16 & 2.06 & 0.29 & 0 & 1 & 1 \\ \hline 134 & -8 & 7.35 & 0.28 & 61 & 13 & 14 & 7.3 & 0.23 & 0 & 4 & 1 \\ \hline 132 & 10 & 1.69 & 0.74 & 55 & 3 & 13 & 1.23 & 0.28 & 0 & 1 & 1 \\ \hline 137 & 19 & 12.7 & 0.28 & 55 & 17 & 18 & 12.72 & 0.3 & 0 & 4 & 1 \\ \hline 129 & 12 & 2.7 & 0.94 & 62 & 3 & 13 & 2.047 & 0.28 & 0 & 1 & 1 \\ \hline 154 & 11 & 16.85 & 13.51 & 41 & 14 & 14 & 16.59 & 13.25 & 1 & 4 & 1 \\ \hline 113 & 2 & 5.9 & 0.98 & 71 & 13 & 14 & 5.18 & 0.25 & 0 & 4 & 1 \\ \hline 104 & 5 & 1.99 & 1.99 & 55 & 2 & 12 & 1.01 & 1.01 & 1 & 1 & 0 \\ \hline 131 & -4 & 1.1 & 1.1 & 72 & 8 & 14 & 0.24 & 0.24 & 0 & 2 & 0 \\ \hline 117 & 34 & 0.81 & 0.81 & 62 & 8 & 14 & 0.35 & 0.35 & 0 & 2 & 0 \\ \hline 171 & -7 & 18.15 & 13.79 & 65 & 13 & 14 & 17.34 & 12.99 & 1 & 4 & 0 \\ \hline 90 & 9 & 1.19 & 1.19 & 74 & 8 & 14 & 0.28 & 0.28 & 0 & 2 & 0 \\ \hline 123 & 6 & 1.25 & 1.25 & 74 & 8 & 14 & 0.27 & 0.27 & 0 & 2 & 0 \\ \hline 101 & -3 & 8.25 & 4.49 & 62 & 13 & 16 & 7.76 & 3.99 & 1 & 4 & 0 \\ \hline 40 & 87 & 0.96 & 0.96 & 62 & 8 & 18 & 0.48 & 0.48 & 0 & 2 & 0 \\ \hline 117 & 6 & 2.8 & 2.8 & 74 & 8 & 14 & 2.02 & 2.02 & 1 & 2 & 0 \\ \hline 132 & 9 & 1.27 & 1.27 & 74 & 8 & 14 & 1.02 & 1.02 & 1 & 2 & 0 \\ \hline 159 & -14 & 1.84 & 1.84 & 72 & 2 & 18 & 0.96 & 0.96 & 1 & 1 & 0 \\ \hline 105 & 26 & 11.38 & 10.13 & 55 & 4 & 12 & 10.82 & 9.57 & 1 & 1 & 0 \\ \hline 106 & 6 & 2.05 & 0.64 & 73 & 8 & 14 & 1.68 & 0.27 & 0 & 2 & 0 \\ \hline 116 & 10 & 0.58 & 0.58 & 41 & 3 & 12 & 0.28 & 0.28 & 0 & 1 & 0 \\ \hline 171 & 21 & 2.74 & 2.74 & 62 & 8 & 16 & 2.06 & 2.06 & 1 & 2 & 0 \\ \hline 143 & 35 & 7.52 & 5.32 & 65 & 8 & 16 & 7.33 & 5.12 & 1 & 2 & 0 \\ \hline 90 & 3 & 0.65 & 0.65 & 74 & 8 & 14 & 0.26 & 0.26 & 0 & 2 & 0 \\ \hline 115 & 24 & 0.92 & 0.92 & 41 & 3 & 12 & 0.31 & 0.31 & 0 & 1 & 0 \\ \hline 117 & 10 & 0.42 & 0.42 & 71 & 8 & 16 & 0.28 & 0.28 & 0 & 2 & 0 \\ \hline \end{tabular}