The file USmacrodata. xlsx ( above) contains U. S. quarterly GNP, Inflation rates, and Unemployment rates. Use this file to perform the following exercises: (a) Develop a regression to predict quarterly GNP growth from the last four quarters of growth. Check for non-normality of residuals, heteroscedasticity, autocorrelation, and multicollinearity.
(b) Develop a regression to predict quarterly inflation rate from the last four quarters of inflation. Check for non-normality of residuals, heteroscedasticity, autocorrelation, and multicollinearity.
(c) Develop a regression to predict quarterly unemployment rate from the unemployment rates of the last four quarters. Check for non-normality of residuals, heteroscedasticity, autocorrelation, and multicollinearity."
Scale 2011 Q2 2011 Q3 2011 Q4 2012 Q1
GNP Billions 15012.788 15176.068 15319.400 15461.800
Unempoyment Rate 8.900 9.067 8.333 8.733
Inflation 3.430 3.756 3.294 2.815