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 as the independent variable and has collected data for 36 moves in which the origin and destination were within the borough of Manhattan in New York City and in which the travel time was an insignificant portion of the hours worked.
A | B | C | D | |
1 | Hours | Feet | Large | Elevator |
2 | 24 | 545 | 3 | yes |
3 | 13.5 | 400 | 2 | yes |
4 | 26.25 | 562 | 2 | no |
5 | 25 | 540 | 2 | no |
6 | 9 | 220 | 1 | yes |
7 | 20 | 344 | 3 | yes |
8 | 22 | 569 | 2 | yes |
9 | 11.25 | 340 | 1 | yes |
10 | 50 | 900 | 6 | yes |
11 | 12 | 285 | 1 | yes |
12 | 38.75 | 865 | 4 | yes |
13 | 40 | 831 | 4 | yes |
14 | 19.5 | 344 | 3 | yes |
15 | 18 | 360 | 2 | yes |
16 | 28 | 750 | 3 | yes |
17 | 27 | 650 | 2 | yes |
18 | 21 | 415 | 2 | no |
19 | 15 | 275 | 2 | yes |
20 | 25 | 557 | 2 | yes |
21 | 45 | 1028 | 5 | yes |
22 | 29 | 793 | 4 | yes |
23 | 21 | 523 | 3 | yes |
24 | 22 | 564 | 3 | yes |
25 | 16.5 | 312 | 2 | yes |
26 | 37 | 575 | 3 | no |
27 | 32 | 600 | 3 | no |
28 | 34 | 796 | 3 | yes |
29 | 25 | 577 | 3 | yes |
30 | 31 | 500 | 4 | yes |
31 | 24 | 695 | 3 | yes |
32 | 40 | 1054 | 4 | yes |
33 | 27 | 486 | 3 | yes |
34 | 18 | 442 | 2 | yes |
35 | 62.5 | 1249 | 5 | no |
36 | 53.75 | 995 | 6 | yes |
37 | 79.5 | 1397 | 7 | no |
A) Construct a scatter plot.
B) Assuming a linear relationship, use the least-squares method to determine the regression coefficients b0 and b1.
C) Interpret the meaning of the slope, b1, in this problem.
D) Predict the mean labor hours for moving 500 cubic feet.
E) What should you tell the owner of the moving company about the relationship between cubic feet moved and labor hours?
Please show all work in detail.
The answers are obtained using R-software. Code and output are attached below along with the graph.
The owner of a moving company typically has his most experienced manager predict the total number...
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 and the number of pieces...
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. In a effort to provide a more accurate method, the owner has decided to use the number of cubic feet moved as the independent variable and has collected data for 20 moves in which the travel time was an insignificant portion of the hours worked. Use the data provided to complete parts...
13.50 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 ob-jective 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 and the number of...
The owner of a TIoving company typically has his riost experienced manager predict the total number of labor hours that will be required to complete an upcoming move. In an effort to provide a more accurate method, the owner has Use the data provided to complete parts (a) which the travel tirme was aı insignificant portion of the hours worker number of cubic feet moved as the independent variable and has collected data for 20 moves through (d) below EClick...
The owner of a moving company usually has her most experienced manager predict the total number of labor hours required to complete a move. While useful, the owner is interested in a more accurate method of predicting the number of labor hours required. As a preliminary effort, data was collected on the number of work hours required to complete a move, number of cubic feet moved, the number of large pieces, and if an elevator was present. How much correlation...
The owner of a moving company wants to predict labor hours, based on the number of cubic feet moved. A total of 34 observations were made. An analysis of variance of these data showed that b1=0.0426 and Upper Sb1=0.0065. a. At the 0.05 level of significance, is there evidence of a linear relationship between the number of cubic feet moved and labor hours? b. Construct a 95% confidence interval estimate of the population slope β1. a. Determine the hypotheses for...
Trying to avoid over- or under-allocating labour hours in a particular moving job, the owner of a moving company would like to develop a better method of predicting labour hours (Duration; measured in hours) by using the size of the apartment (Size; measured in cubic feet) moved. A random sample of 36 moves in the past year was randomly selected in the borough of Manhattan in New York City. The data set “S1181 HW2 Q5 Data.xlsx” is available on D2L....
Cubic_Feet_Moved Labor_Hours 552 22.50 567 24.25 565 21.25 518 20.00 647 25.75 256 11.00 667 31.25 555 25.00 329 14.00 686 31.50 539 25.50 810 38.00 355 12.00 465 22.75 624 29.00 400 16.25 720 31.75 680 29.50 719 29.50 714 33.75 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. In an effort to provide a more accurate method, the...
Cubic_Feet_Moved Labor_Hours 552 22.50 567 24.25 565 21.25 518 20.00 647 25.75 256 11.00 667 31.25 555 25.00 329 14.00 686 31.50 539 25.50 810 38.00 355 12.00 465 22.75 624 29.00 400 16.25 720 31.75 680 29.50 719 29.50 714 33.75 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. In an effort to provide a more accurate method, the...
PLEASE SHOW ALL EXCEL FORMULAS USED FOR EACH CALCULATIONS. A STEP BY STEP WALKTHROUGH OF HOW TO DO THE PROBLEM. Thank you so much for your help! Hours Feet Elevator Elevator code 24.00 545 Yes 1 13.50 400 Yes 1 26.25 562 No 0 25.00 540 No 0 9.00 220 Yes 1 20.00 344 Yes 1 22.00 569 Yes 1 11.25 340 Yes 1 50.00 900 Yes 1 12.00 285 Yes 1 38.75 865 Yes 1 40.00 831 Yes 1...