"Public Economic" need to do it in Excel. 1) For each year from 1990 to 2019, calculate the share of expenditures for ea
Posted: Sun Jun 05, 2022 3:45 pm
"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)
3) What was the share of defense spending in total expenditure in 2019?
Statistical Table Selection of Items Selected Outlays of General Goverment 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 General public services Bil. Won Original Data 5523.2 7767.6 8796.3 9881.8 10420.5 12581.1 13236.2 14986.3 17759.9 19497.6 22193.9 28239.5 31093.4 37405.4 40803.2 40862.9 43222.2 47802.9 57401.3 55890.3 60948 64867.3 67757.3 67881.4 69935 70680.3 71261.5 73252.2 76580.3 80444.1 Defense Bil. Won Original Data 5584.9 6516.7 7216.1 7371 9362.9 10027.3 12184.3 13597.9 13623 13663.1 14880.1 15902.7 16909.2 19408.6 19541.5 21362.6 22763,9 24211.6 27715.2 30807.4 30847.1 33872,7 34719.8 36850,7 37900.2 39804.3 40680.4 41051 46219.6 49218.3 Public order and safety Economic affairs Bil Won Original Data 1880.8 Bil Won Original Data 9123.2 11054 2368.9 3154.6 3460.8 13248.1 15096 15679.1 3952.4 4461.8 21420.3 24281.8 4992.1 5308.6 32194.2 5719.4 5743.6 31916.8 6472.3 35193.6 7335 39650 2 7768.4 44535 8809.5 85977 9248.2 62101.8 10160.5 63795.1 11057.8 67547.9 11718 59492.9 12637.2 64358.5 13596.3 80156 14016.7 70863 14676.1 78168.8 16062.6 79338.8 17063.1 71464.9 17881.7 71829 19268.5 75428.1 21101.3 77462.4 21947.1 82111.8 22416.7 83174.1 24627.8 94044.7 2.1.8.2. General Govemment Total Expenditure by Function (cument prices, annual) General goverment - Total expenditure Environmental protection Bil. Won Housing and community amenities Bil.Won Original Data 1998.9 Original Data 1317 1820.8 2802.4 1951.6 3500.2 2403,7 4058.5 2648,3 4104.9 2966.6 4594.8 3440.1 6142.2 3853.5 7164.4 4159 8274.1 4483.6 7239.7 5058.6 7424.5 5188.7 7005.2 6111.4 7074.3 6809.2 9639.9 7483.2 11803.4 8249.5 10274.7 9649.8 10993.8 10149.9 12905.4 10202.4 13419.9 12384.5 18309.8 11503.4 15332.3 11900 15014.7 11788.3 14966.4 12642.5 14698,8 13833.1 14524.8 14371 16079,8 15143.8 16606 16330.9 18164.7 15141.3 18679.1 17123.4 21284.7 Health Recreation, culture and religion Bil. Won Bil.Won Original Datal Original Data 2926.4 865.5 3129.6 997.3 1269.2 1378.7 1531.7 1820.1 3684.1 4171.6 4650.5 5831.6 7180.5 2209 B 8170.3 2725.6 9312.8 10797.8 12685 3077.2 3559.8 3929 3985.8 4648.5 6420.5 17711.8 18766.5 20362.3 22363.3 6572.9 25076 7024.8 29390 7584.7 33401.4 8040.4 37397.3 8594.8 43583.7 9988.8 49733.7 9728.4 52327.3 10221.9 54517 10885.6 57012.7 11774.5 61599.5 11680 66328.8 12914 73547.7 14608.4 792294 15827.1 89016.8 18125.1 998366 19844.1 Education Bil.Won Original Data 7729.1 9608.7 11732.8 13120.4 15368.6 17490.5 20599 22630.8 22084.9 22776.3 24412.1 29155 32747.5 35949.2 41480.6 41127.3 41253.7 47015.3 53418.3 59028.5 58755.4 62744 66175 69704.2 73908 78019.5 79727.6 84069.5 90761.4 98703.8 Social protection Total Bil. Won Bil. Won Original Original Data Dota 4089.9 41038.9 5570.6 51636.4 6813.6 61366.7 7812.7 68755.3 8832.6 76551.4 10556.2 91750.2 11368.8 105634.9 13392.3 120597.6 19475.2 135679.7 25428.3 145106.6 21322 153571.1 23835.9 178009.7 25303.4 194957.7 29731.2 260512.9 34256.8 255654.9 39169.9 267103.3 287113.4 305521 344079.8 389086,9 391488.9 422020 443590.7 452201.4 475459.3 504008 4 527386.2 555679 591234.6 651849,2 43649.6 50783.2 58934.9 65341.6 69761.1 78227.2 87380 93108.7 102368 111114 117247.3 123695.5 131120.3 146721.9
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)
3) What was the share of defense spending in total expenditure in 2019?
- Public Economic Need To Do It In Excel 1 For Each Year From 1990 To 2019 Calculate The Share Of Expenditures For Ea 1 (133.89 KiB) Viewed 58 times