!Do all calculations witin excel!

!Please show formulas if used!

2. The sample data found in Moving Data have been collected by the owner of a moving company who wishes to predict the total number of labor hours that will be required to complete future moving jobs . The owner has gathered data from previous jobs on labor hours , the number of cubic feet moved the number of pieces of large furniture and whether or not there is an elevator in the building .

Apply the use of binary variables.

A) Which variables are the explanatory (independent ) variables?

B) Which variable is the response ( dependent ) variable?

Run the correlation analysis to produce the correlation matrix .

C) Which independent variables appear to have high correlation with the response variable?

D) Is there any indication of multicollinearity (correlation between the independent variables )

Run the regression analysis ( use all of the data )

E) What is the coefficient of multiple determination - how would you interpret it?

F) Write the hypotheses for the Global Test of the slopes .

2. The sample data found in Moving Data have been collected by the owner of a moving company who wishes to predict the total number of labor hours that will be required to complete future moving jobs. The owner has gathered data from previous jobs on labor hours, the number of cubic feet moved, the number of pieces of large furniture and whether or not there is an elevator in the building. (Read text section 4.8 for use of binary variables) Copy the data into your Excel spreadsheet O a. Which variables are the explanatory (independent) variables? b. Which variable is the response (dependent) variable? Run the correlation analysis to produce the correlation matrix. c. Which independent variables appear to have high correlation with the response variable? d. Is there any indication of multicollinearity (correlation between the independent variables) Run the regression analysis (use all of the data) e. What is the coefficient of multiple determination - how would you interpret it? f. Write the hypotheses for the Global Test of the slopes. B 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 A C D Number of Labor Hours Cubic Feet large pieces Elevator ex 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 Lectia 11 Octionart 1 Question 2 31 32 B C D E 360 750 2 Yes 3 Yes 2 Yes 650 21 22 23 24 25 26 27 28 29 30 415 275 557 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 1028 793 2 No 2 Yes 2 Yes 5 Yes 4 Yes 3 Yes 3 Yes 523 564 312 2 Yes 3 No 757 600 31 32 33 34 35 36 37 38 39 40 796 577 500 695 1054 34.00 25.00 31.00 24.00 40.00 27.00 18.00 62.50 53.75 79.50 3 No 3 Yes 3 Yes 4 Yes 3 Yes 4 Yes 3 Yes 2 Yes 5 No 6 Yes 7 No 486 41 442 1249 995 1397 42 43 44