View the step-by-step solution to:

Week 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 Standby_Hours Total_Staff_Present Remote_Hours 241 339 417 179 336 595 278 360 653 216 378


 

The regression model Yi = - 309.37191+1.62092X1i −0.08070 X2i predicts standby hours based on total staff present X1i, and remote hours, X2i ,for week i. The data from which the model was constructed are provided. Use the regression model and the data to complete(a) through(c) below.

a. Perform a residual analysis on the results.
1)Plot the residuals versus Yi.
2) Plot the residuals versus X1i.

3) Plot the residuals versus X2i

4) Make a conclusion regarding the regression model. Choose the correct answer below

A. There appears to be a quadratic relationship in each of the residual plots. The model appears to be adequate. 

B. There is no particular pattern in the plots. The model appears to be adequate. 

C. There is no particular pattern in the plots. The model is not adequate. 

D. There appears to be a quadratic relationship in each of the residual plots. 
The model is not adequate. 

b. If appropriate, perform the Durbin-Watson test, using alphaαequals=0.05.
Determine the Durbin-Watson statistic. Select the correct choice below and, if necessary, fill in the answer box to complete your choice.

A. D= ____ (Round to two decimal places as needed.) B. The test is not appropriate.




Week Standby_Hours Total_Staf_Present Remote_Hours 1 241 339 417 2 179 336 595 3 278 360 653 4 216 378 632 5 195 337 522 6 133 282 404 7 193 332 390 8 113 294 394 9 118 326 347 10 150 311 338 11 158 307 360 12 149 315 282 13 114 287 386 14 167 300 408 15 278 325 157 16 243 340 220 17 209 352 271 18 186 340 438 19 232 330 474 20 179 328 346
Background image of page 1

Top Answer

a) 1,2,3 - see the attached Excel file 4)  B. There is no particular pattern in the... View the full answer

MultipleRegression.xlsx

Sign up to view the full answer

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

-

Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question
Ask a homework question - tutors are online