Linear regression model to predict revenue

Wal-Mart is the second largest retailer in the world.The data file (WalMart_revenue.xlsx) is included in the Excel data zip file in week one, and it holds monthly data on Wal-Mart’s revenue, along with several possibly related economic variables.

Save your time - order a paper!

Get your paper written from scratch within the tight deadline. Our service is a reliable solution to all your troubles. Place an order on any task and we will take care of it. You won’t have to worry about the quality and deadlines

Order Paper Now

1)Develop a linear regression model to predict Wal-Mart revenue, using CPI as the only independent variable.

2)Develop a linear regression model to predict Wal-Mart revenue, using Personal Consumption as the only independent variable.

3)Develop a linear regression model to predict Wal-Mart revenue, using Retail Sales Index as the only independent variable.

4)Which of these three models is the best?Use R-square value, Significance F values and other appropriate criteria to explain your answer.

Identify and remove the four cases corresponding to December revenue.

5)Develop a linear regression model to predict Wal-Mart revenue, using CPI as the only independent variable.

6)Develop a linear regression model to predict Wal-Mart revenue, using Personal Consumption as the only independent variable.

7)Develop a linear regression model to predict Wal-Mart revenue, using Retail Sales Index as the only independent variable.

8)Which of these three models is the best?Use R-square values and Significance F values to explain your answer.

9)Comparing the results of parts (d) and (h), which of these two models is better?Use R-square values, Significance F values and other appropriate criteria to explain your answer.

Please use one Excel file to complete this problem, and use one sheet for one sub-problem.Use a Microsoft Word document to answer questions.Finally, upload the files to the submission link for grading.