"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.
Public Economic Need To Do It In Excel 1 For Each Year From 1990 To 2019 Find The Sum Of The Amounts Of Government 1 (90.66 KiB) Viewed 62 times
StatisticalTable ItemNames1 Unit Conversion 1990 1991 1992 1993 1994 1995 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2.1.2.2.3. Expenditures on GDP (not seasonally adjusted, current prices, quarterly & annual) Government Gross fixed capital formation (government) Expenditure on GDP Bil. Won Bil. Won Bil. Won Original Data Original Data Original Data 22008.2 10552 200556.2 26073.5 14490.3 242481.1 30697.6 16892.5 277540.8 33878.7 18497.2 315181.3 38275.5 21078.5 372493.4 43870.9 24173.8 436988.8 50998.6 27166.2 490850.9 55339.9 31001.7 542001.8 61258.7 31159.5 537215.3 65511.9 31081.8 591453 71028.2 34627.4 651634.4 83110.7 38198.3 707021.3 92141.5 39697.5 784741.3 101757 47054.7 837365 112531.3 50763.2 908439.2 123149.4 50928.2 957447.8 134455.4 50978.7 1005601.5 146481.6 54092.6 1089660.2 162150.9 60736.1 1154216.5 176711.6 78056.5 1205347.7 187874.7 69267.7 1322611.2 199627.2 69212.7 1388937.2 211492.8 68956.3 1440111.4 224770.8 71677.4 1500819.1 237959.4 67739.4 1562928.9 250088 71848.8 1658020.4 265295.2 77121.5 1740779.6 283045.8 81235.8 1835698.2 304692.7 85494.6 1898192.6 328663.2 97972 1924498.1
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!