Please assist! Also, please give steps on how to model in Excel:
(a) Develop a multiple linear regression model to predict Company revenue, using CPI, Personal Consumption, and Retail Sales Index as the independent variables.
(b) Plot the residuals against the predicted values and comment on what you see.
(c) Does it seem that Company revenue is closely related to the general state of the economy?
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.