Answered step by step
Verified Expert Solution
Question
1 Approved Answer
4. (20 points) For this question you can choose between using Excel or R. Using data from the Penn World Tables (Link: https://www.rug.nl/ggdc/productivity/pwt/), please complete
4. (20 points) For this question you can choose between using Excel or R. Using data from the Penn World Tables (Link: https://www.rug.nl/ggdc/productivity/pwt/), please complete the following: (a) Replicate Table (2.1) of the textbook, adding an extra column for the period 2010-2018. Comment on your findings. (b) Replicate Table (2.1) of the textbook, but for Canada instead of USA. Comment on your findings. Provide your Excel file or R script. Please see the footnote for hintsTABLE 2.1 GROWTH ACCOUNTING FOR THE UNITED STATES 1948- 1948- 1973- 1995- 2000- 2010 73 95 2000 2010 I Output per hour 2.6 3.3 1.5 2.9 2.7 Contributions from: Capital per hour worked 1.0 1.0 0.7 1.2 1.2 Information technology 0.2 0.1 0.4 0.9 0.5 Other capital services 0.8 0.9 0.3 0.3 0.7 Labor composition 0.2 0.2 0.2 0.2 0.3 Multifactor productivity 1.4 2.1 0.6 1.5 1.3 SOURCE: Bureau of Labor Statistics (2010). Note: The table reports average annual growth rates for the private business sector. "Information technology" refers to information processing equipment and software
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started