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

Glencoe Algebra 1, Student Edition, 9780079039897, 0079039898, 2018
18th Edition
ISBN:9780079039897
Author:Carter
Publisher:Carter
Chapter4: Equations Of Linear Functions
Section4.6: Regression And Median-fit Lines
Problem 22PFA
icon
Related questions
Question

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 

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
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps with 4 images

Blurred answer
Follow-up Questions
Read through expert solutions to related follow-up questions below.
Follow-up Question

I get difference coefficient intercepts compared to yours, is it possible that i have some wrong setting enabled in excel? 

Solution
Bartleby Expert
SEE SOLUTION
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Glencoe Algebra 1, Student Edition, 9780079039897…
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
College Algebra
College Algebra
Algebra
ISBN:
9781938168383
Author:
Jay Abramson
Publisher:
OpenStax
College Algebra
College Algebra
Algebra
ISBN:
9781305115545
Author:
James Stewart, Lothar Redlin, Saleem Watson
Publisher:
Cengage Learning
Functions and Change: A Modeling Approach to Coll…
Functions and Change: A Modeling Approach to Coll…
Algebra
ISBN:
9781337111348
Author:
Bruce Crauder, Benny Evans, Alan Noell
Publisher:
Cengage Learning
Big Ideas Math A Bridge To Success Algebra 1: Stu…
Big Ideas Math A Bridge To Success Algebra 1: Stu…
Algebra
ISBN:
9781680331141
Author:
HOUGHTON MIFFLIN HARCOURT
Publisher:
Houghton Mifflin Harcourt
Algebra & Trigonometry with Analytic Geometry
Algebra & Trigonometry with Analytic Geometry
Algebra
ISBN:
9781133382119
Author:
Swokowski
Publisher:
Cengage