Weekly sales of a company’s product (y) and those of its main competitor (x) were recorded for one year. Use ?=0.10. a) Conduct a regression analysis of these data. b) Plot the residuals versus the time periods. Does there appear to be autocorrelation? c) Perform the Durbin-Watson test. Is there evidence of autocorrelation? Use ?=0.10
Weekly sales of a company’s product (y) and those of its main competitor (x) were recorded for one year. Use ?=0.10.
a) Conduct a
b) Plot the residuals versus the time periods. Does there appear to be autocorrelation?
c) Perform the Durbin-Watson test. Is there evidence of autocorrelation? Use ?=0.10
d) If autocorrelation was detected in Part c, propose an alternative regression model to remedy the problem. Use the computer to generate the statistics associated with this model.
e) Redo Parts b and c. Compare the two models.
PLEASE ONLY USE EXCEL AND SHOW ALL EXCEL COMMANDS!
| Company | Competitor |
| 1383 | 1153 |
| 2022 | 1067 |
| 2429 | 1296 |
| 901 | 1406 |
| 2219 | 1254 |
| 1896 | 1335 |
| 1910 | 1204 |
| 1539 | 1076 |
| 2048 | 1246 |
| 2881 | 1098 |
| 2395 | 1258 |
| 1349 | 955 |
| 2052 | 954 |
| 2675 | 1363 |
| 1588 | 1022 |
| 2704 | 1155 |
| 3148 | 1807 |
| 2822 | 1295 |
| 2217 | 1116 |
| 2260 | 1323 |
| 3040 | 1326 |
| 3137 | 1107 |
| 2977 | 1163 |
| 2599 | 1254 |
| 2412 | 1017 |
| 3187 | 938 |
| 2598 | 1270 |
| 2995 | 1042 |
| 3046 | 1318 |
| 3858 | 1497 |
| 2438 | 750 |
| 3243 | 1380 |
| 2764 | 1053 |
| 2944 | 932 |
| 3324 | 1097 |
| 2797 | 1193 |
| 3914 | 1271 |
| 2766 | 843 |
| 2273 | 780 |
| 3052 | 1095 |
| 3202 | 1290 |
| 3672 | 937 |
| 3957 | 1390 |
| 3274 | 1056 |
| 3788 | 1235 |
| 3502 | 1235 |
| 2942 | 999 |
| 3078 | 1066 |
| 3196 | 641 |
| 3141 | 1322 |
| 3579 | 1289 |
| 3895 | 1060 |
Trending now
This is a popular solution!
Step by step
Solved in 4 steps with 4 images
I get difference coefficient intercepts compared to yours, is it possible that i have some wrong setting enabled in excel?
by Bartleby Expert