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 of large furniture as the independent variables and has collected data for 36 moves in which the origin and destination were within the borough of Manhattan in New York City and the travel time was an insignificant portion of the hours worked.
Hours | Feet | Large | Elevator |
24.00 | 545 | 3 | Yes |
13.50 | 400 | 2 | Yes |
26.25 | 562 | 2 | No |
25.00 | 540 | 2 | No |
9.00 | 220 | 1 | Yes |
20.00 | 344 | 3 | Yes |
22.00 | 569 | 2 | Yes |
11.25 | 340 | 1 | Yes |
50.00 | 900 | 6 | Yes |
12.00 | 285 | 1 | Yes |
38.75 | 865 | 4 | Yes |
40.00 | 831 | 4 | Yes |
19.50 | 344 | 3 | Yes |
18.00 | 360 | 2 | Yes |
28.00 | 750 | 3 | Yes |
27.00 | 650 | 2 | Yes |
21.00 | 415 | 2 | No |
15.00 | 275 | 2 | Yes |
25.00 | 557 | 2 | Yes |
45.00 | 1028 | 5 | Yes |
29.00 | 793 | 4 | Yes |
21.00 | 523 | 3 | Yes |
22.00 | 564 | 3 | Yes |
16.50 | 312 | 2 | Yes |
37.00 | 757 | 3 | No |
32.00 | 600 | 3 | No |
34.00 | 796 | 3 | Yes |
25.00 | 577 | 3 | Yes |
31.00 | 500 | 4 | Yes |
24.00 | 695 | 3 | Yes |
40.00 | 1054 | 4 | Yes |
27.00 | 486 | 3 | Yes |
18.00 | 442 | 2 | Yes |
62.50 | 1249 | 5 | No |
53.75 | 995 | 6 | Yes |
79.50 | 1397 | 7 | No |
a.) State the multiple regression equation and interpret the meaning of the slopes in this equation.
b.) Predict the mean labor hours for moving 500 cubic feet with two large pieces of furniture.
c.) Determine whether there is a significant relationship between labor hours and the two independent variables at the 0.05 level of significance? Explain.
d.) At the 0.05 level of significance, determine whether each independent variable makes a significant contribution to the regression model. Explain.
e.) Construct a 95% confidence interval estimate of the population slope between labor hours and the number of cubic feet moved.
f.) What conclusions can you reach concerning labor hours?
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 as the independent variable and...
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 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...
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...
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....
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...
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...
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...