10. The owner of a moving company typically has his most experienced manager predict the total number of labor hours that will be required to complete an upcoming move. This approach has proved useful in the past, but the owner has the business objective of developing a more accurate method of predicting labor hours. In a preliminary effort to provide a more accurate method, the owner has decided to use the number of cubic feet moved (11), the mimber of pieces of large furniture (ra) and whether there is an elevator in the apartment building (its = 1 if yes, 13 = 0 if no) as the independent variables and has collected data for 36 moves (Data: Moving). (a) Find the estimated regression equation for predicting labor hours, using the mumber of cubic feet moved, the number of pieces of large furniture and whether there is an elevator. 3 (b) Interpret the regression coefficients. (c) Determine whether there is a significant relationship between labor hours and the three independent variables at the 0.05 level of significance. (l) At the 0.05 level of significance, test whether the number of pieces of large furniture makes a significant contribution to the regression model (c) At the 0.05 level of significance, test whether the number of cubic feet moved can be dropped from the regression model. moving delivery Cases 52 64 73 85 95 103 116 121 143 157 161 184 202 218 243 254 267 275 287 298 Time 32.1 34.8 36.2 37.8 37.8 39.7 38.5 41.9 44.2 47.1 43 49.4 57.2 56.8 60.6 61.2 58.2 63.1 65.6 67.3 moving delivery X3 1 1 0 0 X2 3 2 2 2 1 3 2 1 6 1 1 1 1 1 1 1 4 1 1 4 Y 24.00 13.50 26.25 25.00 9.00 20.00 22.00 11.25 50.00 12.00 38.75 40.00 19.50 18.00 28.00 27.00 21.00 15.00 25.00 45.00 29.00 21.00 22.00 16.50 37.00 32.00 34.00 25.00 31.00 24.00 40.00 27.00 18.00 62.50 53.75 79.50 XI 545 400 562 540 220 344 569 340 900 285 865 831 344 360 750 650 415 275 S57 1028 793 523 564 312 757 600 796 577 500 695 1054 486 442 1249 995 1397 3 2 3 2 2 2 2 5 4 3 3 2 3 3 3 3 4 3 4 3 2 5 6 7 1 1 1 1 0 1 1 1 1 1 1 1 0 0 1 1 1 1 1 1 1 0 1 0