LUSmac adata Compatibility Mode] - Faca Tell me what you want to do File Home nsert Page Layout Formulas Data Review View EmmLSmarmdsts Compsthiey Mnde w Tell me what you want to du. 8 Share Irsat Page Layou Fomuls Dala Bevis Vicw Emma Ti lay File Ha5marredata (Compatibility Mede)- Fere BWhap Ted Merge & Certer N 39 dMage & Cente 8 D El DG CH D D DN C DO DR D5 DT CU DV DW EA E EC EC EE Tw.n 1ga 4 04 20 1 2012 34 setu N 010 3.000 s547200 4& U18 El FF EG EH EI EJ Fie EL EM EN FC EP EC EP ES ET EV EVe E: EY EZ FA F FC Er 2t03 2204 01 2034 25 2037 25 2008 2t03 C2 2 - FK FL ER 2003 Q ES E EL EV 2007 C1 EW E EY FA FE FO FE FF FG FH F FJ FM FN FO FP - Ad 2008 C2 2008 03 2008 04 2007 C2 2The file USmacrodata.xlsx contains U.S. quarterly GNP, Inflation rates, and Unemployment rates. Use this file to perform the following exercises:" 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. 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. 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.