A1. Using the data on nominal GDP and GDP deflator data in columns D and E, calculate Search documents and file names for text P in column F. I have entered the very first entry into cell F6. Use this to calculate the Annualized Economic Growth rate (based upon the percentage change in real GDP from the previous quarter) in column G. [Hint: Consider that for a variable, x, , the (unadjusted) growth rate of x is calculated between one period and the next is calculated as follows: Growth Rate of x = %Ax = Ax, x100 = 100x X, - X-1 X -1 X -1 Notes: i. You will not be able to calculate growth rates from 1970Q1 - 1970Q2, since you would need data from 196904. Hence the "N/A" in cell G6. ii. Don't forget that you will need to annualize this growth rate since the formula above pertains to the quarter-on-quarter growth rate. iii. Do NOT format the cells in column G to depict them as a percentage format. You will need to leave them as-is (i.e. in a "general" format to be able to compare them to the values in column K later).Units: [Billions of dollars] Seasonally adjusted at annual rates Annualized Economic Growth (USRECOM) Rate (based on NBER Nominal Real quarter on quarter Rule of Thumb 1 Quarter Year Quarter Recession Dates GDP GDP Deflator GDP Growth) Recession Dates Ln (Real GDP) D(LnRGDP) 1970 Q1 1 1051.2 21.294 4936.60 N/A V/A N/A Q2 -1 1067.4 21.591 Q3 -1 1086.1 21.768 Q4 -1 1088.6 22.056 1971 Q1 -1 1135.2 22.391 Q2 -1 1156.3 22.685 Q3 -1 1177.7 22.916 Q4 -1 1190.3 23.107 1972 Q1 -1 1230.6 23.458 02 -1 1266.4 23.604 03 -1 1290.6 23.83 04 1328.9 24.134 1973 -1 1377.5 24.412 Q2 1413.9 24.787 Q3 -1 1433.8 25.27 Q4 1476.3 25.773 1974 Q1 1491.2 26.26 Q2 1530.1 26.88 Q3 1560 27.668 Q4 1599.7 28.482 1975 Q1 1616.1 29.129 02 -1 1651.9 29.562 Q3 1709.8 30.084 04 -1 1761.8 30.587 1976 -1 1820.5 30.911 Q2 -1 1852.3 31.222 Q3 -1 1886.6 31.626 Q4 -1 1934.3 32.192