Please use SPSS

1. Shown below are the percentage changes in consumer price indexes (CPI) over a period of 20 years for all commodities, as well as for food, shelter, apparel, and fuel oil. Use these data to develop a multiple regression model to predict CPI change for all commodities by CPI changes of the four commodities. Use a=.05 in all analyses below. A. Write down the estimated regression equation. Interpret the coefficients of the model. B. What percent of the total variation in the dependent variable (CPI change for all commodities) is explained by the regression model? C. Use the F-test to test the overall significance of the regression model. State the hypotheses, find the p-value, and state the conclusion and explain. D. If necessary, use t tests to test whether each individual coefficient is significantly different from zero. State the hypotheses, find the p-values, state the conclusions and explain. E. Make a residual plot, comment on the pattern of the residuals and possible violation of the model assumptions