1. (20 pts) For this question, you will need to download the Excel spreadsheet labelled AA1_data.xlsx from D2L. This dataset contains quarterly data on the UK from 1973Q1 to 2006Q1 on a number of different variables. a. (12 pts) Gross Domestic Product Consider that for a variable, x , the growth rate of x is calculated between periods t and t-1 as follows: Click on the worksheet titled "Growth Rate". (2 pts) Calculate Real GDP using the nominal GDP and GDP deflator data in column D. ii. (2 pts) Using the formula above, calculate the Annualized Economic Growth Rate (i.e. the percentage change in real GDP between one quarter and four quarters previously) in column E. [Note: You will not be able to calculate growth rates from 1973Q1 - 1973Q4, since you would need data from 1972Q1-Q4]