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

above is the excel data. please solve the excel part with formulas and explanation, only solve part (d) and (e), thanks

Weekly sales of a company's product (y) and those of its main competitor (x) were recorded for one year. Use a = 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 a = 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