1. (20 points) Visit Statistics Canada Table 36-10-0104-01 and download the real (2012 constant values) quarterly data for GDP, consumption, investment, government spending, exports and imports between 1990Q1 and 2020Q2. To construct the "textbook" versions of the components of GDP, use the following equations: C I X Y Household final consumption e:rpenditure Nonprofit inst. serv. hou. final cons. e:rpenditure Business gross fixed capital formation Nonprofit inst. serv. hou. gross fixed capital formation Investment in inventories General governments final consumption e:rpenditure General governments gross fixed capital formation Exports of goods and services Imports of goods and services Gross Domestic Product. Using these variables compute the (exact) annual (Y-o-Y) growth rate for each variable (Y, C, l, G, X, M) using the excel spreadsheet SummaryS- tats.xlsx. Table 1: Correlation Coefficients and Relative Standard Deviations S.D. (rel. to YD Investment Unemployment Rate Wage 0.68 72 0.01 0.74 -0.84 0.10 0.65 -0.81 0.25 491% 618% 94% Notes: quarterly data from 1990ql to 2018q4. All values are seasonally adjusted, in Canadian dol- lars. Source: Statistics Canada. All variables are transformed in year-over-year percent change. Yt is real GDP. (a) (b) (c) (d) Make your own version of Table I but include only the five com- ponents of the national accounts. Do not hand in your excel sheet, but a perfectly correct and well labelled table just like Table I (note change in date range). Which variables are more or less volatile than GDP? Which variables lead, lag, or are coincident with GDP? Which variables are pro- counter- or a-cyclical with GDP?