Dear All,
Can you help me generate a trend line graph for different education expenditure by area.
Three variables
Edu_exp : Total Education Expenditure
Edu_exp_newentrant: New entrant
Edu_exp_notnew: New entrant
Different categories
How do generate line graph for the year of 2012,2017 and 2022 for different education expenditure in one graph (trend). and then different graph for different Area (urban, Rural)
Please find below an example of my data set.
----------------------- copy starting from the next line -----------------------
------------------ copy up to and including the previous line ------------------
Listed 100 out of 33968 observations
Thank you in advance
Can you help me generate a trend line graph for different education expenditure by area.
Three variables
Edu_exp : Total Education Expenditure
Edu_exp_newentrant: New entrant
Edu_exp_notnew: New entrant
Different categories
How do generate line graph for the year of 2012,2017 and 2022 for different education expenditure in one graph (trend). and then different graph for different Area (urban, Rural)
Please find below an example of my data set.
----------------------- copy starting from the next line -----------------------
Code:
* Example generated by -dataex-. For more info, type help dataex clear input float area double(dcode ed8a1 ed8a2 ed8a3 ed8a4 ed8a5 ed8a6 ed8b1 ed8b2 ed8b3 ed8b4 ed8b5 ed8b6 educ_exp educ_expnew_entrant educ_exp_notnew) float year 2 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2012 2 1 0 0 0 0 0 0 100 0 1500 0 370 0 164.1666717529297 0 164.1666717529297 2012 2 1 0 0 0 0 0 0 100 0 500 0 1000 0 133.3333282470703 0 133.3333282470703 2012 2 1 0 0 0 0 0 0 100 0 120 0 600 0 68.33333587646484 0 68.33333587646484 2012 2 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2012 2 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2012 2 1 0 0 0 0 0 0 200 0 300 0 2300 0 233.33333587646484 0 233.33333587646484 2012 2 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2012 2 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2012 2 1 0 0 0 0 0 0 650 0 2400 0 0 5000 670.8333435058594 0 670.8333435058594 2012 2 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2012 2 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2012 2 1 35 0 0 0 800 0 0 0 0 0 0 0 69.58333587646484 69.58333587646484 0 2012 2 1 0 0 0 0 0 0 1040 0 2400 0 3000 5000 953.3333587646484 0 953.3333587646484 2012 2 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2012 2 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2012 2 1 0 0 0 0 0 0 90 0 0 0 4500 0 382.5 0 382.5 2012 2 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2012 2 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2012 2 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2012 2 1 0 0 0 0 0 0 35 0 200 0 0 2000 186.25 0 186.25 2012 2 1 0 0 0 0 0 0 70 0 0 0 3500 0 297.49999237060547 0 297.49999237060547 2012 2 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2012 2 1 0 0 0 0 0 0 645 0 1800 0 3600 0 503.74998474121094 0 503.74998474121094 2012 2 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2012 2 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2012 2 1 0 0 0 0 0 0 1100 0 2000 0 4000 0 591.6666870117188 0 591.6666870117188 2012 2 1 105 0 600 0 900 0 550 0 1600 0 3500 0 604.5833282470703 133.75 470.8333282470703 2012 2 1 0 0 0 0 0 0 140 0 200 0 1600 0 161.6666717529297 0 161.6666717529297 2012 2 1 0 0 0 0 0 0 190 0 500 0 1700 0 199.16666412353516 0 199.16666412353516 2012 2 1 0 0 0 0 0 0 780 0 2300 0 6500 0 798.3333435058594 0 798.3333435058594 2012 2 1 0 0 0 0 0 0 740 0 1500 0 4000 0 519.9999847412109 0 519.9999847412109 2012 2 1 0 0 0 0 0 0 500 0 1500 0 3000 0 416.6666564941406 0 416.6666564941406 2012 2 1 0 0 0 0 0 0 290 0 1000 0 0 3000 357.5 0 357.5 2012 2 1 0 0 0 0 0 0 285 0 1500 0 0 4200 498.75 0 498.75 2012 2 1 0 0 0 0 0 0 290 0 400 0 0 1400 174.1666717529297 0 174.1666717529297 2012 2 1 0 0 0 0 0 0 620 0 3000 0 6000 0 801.6666564941406 0 801.6666564941406 2012 2 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2012 2 1 0 0 0 0 0 0 150 0 200 0 2500 0 237.5 0 237.5 2012 2 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2012 2 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2012 2 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2012 2 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2012 2 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2012 2 1 0 0 0 0 0 0 550 0 2000 0 3000 0 462.5 0 462.5 2012 2 1 35 0 300 0 950 0 25000 0 650 0 2450 0 2448.75008392334 107.08333587646484 2341.666748046875 2012 2 1 0 0 0 0 0 0 270 500 500 0 6500 0 647.5 0 647.5 2012 2 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2012 2 1 0 0 0 0 0 0 35 0 100 0 900 0 86.25 0 86.25 2012 2 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2012 2 1 0 0 0 0 0 0 30105 0 1500 0 4300 0 2992.083251953125 0 2992.083251953125 2012 2 1 0 0 0 0 0 0 210 0 1100 0 3790 0 425 0 425 2012 2 1 0 0 0 0 0 0 30 23300 600 0 3500 0 2285.833251953125 0 2285.833251953125 2012 2 1 0 0 0 0 0 0 30500 0 2300 0 0 6500 3275.0000915527344 0 3275.0000915527344 2012 2 1 0 0 0 0 0 0 300 0 3800 0 8500 0 1050.0000305175781 0 1050.0000305175781 2012 2 1 0 0 0 0 0 0 345 500 3000 0 8500 0 1028.7499923706055 0 1028.7499923706055 2012 2 1 0 0 0 0 0 0 70 495 0 0 3000 0 297.0833435058594 0 297.0833435058594 2012 2 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2012 2 1 0 0 0 0 0 0 45 0 0 0 1500 0 128.75 0 128.75 2012 2 1 0 0 0 0 0 0 590 500 1700 0 4500 0 607.4999847412109 0 607.4999847412109 2012 2 1 45 0 0 0 1500 0 45 0 100 0 2500 0 349.1666717529297 128.75 220.4166717529297 2012 2 1 0 0 0 0 0 0 240 0 1600 0 4000 0 486.6666717529297 0 486.6666717529297 2012 2 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2012 2 1 0 0 0 0 0 0 350 0 3600 0 7000 1100 1004.1666564941406 0 1004.1666564941406 2012 2 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2012 2 1 0 0 0 0 0 0 205 0 1000 0 1500 0 225.4166717529297 0 225.4166717529297 2012 2 1 0 0 0 0 0 0 35 0 0 0 900 0 77.91666412353516 0 77.91666412353516 2012 2 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2012 2 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2012 2 1 0 0 0 0 0 0 450 0 500 0 1000 0 162.5 0 162.5 2012 2 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2012 2 1 0 0 0 0 0 0 105 0 600 0 515 0 101.66666412353516 0 101.66666412353516 2012 2 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2012 2 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2012 2 1 0 0 0 0 0 0 35 0 0 0 0 0 2.9166667461395264 0 2.9166667461395264 2012 2 1 0 0 0 0 0 0 70 0 0 0 1150 0 101.66666793823242 0 101.66666793823242 2012 2 1 0 0 0 0 0 0 70 0 300 0 1000 1000 197.5 0 197.5 2012 2 1 0 0 0 0 0 0 70 0 0 0 0 0 5.833333492279053 0 5.833333492279053 2012 2 1 0 0 0 0 0 0 955 0 1000 0 0 6000 662.9166717529297 0 662.9166717529297 2012 2 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2012 2 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2012 2 1 0 0 0 0 0 0 35 0 0 0 800 0 69.58333587646484 0 69.58333587646484 2012 2 1 0 0 0 0 0 0 5035 0 0 0 1500 0 544.5833206176758 0 544.5833206176758 2012 2 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2012 2 1 0 0 0 0 0 0 420 0 1450 0 2000 0 322.4999952316284 0 322.4999952316284 2012 2 1 0 0 0 0 0 0 0 68000 3000 0 3500 0 6208.33349609375 0 6208.33349609375 2012 2 1 0 0 0 0 0 0 700 100 1450 0 4000 0 520.8333282470703 0 520.8333282470703 2012 2 1 0 0 0 0 0 0 70 0 0 0 2000 0 172.5 0 172.5 2012 2 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2012 2 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2012 2 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2012 2 1 30 0 0 0 1500 0 30 0 0 0 1000 0 213.33333587646484 127.5 85.83333587646484 2012 2 1 0 0 0 0 0 0 50 0 500 0 500 0 87.5 0 87.5 2012 2 1 0 0 0 0 1500 0 0 0 0 0 0 0 125 125 0 2012 2 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2012 2 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2012 2 1 0 0 0 0 0 0 30 0 500 0 2000 0 210.8333282470703 0 210.8333282470703 2012 2 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2012 2 1 0 0 0 0 0 0 530 0 2000 0 3000 0 460.8333435058594 0 460.8333435058594 2012 2 1 0 0 0 0 0 0 330 0 800 0 13000 0 1177.5000305175781 0 1177.5000305175781 2012 end label values area area label def area 2 "rural", modify label values dcode dcode label def dcode 1 "Bumthang", modify
Listed 100 out of 33968 observations
Thank you in advance
Comment