Recall the Production function in the Solow Growth model with ex Y = AK [(1 + YA) N₁ The following questions require you to download the excel spreads called Growth Accounting.xlsx. The spreadsheet contains data fom from 1960-2007: Real GDP, Capital Stock, total work hours, and Capital Stock, and total hours are in Billions. Working age populat use Working Age population in the first question below.) 1960 1961 1962 1963 1964 1965 1966 1967 1968 1969 1970 1970 1971 1972 1972 1973 1974 1975 1976 1977 1978 1070 1979 1000 1960 1901 1961 1982 1962 1992 1963 1964 1984 1965 1906 1506 1967 1968 1909 1990 1991 1992 1993 1994 1995 1996 1997 1000 1996 1000 1999 mmm 2000 m 2001 vm 2002 2003 2004 2005 2006 2007 1. 2. Plot the natural logarithm of GDP per working age Use the data on GDP, work hours, and capital to c Plot the natural logarithm of TFP from 1960-2007 to be A(1+YA)(1-0).) 3. 4. Assume a geometric growth rate for all variables.. for GDP, work hours, capital and Solow residuals Find the value of YA that is implied from your calc 1960-2007. Repeat this but for the 1960-1973, the subperiods. GDP (billions) 2501,8 2560,0 2715,2 2834,0 2998,6 3191,1 1500 3399,1 2494 6 3484,6 3652,7 3765,4 3771,9 3898,6 4105,0 4341,5 4319,6 4311,2 45409 4540,9 TERE 4750,5 EMER 5015,0 5173,4 5161,7 5291,7 5189,3 5423,8 5813,6 6053,7 6263,6 6475,1 6742,7 6961,4 7112,5 7100,5 7336,6 7532,7 7835,5 8031,7 man 8328,9 m 8703,5 DOCED 9066,9 9470,3 00170 9617,0 0000 9890,7 K (Billions) 1048 10048,8 10301,0 10675,8 10969,5 11294,8 115239 5896,0 6131,3 6360,3 6625,4 6900,2 7195,4 TEALE 7541,6 2017 2 7927,3 8274,5 8629,1 8989,5 9281,5 9608,7 9988,9 10436,7 10829,2 11094,8 we 11467,8 110366 11935,0 12502,7 13091,7 125527 13552,2 14067,6 14413,8 14793,8 15395,5 15959,6 16504,4 17057,2 17591,2 18134,3 13606,3 18948,4 19322,0 19745,4 20283,1 20829,7 21438,5 ET 22157,3 MA 22957,9 33030.0 23839,0 247646 24764,6 254999 25499,9 26156,9 26832,7 27644,3 285-49,6 29483,8 Hours (Billions) 128,5 128,7 132,6 135,0 138,7 142,7 145,9 146,6 148,8 151,9 151,4 151.4 151,9 157,6 163,2 164,3 160,7 166,6 171,8 170 178,8 1920 182,9 1010 181,8 102 0 183,8 179,6 179 6 183,0 191,7 194,5 197,8 202,9 206,9 210,5 211,9 208,7 210,7 214,5 zaujo 220,8 222,8 MA 226,0 ma 232,4 WA 235,8 30 238,1 343 244,2 mi 242,1 240,6 241,4 244,0 249,1 254,6 256,7 population 16-64 (thou 105160 106314 10740 10949 11130 113000 113090 1100 114896 116835 116825 11880 118808 12078 12296 12526 127572 12995 12995 13231 13464 137040 139408 139488 141035 141920 www 144308 14673 148705 148709 1503 88 15187 153314 15475 15627 15779 1591 10 160180 16139 16312 16484 166715 1686 38 170652 www 172945 www 175445 *** 178018 10. 180608 10300 18298 10547 185472 107016 1879 18 1901 48 1923 29 1945 28 196872 19900
Recall the Production function in the Solow Growth model with ex Y = AK [(1 + YA) N₁ The following questions require you to download the excel spreads called Growth Accounting.xlsx. The spreadsheet contains data fom from 1960-2007: Real GDP, Capital Stock, total work hours, and Capital Stock, and total hours are in Billions. Working age populat use Working Age population in the first question below.) 1960 1961 1962 1963 1964 1965 1966 1967 1968 1969 1970 1970 1971 1972 1972 1973 1974 1975 1976 1977 1978 1070 1979 1000 1960 1901 1961 1982 1962 1992 1963 1964 1984 1965 1906 1506 1967 1968 1909 1990 1991 1992 1993 1994 1995 1996 1997 1000 1996 1000 1999 mmm 2000 m 2001 vm 2002 2003 2004 2005 2006 2007 1. 2. Plot the natural logarithm of GDP per working age Use the data on GDP, work hours, and capital to c Plot the natural logarithm of TFP from 1960-2007 to be A(1+YA)(1-0).) 3. 4. Assume a geometric growth rate for all variables.. for GDP, work hours, capital and Solow residuals Find the value of YA that is implied from your calc 1960-2007. Repeat this but for the 1960-1973, the subperiods. GDP (billions) 2501,8 2560,0 2715,2 2834,0 2998,6 3191,1 1500 3399,1 2494 6 3484,6 3652,7 3765,4 3771,9 3898,6 4105,0 4341,5 4319,6 4311,2 45409 4540,9 TERE 4750,5 EMER 5015,0 5173,4 5161,7 5291,7 5189,3 5423,8 5813,6 6053,7 6263,6 6475,1 6742,7 6961,4 7112,5 7100,5 7336,6 7532,7 7835,5 8031,7 man 8328,9 m 8703,5 DOCED 9066,9 9470,3 00170 9617,0 0000 9890,7 K (Billions) 1048 10048,8 10301,0 10675,8 10969,5 11294,8 115239 5896,0 6131,3 6360,3 6625,4 6900,2 7195,4 TEALE 7541,6 2017 2 7927,3 8274,5 8629,1 8989,5 9281,5 9608,7 9988,9 10436,7 10829,2 11094,8 we 11467,8 110366 11935,0 12502,7 13091,7 125527 13552,2 14067,6 14413,8 14793,8 15395,5 15959,6 16504,4 17057,2 17591,2 18134,3 13606,3 18948,4 19322,0 19745,4 20283,1 20829,7 21438,5 ET 22157,3 MA 22957,9 33030.0 23839,0 247646 24764,6 254999 25499,9 26156,9 26832,7 27644,3 285-49,6 29483,8 Hours (Billions) 128,5 128,7 132,6 135,0 138,7 142,7 145,9 146,6 148,8 151,9 151,4 151.4 151,9 157,6 163,2 164,3 160,7 166,6 171,8 170 178,8 1920 182,9 1010 181,8 102 0 183,8 179,6 179 6 183,0 191,7 194,5 197,8 202,9 206,9 210,5 211,9 208,7 210,7 214,5 zaujo 220,8 222,8 MA 226,0 ma 232,4 WA 235,8 30 238,1 343 244,2 mi 242,1 240,6 241,4 244,0 249,1 254,6 256,7 population 16-64 (thou 105160 106314 10740 10949 11130 113000 113090 1100 114896 116835 116825 11880 118808 12078 12296 12526 127572 12995 12995 13231 13464 137040 139408 139488 141035 141920 www 144308 14673 148705 148709 1503 88 15187 153314 15475 15627 15779 1591 10 160180 16139 16312 16484 166715 1686 38 170652 www 172945 www 175445 *** 178018 10. 180608 10300 18298 10547 185472 107016 1879 18 1901 48 1923 29 1945 28 196872 19900
Chapter1: Making Economics Decisions
Section: Chapter Questions
Problem 1QTC
Related questions
Question
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 3 steps
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, economics and related others by exploring similar questions and additional content below.Recommended textbooks for you
Principles of Economics (12th Edition)
Economics
ISBN:
9780134078779
Author:
Karl E. Case, Ray C. Fair, Sharon E. Oster
Publisher:
PEARSON
Engineering Economy (17th Edition)
Economics
ISBN:
9780134870069
Author:
William G. Sullivan, Elin M. Wicks, C. Patrick Koelling
Publisher:
PEARSON
Principles of Economics (12th Edition)
Economics
ISBN:
9780134078779
Author:
Karl E. Case, Ray C. Fair, Sharon E. Oster
Publisher:
PEARSON
Engineering Economy (17th Edition)
Economics
ISBN:
9780134870069
Author:
William G. Sullivan, Elin M. Wicks, C. Patrick Koelling
Publisher:
PEARSON
Principles of Economics (MindTap Course List)
Economics
ISBN:
9781305585126
Author:
N. Gregory Mankiw
Publisher:
Cengage Learning
Managerial Economics: A Problem Solving Approach
Economics
ISBN:
9781337106665
Author:
Luke M. Froeb, Brian T. McCann, Michael R. Ward, Mike Shor
Publisher:
Cengage Learning
Managerial Economics & Business Strategy (Mcgraw-…
Economics
ISBN:
9781259290619
Author:
Michael Baye, Jeff Prince
Publisher:
McGraw-Hill Education