Using Statistics Canada's data sets: The data I want you to use in this assignment can be downloaded from https://www150.statcan.gc.ca/n1/en/type/data.

1 Use "ADD/REMOVE reference period" tab to specify what timeperiod you want to consider. The time period is specified in the assignment.2 Use "Add/Remove data" tab and then "Estimates" tab to select variables you want to be included in a download.3 Use "Add/Remove data" tab and then "Customize Layout" tab to specify how you want rows and columns to be organized. I recommend displaying Reference period as row, and all other options as columns.4 Once you selected the required options please click on "Apply."5 Use "Download options" tab and select 'CSV, download as displayed: which can be latter open in Excel.6 Once ".CSV" file is open in Excel you can change the format to .xlsx and work with it as you would usually work with an Excel file.7 From here you can manipulate data, make graphs, do calculations, etc.8 Once done, copy back into Word and format your table somemore. A nice table or graph is a thing of beauty.

This assignment looks at Canadian national income and our current accounts, as well as how they have changed over the past two decades. The intent is to build familiarity with national statistics so at least you are not speaking from ignorance about Canada.

Go to Statistics Canada's main socioeconomic database at https://www150.statcan.gc.ca/n1/en/type/data Use data from2001 to 2021. GDP: Find table Table 36-10-0369-01 Gross domestic product, expenditure-based, at 2012 constant prices, annual (x 1,000,000).

a) Create a table of C, I, G, (X -M) and Y. Create a graph of C, I, G, and (X-M).b) Express each component as a share of total GDP. Create a graph showing the evolution of shares over time.c) Discuss the pattern in shares as well as values that emergesacross the categories and over time. In particular, what happened during the 2008 financial crisis? Any noticeable changes to the pattern in 2020?d) What happened to investment around 2015? Discuss.e) Create a table of S and I. Express each component as a share of total GDP. Create a graph showing the evolution of S/Y and I/Y over time. Discuss the pattern.f) Separate net exports of goods and services into "net exports of goods" and "net exports of services." Discuss the balances of trade in goods and services for Canada. What happened after the 2008 financial crisis?

Some comments and hints:

"expenditure-based" means that we look at how our GDP is spent. Alternatively, we could look at the "income-based" measure which show how income is paid for factors of production (labour, capital, etc). "at 2012 constant prices" means that our GDP measure is real rather than nominal. If you would like to review the difference between real and nominal variables, please review it in Econ 114 text. usually we work with GDP data measured in "chained dollars." However, chained dollars measures are not additive. For the purpose of this assignment, I select "constant dollars" which means that our GDP is measured using 2012 prices. What is C? In the table this is "Household final consumption expenditure" plus "Non-profit institutions serving households' final consumption expenditure" What is I? In the table this is "Business gross fixed capital formation" plus "Non-profit institutions serving households' gross fixed capital formation" plus "Investment in inventories." What is G? This is "General government final consumption expenditure" plus "General government gross fixed capital formation." 2 (10 points)

Current Account: Find table Table 36-10-0014-01 Balance of international payments, current account and capital account, annual (x 1,000,000)

a) Create a table of the current account. b) What is the value for 2017? Interpret it (Eg What does a deficit or a surplus mean?)c) What are the major components in the Current Account? Which components are in deficit? Surplus? Discuss.d) Discuss the pattern of changes in the CA over time. In particular, what happened during the 2008 financial crisisand Comments and hints:

Use "Add/Remove data" tab and then "Receipts, payments, and balances." Select "Balances." Use "Add/Remove data" tab and then "Countries or regions" select "all countries" When considering the components of the current account, consider "Goods and Services," "Primary Income," and "Secondary income." Unlike Question 1, the data in question 2 is nominal, i.e. in current prices. That is why you may find that behavior of "goods and services" in the current account may differ from the behavior of net exports in the GDP table.

2