2.5 Working with macroeconomics data: Canadian GDP data
Gross Domestic Product (GDP) is often used as a benchmark for comparing livelihoods and production across regions and/or time. This lab will familiarize you with Canada’s GDP data and explore these questions:
- How does Canada measure GDP?
- What is captured in these statistics?
- What is not captured?
Learning outcomes
- Be familiar with the Statistics Canada website and Canadian nominal and real GDP data.
- Read and understand a graph.
- Use Excel to work with data and generate meaningful graphs. The Excel skills include using simple formulas, using cell references in formulas, and creating line graphs.
Step 1: Download the data
- Go to StatCan Table 36-10-0104-01.
- Click Add/Remove data and make the following adjustments:
- In the Prices tab, select Chained (2017) dollars and Current prices.
- In the Estimates tab, click Clear all to unselect all levels, then select Gross Domestic Product at market prices. This is the GDP measure.
- In the Reference period tab, select the preferred time period.
- Click Download options, then choose CSV.
Step 2: Identify the variables
- Go to Overview of the National Income and Expenditure Accounts and read the last paragraph on page 1, starting “Real GDP is a measure….”
- Identify the variables:
- Which data series downloaded in Step 1 (Chained [2017] dollars and Current prices) is used as a measure for real GDP?
- Which is used as a measure for nominal GDP?
Note: You are not required to know how exactly the price index is calculated. However, if you’re interested, you can do your own research based on the information in the paragraph.
Step 3: Generate the graph
- Check the general instructions to understand what you should include in your graph. The graph below is an example.
Figure 2.1
Quarterly Canadian Gross Domestic Product (GDP) 2012–2022
Step 4: Calculate the GDP deflator
- Calculate the GDP deflator and its growth rate.
- Looking at your graph, can you infer the change in the price level based on the graph?
Step 5: Calculate the growth rate of the real GDP
- Calculate the growth rate of the real GDP.
- Looking at your graph, can you identify any period in which the Canadian economy was in a recession?
- Identify the period (and the peak and the trough) in your graph.