The excel file has data on the following: UNRATE PCH Unemployment Rate, Percent Change, Quarterly, Seasonally Adjusted 10-Year Treasury Inflation-Indexed Security, Constant Maturity, Percent Change, DFII10_PCH Quarterly, Not Seasonally Adjusted Consumer Price Index for All Urban Consumers: All Items Less Food and Energy in CPILFESL PCH U.S. City Average, Percent Change, Quarterly, Seasonally Adjusted Ratio of Exports to Imports for China, Percent Change, Quarterly, Seasonally XTEITTO1CNM156S_PCH Adjusted Crude Oil Prices: West Texas Intermediate (WTI) - Cushing, Oklahoma, Percent DCOILWTICO_PCH Change, Quarterly, Not Seasonally Adjusted PCOPPUSDM_PCH Global price of Copper, Percent Change, Quarterly, Not Seasonally Adjusted Personal Consumption Expenditures, Percent Change, Quarterly, Seasonally PCE PCH Adjusted Annual Rate Producer Price Index by Commodity: Metals and Metal Products: Iron and Steel, WPU101_PCH Percent Change, Quarterly, Not Seasonally Adjusted Real Gross Private Domestic Investment, Percent Change, Quarterly, Seasonally GPDIC1_PCH Adjusted Annual Rate Rental Vacancy Rate for the United States, Percent Change, Quarterly, Not RRVRUSQ156N_PCH Seasonally Adjusted1) Read the excel file "CAP4830_HW2_Data.xlsx" data into R and store the imported data in a variable named "mode Data". 2) Output the names of the modelData dataframe. Paste your R console output below: 3) Create a variable with name "modell" that stores the estimate of the linear model shown below UNRATE_PCH = b_0 + b_1*DFII10_PCH + b_2 * CPILFESL_PCH +b_3 * XTEITTO1CNM1565_PCH + b_4* DCOILWTICO_PCH + b_5 * PCOPPUSDM_PCH + b_6 *PCE_PCH + b 7 * WPU101_PCH + b_8 * GPDIC1_PCH + b_9 * RRVRUSQ156N_PCH Paste you model's summary below: Hint: use Im and summary 4) List all the estimate parameters from step 3 that are statistically significant for all a $ 0.055) Plot the modell's residual Density Function Paste the plot below: 6) Check the modell's residual normality using the Sharpio test. Paste your results below and explain your finding in one to two sentences. 7) Create model2 which is a refinement of modell by removing all regressors that are statistically insignificant with a p