Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Accounting

Authors: C Thomas,

12th Edition

007760086X, 9780077600860

More Books

Students also viewed these Economics questions

Question

Why should goals be specific and measurable?

Answered: 1 week ago

Question

Make eye contact when talking and listening

Answered: 1 week ago

Question

Do not go, wait until I come

Answered: 1 week ago

Question

Pay him, do not wait until I sign

Answered: 1 week ago