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.
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.
Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount!
Use Discount Code "Newclient" for a 15% Discount!
NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.
