Question
Public Economic need to do it in Excel. 1. For each year from 1990 to 2019, find the sum of the amounts of government consumption
"Public Economic" need to do it in Excel.
1. For each year from 1990 to 2019, find the sum of the amounts of government consumption (1) and government investment (2). (Unit: KRW billion) 2. For each year from 1990 to 2019, what is the proportion of government consumption and government investment combined in GDP? (unit: %) 3. Using the total general government expenditure in [Problem 1] and the GDP of [Problem 2], find the 'Ratio of General Government Total Expenditure to GDP' for each year from 1990 to 2019 (Unit: %) Briefly write the reason for the difference between the answers in 2) and 3) in a blank cell.
StatisticalTable | 2.1.2.2.3. Expenditures on GDP (not seasonally adjusted, current prices, quarterly & annual) | ||
ItemNames1 | Government | Gross fixed capital formation (government) | Expenditure on GDP |
Unit | Bil.Won | Bil.Won | Bil.Won |
Conversion | Original Data | Original Data | Original Data |
1990 | 22008,2 | 10552 | 200556,2 |
1991 | 26073,5 | 14490,3 | 242481,1 |
1992 | 30697,6 | 16892,5 | 277540,8 |
1993 | 33878,7 | 18497,2 | 315181,3 |
1994 | 38275,5 | 21078,5 | 372493,4 |
1995 | 43870,9 | 24173,8 | 436988,8 |
1996 | 50998,6 | 27166,2 | 490850,9 |
1997 | 55339,9 | 31001,7 | 542001,8 |
1998 | 61258,7 | 31159,5 | 537215,3 |
1999 | 65511,9 | 31081,8 | 591453 |
2000 | 71028,2 | 34627,4 | 651634,4 |
2001 | 83110,7 | 38198,3 | 707021,3 |
2002 | 92141,5 | 39697,5 | 784741,3 |
2003 | 101757 | 47054,7 | 837365 |
2004 | 112531,3 | 50763,2 | 908439,2 |
2005 | 123149,4 | 50928,2 | 957447,8 |
2006 | 134455,4 | 50978,7 | 1005601,5 |
2007 | 146481,6 | 54092,6 | 1089660,2 |
2008 | 162150,9 | 60736,1 | 1154216,5 |
2009 | 176711,6 | 78056,5 | 1205347,7 |
2010 | 187874,7 | 69267,7 | 1322611,2 |
2011 | 199627,2 | 69212,7 | 1388937,2 |
2012 | 211492,8 | 68956,3 | 1440111,4 |
2013 | 224770,8 | 71677,4 | 1500819,1 |
2014 | 237959,4 | 67739,4 | 1562928,9 |
2015 | 250088 | 71848,8 | 1658020,4 |
2016 | 265295,2 | 77121,5 | 1740779,6 |
2017 | 283045,8 | 81235,8 | 1835698,2 |
2018 | 304692,7 | 85494,6 | 1898192,6 |
2019 | 328663,2 | 97972 | 1924498,1 |
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