Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The company's manager is trying to determine which of the variables in the data have significant impact on the evaluation score. Specifically, the manager is

The company's manager is trying to determine which of the variables in the data have significant impact on the evaluation score. Specifically, the manager is interested in investigating the following variables to see which of these variables are significant predictors of the evaluation score. The variables include EMP@EVAL, POS@EVAL, TYPE and HERE. He needs your help.

1. Fit a multiple linear regression of "SCORE" on "EMP@EVAL", "POS@EVAL", "TYPE", and "HERE". (5 points)

2. Test the hypothesis that "H" _0: "All" B_j^' "s" = 0 vs. "H"_a: "Not all" B_j^' "s" = 0 (use .05 level of significance). (5 points)

3. Check the normality assumption. (5 points)

4. Interpret the coefficients estimates of your model in the context of the problem. (5 points)

5. Interpret the R-square value in the context of the problem. (5 points)

6. Predict the average performance score of all employees who have been employed and stayed at the same position for 9 years at the time ofperformance evaluation, received a one-year evaluation and is still with the company. (5 points)

SCORE LAG EMP@EOY POS@EOY DEPT GRADE EDUC EMP@E..S@EVAL TYPE JOB HERE
184 -7 7.289999962 7.289999962 40 8 13 7.119999886 7.119999886 1 2 1
155 9 2.920000076 2.119999886 55 13 13 1.820000052 1.019999981 1 4 1
132 21 0.769999981 0.769999981 55 13 16 0.310000002 0.310000002 0 4 1
118 -7 0.800000012 0.800000012 55 4 13 0.230000004 0.230000004 0 1 1
102 15 13.77999973 4.699999809 41 2 12 13.15999985 4.070000172 1 1 1
178 4 9.649999619 9.649999619 64 3 12 9.020000458 9.010000229 1 1 1
115 2 2.190000057 2.190000057 41 9 16 2.150000095 2.150000095 1 2 1
128 13 0.5 0.5 62 8 16 0.289999992 0.289999992 0 2 1
99 35 12.76000023 2.730000019 62 2 12 12.10000038 2.069999933 1 1 1
133 -2 4.489999771 0.509999991 71 11 16 4.230000019 0.25 0 3 1
158 12 5.139999866 2.039999962 55 10 12 4.130000114 1.029999971 1 3 1
125 0 6.940000057 6.940000057 62 8 16 6 6 1 2 1
113 2 1.879999995 0.389999986 73 8 14 1.75 0.259999991 0 2 1
121 -12 6.349999905 0.280000001 73 17 18 6.289999962 0.219999999 0 4 1
172 10 3.779999971 3.779999971 72 8 16 3.029999971 3.029999971 1 2 1
159 49 11.69999981 11.69999981 64 8 14 11.67000008 11.67000008 1 2 1
135 14 6.099999905 3.170000076 55 4 13 5.829999924 2.900000095 1 1 1
155 7 7.590000153 5.289999962 55 10 18 7.320000172 5.019999981 1 3 1
128 22 0.560000002 0.560000002 41 2 13 0.310000002 0.310000002 0 1 1
127 62 3.420000076 3.420000076 73 10 16 3.170000076 3.170000076 1 3 1
134 45 0.310000002 0.310000002 62 8 16 0.370000005 0.370000005 0 2 1
126 13 0.769999981 0.439999998 55 2 12 0.289999992 0.050000001 0 1 1
131 16 4.239999771 4.239999771 41 10 18 4.050000191 4.050000191 1 3 1
136 -2 0.959999979 0.959999979 55 2 12 0.239999995 0.239999995 0 1 1
155 8 0.370000005 0.370000005 41 11 16 0.270000011 0.270000011 0 3 1
125 17 0.419999987 0.419999987 40 13 16 0.300000012 0.300000012 0 4 1
128 21 0.389999986 0.389999986 72 8 14 0.310000002 0.310000002 0 2 1
164 3 4.869999886 4.869999886 64 8 14 4.010000229 4.010000229 1 2 1
90 27 0.74000001 0.74000001 72 2 12 0.319999993 0.319999993 0 1 1
146 -5 4.28000021 2.789999962 73 11 14 3.470000029 1.99000001 1 3 1
159 19 0.920000017 0.280000001 55 14 20 0.949999988 0.300000012 0 4 1
125 12 4.800000191 4.800000191 74 8 16 4.039999962 4.039999962 1 2 1
129 36 3.420000076 3.420000076 62 8 14 3.099999905 3.099999905 1 2 1
149 4 2.609999895 1.279999971 63 8 16 2.339999914 1.00999999 1 2 1
182 -7 7.340000153 7.340000153 72 10 16 6.980000019 6.980000019 1 3 1
172 42 3.75999999 2.339999914 62 10 14 3.789999962 2.380000114 1 3 1
137 -11 6.519999981 0.280000001 71 17 16 6.46999979 0.219999999 0 4 1
171 30 3.160000086 2.75 62 3 12 2.5 2.079999924 1 1 1
144 34 1.269999981 0.730000019 55 3 12 1.090000033 0.550000012 1 1 1
163 28 1.389999986 1.389999986 61 8 14 1.090000033 1.080000043 1 2 1
165 4 6.889999866 5.119999886 74 8 16 6.75 4.980000019 1 2 1
128 11 6.519999981 5.389999866 72 3 12 6.170000076 5.03000021 1 1 1
133 6 1.289999962 1.289999962 63 8 14 1.019999981 1.019999981 1 2 1
162 -5 4.949999809 4.949999809 64 8 14 3.99000001 3.99000001 1 2 1
119 8 0.529999971 0.529999971 65 8 16 0.270000011 0.270000011 0 2 1
131 34 0.370000005 0.370000005 74 4 12 0.349999994 0.349999994 0 1 1
149 62 2.420000076 0.74000001 55 9 12 2.099999905 0.419999987 0 2 1
167 24 0.370000005 0.370000005 41 2 12 0.319999993 0.319999993 0 1 1
136 13 1.309999943 1.309999943 63 3 14 1.039999962 1.039999962 1 1 1
150 21 0.560000002 0.560000002 41 2 14 0.310000002 0.310000002 0 1 1
135 8 0.810000002 0.810000002 73 10 14 0.270000011 0.270000011 0 3 1
176 64 17.23999977 17.23999977 62 3 12 17.19000053 17.19000053 1 1 1
115 19 0.330000013 0.330000013 72 8 18 0.300000012 0.300000012 0 2 1
155 0 5.860000134 5.860000134 65 3 12 5 5 1 1 1
127 -12 1.169999957 1.169999957 62 3 13 0.970000029 0.970000029 1 1 1
61 37 4.71999979 0.280000001 62 6 14 4.789999962 0.349999994 0 1 1
115 15 3.160000086 0.860000014 55 2 13 2.579999924 0.280000001 0 1 1
121 23 1.690000057 0.709999979 55 2 14 1.289999962 0.310000002 0 1 1
160 -14 1.419999957 1.419999957 72 8 14 0.959999979 0.959999979 1 2 1
162 -1 12.57999992 3.99000001 72 13 14 11.59000015 3 1 4 1
155 4 2.859999895 2.859999895 72 8 14 2.00999999 2.00999999 1 2 1
124 -2 5.320000172 0.509999991 73 10 16 5.050000191 0.25 0 3 1
141 12 1.419999957 0.74000001 73 5 14 0.959999979 0.280000001 0 1 1
124 13 1.24000001 1.24000001 61 8 14 1.039999962 1.039999962 1 2 1
131 79 4.760000229 4.760000229 63 8 14 4.21999979 4.21999979 1 2 1
111 9 4.349999905 2.690000057 73 3 12 3.690000057 2.019999981 1 1 1
135 10 4.010000229 0.560000002 62 10 14 3.700000048 0.280000001 0 3 1
164 33 7.639999866 7.639999866 64 8 14 7.599999905 7.599999905 1 2 1
127 5 0.460000008 0.460000008 62 8 14 0.270000011 0.270000011 0 2 1
111 3 4.909999847 0.509999991 73 10 16 4.670000076 0.259999991 0 3 1
171 31 8.100000381 6.5 61 3 12 7.679999828 6.090000153 1 1 1
123 27 2.730000019 2.730000019 74 8 14 2.069999933 2.069999933 1 2 1
128 15 0.939999998 0.939999998 62 8 16 0.289999992 0.289999992 0 2 1
128 -6 0.629999995 0.629999995 62 8 16 0.239999995 0.239999995 0 2 1
132 -12 0.879999995 0.879999995 70 6 16 0.209999993 0.209999993 1 1 1
173 34 8.729999542 8.729999542 63 8 14 8.100000381 8.100000381 1 2 1
126 36 0.899999976 0.540000022 72 3 12 0.720000029 0.349999994 0 1 1
120 8 2.960000038 1.129999995 62 8 14 2.019999981 0.200000003 0 2 1
121 30 0.959999979 0.959999979 65 3 12 0.330000013 0.330000013 0 1 1
111 12 0.920000017 0.920000017 74 8 14 0.280000001 0.280000001 0 2 1
129 58 0.959999979 0.959999979 61 3 14 0.409999996 0.409999996 0 1 1
132 9 2.519999981 2.519999981 71 10 16 2.069999933 2.069999933 1 3 1
75 10 10.89999962 6.5 55 10 16 10.92000008 6.53000021 1 3 1
157 6 12.76000023 12.76000023 73 4 12 12.02000046 12.02000046 1 1 1
155 20 7.389999866 3.119999886 73 13 16 7.329999924 3.049999952 1 4 1
152 -2 3.279999971 3.279999971 62 8 14 2.99000001 2.99000001 1 2 1
121 5 5.809999943 0.920000017 62 3 12 5.150000095 0.259999991 0 1 1
112 18 0.939999998 0.939999998 62 8 14 1.299999952 1.299999952 1 2 1
170 4 3.420000076 3.420000076 62 8 16 3.00999999 3.00999999 1 2 1
159 13 4.800000191 4.800000191 65 8 16 4.039999962 4.039999962 1 2 1
124 17 0.649999976 0.649999976 72 8 14 0.300000012 0.300000012 0 2 1
174 -7 3.440000057 3.440000057 62 8 16 2.980000019 2.980000019 1 2 1
120 9 2.440000057 1.129999995 74 13 16 1.580000043 0.280000001 0 4 1
139 0 1.960000038 0.889999986 55 10 14 1.309999943 0.239999995 0 3 1
139 0 2.75999999 2.75999999 72 2 12 2 2 1 1 1
160 -3 1.690000057 1.350000024 41 14 18 1.330000043 0.99000001 1 4 1
133 -3 5.349999905 5.349999905 72 8 14 4.989999771 4.989999771 1 2 1
147 14 7.559999943 7.559999943 64 8 16 7.559999943 7.559999943 1 2 1
126 15 0.519999981 0.519999981 61 8 18 0.289999992 0.289999992 0 2 1
112 -3 6.78000021 0.280000001 64 13 18 6.739999771 0.239999995 0 4 1
140 16 0.959999979 0.74000001 72 3 13 0.519999981 0.289999992 0 1 1
124 60 1.879999995 0.389999986 62 10 14 1.909999967 0.419999987 0 3 1
104 10 1.99000001 1.99000001 72 2 14 1.029999971 1.029999971 1 1 1
126 30 2.779999971 0.270000011 73 8 14 2.839999914 0.330000013 0 2 1
140 20 5.050000191 0.910000026 41 4 12 4.429999828 0.300000012 0 1 1
106 7 8.149999619 0.75 71 9 12 7.670000076 0.270000011 0 2 1
138 7 0.730000019 0.730000019 72 4 12 0.270000011 0.270000011 0 1 1
135 5 2.230000019 0.810000002 55 3 12 1.679999948 0.270000011 0 1 1
105 35 0.280000001 0.280000001 72 8 16 0.349999994 0.349999994 0 2 1
143 2 14.27000046 14.27000046 73 11 16 14.02999973 14.02999973 1 3 1
131 27 2.940000057 2.690000057 55 10 18 1.320000052 1.070000052 1 3 1
108 -10 11.27999973 0.280000001 74 17 14 11.22000027 0.219999999 0 4 1
171 -7 5.329999924 2.079999924 72 10 14 4.380000114 1.129999995 1 3 1
152 22 2.670000076 2.230000019 55 5 13 2.5 2.059999943 1 1 1
171 15 5.889999866 5.21999979 64 3 12 5.71999979 5.039999962 1 1 1
152 8 1.960000038 1.960000038 62 2 12 1.019999981 1.019999981 1 1 1
115 69 0.460000008 0.319999993 72 3 12 0.579999983 0.439999998 0 1 1
80 8 0.479999989 0.479999989 41 4 12 0.270000011 0.270000011 0 1 1
115 15 2.130000114 0.360000014 41 5 16 2.059999943 0.289999992 0 1 1
134 -8 7.349999905 0.280000001 61 13 14 7.300000191 0.230000004 0 4 1
132 10 1.690000057 0.74000001 55 3 13 1.230000019 0.280000001 0 1 1
137 19 12.69999981 0.280000001 55 17 18 12.72000027 0.300000012 0 4 1
129 12 2.700000048 0.939999998 62 3 13 2.046999931 0.280000001 0 1 1
154 11 16.85000038 13.51000023 41 14 14 16.59000015 13.25 1 4 1
113 2 5.900000095 0.980000019 71 13 14 5.179999828 0.25 0 4 1
104 5 1.99000001 1.99000001 55 2 12 1.00999999 1.00999999 1 1 0
131 -4 1.100000024 1.100000024 72 8 14 0.239999995 0.239999995 0 2 0
117 34 0.810000002 0.810000002 62 8 14 0.349999994 0.349999994 0 2 0
171 -7 18.14999962 13.78999996 65 13 14 17.34000015 12.98999977 1 4 0
90 9 1.190000057 1.190000057 74 8 14 0.280000001 0.280000001 0 2 0
123 6 1.25 1.25 74 8 14 0.270000011 0.270000011 0 2 0
101 -3 8.25 4.489999771 62 13 16 7.760000229 3.99000001 1 4 0
40 87 0.959999979 0.959999979 62 8 18 0.479999989 0.479999989 0 2 0
117 6 2.799999952 2.799999952 74 8 14 2.019999981 2.019999981 1 2 0
132 9 1.269999981 1.269999981 74 8 14 1.019999981 1.019999981 1 2 0
159 -14 1.840000033 1.840000033 72 2 18 0.959999979 0.959999979 1 1 0
105 26 11.38000011 10.13000011 55 4 12 10.81999969 9.569999695 1 1 0
106 6 2.049999952 0.639999986 73 8 14 1.679999948 0.270000011 0 2 0
116 10 0.579999983 0.579999983 41 3 12 0.280000001 0.280000001 0 1 0
171 21 2.74000001 2.74000001 62 8 16 2.059999943 2.059999943 1 2 0
143 35 7.519999981 5.320000172 65 8 16 7.329999924 5.119999886 1 2 0
90 3 0.649999976 0.649999976 74 8 14 0.259999991 0.259999991 0 2 0
115 24 0.920000017 0.920000017 41 3 12 0.310000002 0.310000002 0 1 0
117 10 0.419999987 0.419999987 71 8 16 0.280000001 0.280000001 0 2 0

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

College Algebra

Authors: Murray R Spiegel, Robert E Moyer

4th Edition

0071825851, 9780071825856

More Books

Students also viewed these Mathematics questions

Question

5. Are process tasks and capacity configured appropriately?

Answered: 1 week ago