"Public Economic" need to do it in Excel
1) For each year from 1990 to 2019, calculate the share of
expenditures for each of the 10 purposes (from ‘general public
administration’ to ‘social protection’) in total expenditure
(‘total’). (unit: %)
* The result is a 30x10 matrix. (30 years, 10 expenditures by
purpose)
* For students who have not used Excel much: It is easy to use
copy-and-paste.
2) In the three years 1990, 2010, and 2017, indicate which
expenditure sector accounted for the largest share.
(It is sufficient to write your answer in a blank cell, or to
highlight the maximum weight value)
Public Economic Need To Do It In Excel 1 For Each Year From 1990 To 2019 Calculate The Share Of Expenditures For Eac 1 (159.88 KiB) Viewed 38 times
Statistical table Amount classification code 2.1.8.2. Total expenditure of general government by sector and function (nominal General Government - Total Expenditure 1992 1993 9881.8 7371 1994 10420.5 1995 12581.1 1996 13236.2 1997 14986.3 13597.9 1998 17759.9 13623 9362.9 10027.3 12184.3 3460.8 3952.4 4461.8 4992.1 5308.6 5719.4 15096 15679.1 21420.3 24281.8 28768 32194.2 2403.7 2648.3 2966.6 3440.1 3853.5 4159 4058.5 4104.9 4594.8 6142.2 7164.4 8274.1 4171.6 4650.5 5831.6 7180.5 8170.3 9312.8 1378.7 1531.7 1820.1 2209.8 2725.6 3077.2 13120.4 15368.6 17490.5 20599 22630.8 22084.9 7812.7 8832.6 10556,2 11368.8 13392.3 19475.2 76551.4 91750.2 105634.9 120597.6 135679.7 68755.3 2008 8796.3 7216.1 3154.6 13248.1 1951.6 3500.2 3684.1 1269.2 11732.8 6813.6 61366.7 2007 47802.9 24211.6 11718 59492.9 10149.9 12905.4 33401.4 8040.4 47015.3 50783.2 305521 57401.3 27715.2 12637.2 64358.5 10202.4 13419.9 37397.3 8594.8 53418.3 58934.9 344079.8 2009 55890.3 30807.4 13596.3 80156 12384.5 18309.8 43583.7 9988.8 59028.5 65341.6 389086.9 2010 60948 30847.1 14016.7 70863 11503.4 15332.3 49733.7 9728.4 58755.4 69761.1 391488.9 2011 64867.3 33872.7 14676.1 78168.8 11900. 15014.7 52327.3 10221.9 62744 78227.2 422020 2012 67757.3 34719.8 16062.6 79338.8 11788.3 14966.4 54517 10885.6 66175 87380 443590.7 1999 19497.6 13663.1 5743.6 31916.8 4483.6 7239.7 10797.8 3559.8 22776.3 25428.3 145106.6 2013 67881.4 36850.7 17063.1 71464.9 12642.5 14698.8 57012.7 11774.5 69704.2 93108.7 452201.4 account item general public administration national defense public order and safety economic affairs environmental protection Housing and community development health Entertainment Culture and Religion education social protection Total 2000 22193.9 14880.1 6472.3 35193.6 5058.6 7424.5 12685 3929 24412.1 21322 153571.1 2014 69935 37900.2 17881.7 71829 13833.1 14524.8 61599.5 11680 73908 102368 475459.3 2001 28239.5 15902.7 7335 39650.2 5188.7 7005.2 17711.8 3985.8 29155 23835.9 178009.7 2015 2002 31093.4 16909.2 7768.4 44535 6111.4 7074.3 18766.5 4648.5 32747.5 25303.4 194957.7 70680.3 39804.3 19268.5 75428.1 14371 16079.8 66328.8 12914 78019.5 111114 504008.4 2016 unit billion won billion won billion won billion won billion won billion won billion won billion won billion won billion won billion won 2003 37405.4 19408.6 8809.5 85977 6809.2 9639.9 20362.3 6420 5 35949.2 29731.2 2605129 71261.5 40680.4 21101.3 77462.4 15143.8 16606 73547.7 14608,4 79727.6 117247.3 527386.2 conversion raw material raw material raw material raw material raw material. raw material raw material raw material raw material raw material raw material 2004 40803.2 19541.5 9248.2 62101.8 7483.2 11803.4 22363.3 6572.9 41480.6 34256.8 255654.9 2017 73252.2 41051 21947.1 82111.8 16330.9 18164.7 79229.4 15827.1 84069.5 123695.5 555679 1990 5523.2 5584,9 1880,8 9123.2 1317 1998,9 2926.4 865.5 7729.1 4089.9 41038.9 2005 40862.9 21362.6 10160.5 63795.1 8249.5 10274.7 25076 7024.8 41127.31 39169,9 267103.3 2018 76580.3 46219.6 22416.7 83174.1 15141.3 18679.1 89016.8 18125.1 90761.4 131120.3 591234.6 1991 7767,6 6516.7 2368.9 11054 1820.8 2802.4 3129.6 997.3 9608,7 5570.6 51636.4 2006 43222.2 22763.9 11057.8 67547.9 9649.8 10993.8 29390 7584.7 41253.7 43649.6 287113.4 80444.1 49218.3 24627.8 94044.7 17123.4 21284.7 99836.6 19844.1 98703.8 146721.9 651849.2 2019
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!