1 Growth accounting exercise (20 points total) Imagine that your top manager is about to give an important presentation to a group of OECD executives about the growth experience of two countries, Australia and Canada. Your manager is always busy and relies on you, one of his best researchers, to do the analysis. He asks you to research this topic and write a nice and clear 3-4 page report summarizing your analysis and main Öndings. Your manager is a really nice person, so you donÃt want to let him down. You decided to do the growth accounting exercise using PWT 10.0 data for the years 1959, 1969, 1979, 1989, 1999, 2009, 2019. For both Australia and Canada you need to do the following tasks: 1.1 Download Excel data Öle from PWT 10.0 database.1 Focus on real GDP, 1Available at www.rug.nl/ggdc/productivity/pwt/ 1 real capital stock, employment and labour share data for both Australia and Canada. SpeciÖcally, use the following series: Real GDP at constant 2017 national prices (in mil. 2017US$), rgdpna Capital stock at constant 2017 national prices (in mil. 2017US$), rnna Number of persons engaged (in millions), emp Share of labour compensation in GDP at current national prices, labsh In your Önal report to the manager you will need to have a nice, properly labeled table similar to Table 7.2 in Chapter 7 of your textbook, which reports the compiled data and the sources of data. Typically this kind of background information goes into an Appendix of your report. 1.2 For each country, calculate TFP using a Cobb-Douglas production function with the labour exponent set equal to the average labour share of this country, with the average taken over the selected years (1959, 1969, 1979, 1989, 1999, 2009, XXXXXXXXXXPlot calculated TFP levels for both countries on the same graph, while making sure that they both start from 100 in 1959. You will need to re-scale the entire TFP series for both countries in order to achieve that. 1.4 Calculate the average annual growth rates of output, capital, employment and TFP for each decade, and report them in a nice table just like Table 7.3 in chapter 7 of your textbook. 1.5 For each decade and for each country calculate the share of output growth that can be attributed to growth in capital, employment and TFP. 1.6 Write a brief but informative summary of main insights that your manager should learn from your research in preparation for his important presentation. This report with all the tables and charts (needed to support your conclusions) will be the Örst part of your homework. It will be graded on the basis of how good my TA feels about your report. It is certainly a subjective metric, but this is what you should expect from your future manager anyway. 2 2 Analyzing Income and Substitution e§ects (20 points) In a one period model of Chapter 4, suppose the real wage has decreased, but the non-wage income increases at the same time so that to exactly o§set the income e§ect of the real wage fall. Use carefully labeled charts to show the impact of these changes on the representative consumerÃs optimal choices. Use letters and intervals to clearly label various points and distances in your charts. Your charts must clearly show the following details: a) The income and substitution e§ects of the real wage change alone. b) The magnitude of the change in the representative householdÃs nonwage income which eliminates the income e§ect of the real wage change. c) The e§ect of both income changes combined on consumption. d) The e§ect of both income changes combined on leisure. e) The e§ect of both income changes combined on labour supply. 3 Plotting a chart with a trend curve (20 points) Figure 1.3 in your textbook shows log of real per capita income in Canada and an HP Öltered trend curve Öt to this series. You will need to plot a similar chart, but for natural logarithm of Canadian Real GDP (not per capita) PLUS a linear trend Öt to this series. In order to do that you need to Önd Real GDP data for Canada. This series should be quarterly frequency, seasonally adjusted at annual rates, and cover the period from the Örst quarter of 1961 to the third quarter of 2020. You can Önd these data on Statistics Canada website. This exercise is easiest to do in Excel, but if you want to do it in other software packages, I am Öne with that. Label and format the chart to make it look as professional as possible. My TA will be comparing your charts with my and giving you grades based on how close they are in terms of quality.