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

(a) Develop a linear regression model to predict Wal-Mart revenue, using CPI as the only independent variable. (b) Develop a linear regression model to predict Wal-Mart revenue, using Personal Consumption as the only independent variable. (c) Develop a linear regression model to predict Wal-Mart revenue, using Retail Sales Index as the only independent variable. (d) 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. (e) Develop a linear regression model to predict Wal-Mart revenue, using CPI as the only independent variable. (f) Develop a linear regression model to predict Wal-Mart revenue, using Personal Consumption as the only independent variable. (g) Develop a linear regression model to predict Wal-Mart revenue, using Retail Sales Index as the only independent variable. (h) Which of these three models is the best? Use R-square values and Significance F values to explain your answer. (i) 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 and show how each step is done.
( a ) Develop a linear regression model to

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!