Please help with help with all steps in excel! Thank you! Identify and remove th
ID: 3242154 • Letter: P
Question
Please help with help with all steps in excel! Thank you!
Identify and remove the four cases corresponding to December revenue:
(d) Develop a multiple linear regression model to predict Company revenue, using CPI, Personal Consumption, and Retail Sales Index as the independent variables.
(e) Plot the residuals against the predicted values and comment on what you see.
(f) Does it seem that Company revenue is closely related to the general state of the economy?
(g) Comparing the results of parts (a) and (d), which of these two models is better? Use R-square values, adjusted R-square values, Significance F values, p-values and other appropriate criteria to explain your answer.
Date Revenue CPI Personal Consumption Retail Sales Index December 11/28/2004 14.764 552.7 7868495 301337 0 12/30/2004 23.106 552.1 7885264 357704 1 1/30/2005 12.131 554.9 7977730 281463 0 2/27/2005 13.628 557.9 8005878 282445 0 3/31/2005 16.722 561.5 8070480 319107 0 4/29/2005 13.98 563.2 8086579 315278 0 5/28/2005 14.388 566.4 8196516 328499 0 6/30/2005 18.111 568.2 8161271 321151 0 7/27/2005 13.764 567.5 8235349 328025 0 8/27/2005 14.296 567.6 8246121 326280 0 9/30/2005 17.169 568.7 8313670 313444 0 10/29/2005 13.915 571.9 8371605 319639 0 11/29/2005 15.739 572.2 8410820 324067 0 12/31/2005 26.177 570.1 8462026 386918 1 1/21/2006 13.17 571.2 8469443 293027 0 2/24/2006 15.139 574.5 8520687 294892 0 3/30/2006 18.683 579 8568959 338969 0 4/29/2006 14.829 582.9 8654352 335626 0 5/25/2006 15.697 582.4 8644646 345400 0 6/28/2006 20.23 582.6 8724753 351068 0 7/28/2006 15.26 585.2 8833907 351887 0 8/26/2006 15.709 588.2 8825450 355897 0 9/30/2006 18.618 595.4 8882536 333652 0 10/31/2006 15.397 596.7 8911627 336662 0 11/28/2006 17.384 592 8916377 344441 0 12/30/2006 27.92 589.4 8955472 406510 1 1/27/2007 14.555 593.9 9034368 322222 0 2/23/2007 18.684 595.2 9079246 318184 0 3/31/2007 16.639 598.6 9123848 366989 0 4/28/2007 20.17 603.5 9175181 357334 0 5/25/2007 16.901 606.5 9238576 380085 0 6/30/2007 21.47 607.8 9270505 373279 0 7/28/2007 16.542 609.6 9338876 368611 0 8/29/2007 16.98 610.9 9352650 382600 0 9/28/2007 20.091 607.9 9348494 352686 0 10/20/2007 16.583 604.6 9376027 354740 0 11/24/2007 18.761 603.6 9410758 363468 0 12/29/2007 28.795 604.5 9478531 424946 1 1/26/2008 20.473 606.348 9540335 332797 0Explanation / Answer
Go to Data option in excel and select data analysis
then click on regression and click ok one window is open with following content
Input Y range and Input X range
Select Revenue in Y Range (Variable name also)
Select Other variables CPI, Personal Consumption, Retail Sales index ion X Range (Variable name also)
Tick in Residuals , Residual plot what required to answer the question tick on that option.
If you want output in same worksheet then tick in output range option select the appropriate cell where you want output.
otherewise it will generate in new worksheet