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 WalMart revenue, using CPI as the only independent variable. b Develop a linear regression model to predict WalMart revenue, using Personal Consumption as the only independent variable. c Develop a linear regression model to predict WalMart revenue, using Retail Sales Index as the only independent variable. d Which of these three models is the best? Use Rsquare 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 WalMart revenue, using CPI as the only independent variable. f Develop a linear regression model to predict WalMart revenue, using Personal Consumption as the only independent variable. g Develop a linear regression model to predict WalMart revenue, using Retail Sales Index as the only independent variable. h Which of these three models is the best? Use Rsquare 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 Rsquare values, Significance F values and other appropriate criteria to explain your answer. Please use one Excel and show how each step is done.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
