Announcement

Collapse
No announcement yet.
X
Collapse
  • Page of 1
  • Filter
  • Time
  • Show
Clear All
new posts
  • #1

    scatter plot with line

    Dear All,

    Can you anyone help me create a scatter plot for this data:
    clear
    input str10 var1 float(var2 var3 var4 var5 var6 var7 var8 var9 var10 var11 var12 var13 var14 var15 var16 var17 var18 var19 var20 var21 var22 var23 var24)
    "Country" 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022
    "ABW" -6.8 -14.1 16.9 7.8 -4.7 -8.8 8.9 -17.6 .7 -.4 7.6 18.5 -12 10 7.5 -.9 .9 5.3 4.4 -2.2 6.3 4.3 7
    "AFG" 0 0 1.3 1.3 3.6 4.4 3.4 1.9 .5 .5 1.2 .3 .3 .2 .2 .9 .5 .3 .7 .1 .1 .1 .
    "AGO" 9.6 24 11.4 20.1 9.3 -3.5 -.1 -1.4 1.9 3.1 -3.9 -2.7 -1.1 -5.4 2.7 11.1 -.3 -10 -8.1 -5.8 -3.8 -6.5 -6.3
    "ALB" 4.1 5.3 3.1 3.2 4.8 3.3 3.7 6.1 9.7 11.2 9.1 8.1 7.5 9.8 8.7 8.7 8.8 7.9 7.9 7.8 7.1 6.8 7.6
    "ARB" .5 1.2 .8 1.8 2.2 3.2 4 3.8 2.6 2.2 2.1 1.3 1.6 1.3 .9 .9 1.9 1.2 1.5 1.2 1.3 2.2 2.2
    "ARE" -.5 1.1 .1 3.4 6.8 6 5.8 5.5 1.6 .4 2.9 2 2.5 2.4 2.7 2.3 2.6 2.7 2.4 4.3 5.7 5 4.5
    "ARG" 3.7 .8 2.2 1.3 2.5 2.6 2.4 2.3 2.7 1.2 2.7 2 2.8 1.8 1 2 .6 1.8 2.2 1.5 1.3 1.4 2.4
    "ARM" 5.5 3.3 4.7 4.4 6.9 6 7.3 7.3 8.1 8.8 5.7 6.4 4.7 3.1 3.5 1.7 3.2 2.2 2.1 .7 .5 2.6 5.1
    "ATG" 10.7 16.6 10.3 12.7 10.2 10.8 22.1 23.3 9.9 6.1 7.2 5.4 9.4 7 3.4 7.9 6.5 9.9 12.2 7.8 7.5 18.1 16.2
    "AUS" 3.6 2.8 3.7 1.9 7 -3.6 4.1 5.2 4.3 3.1 3.1 4.7 3.7 3.5 4.3 3.5 3.6 3.6 4.2 2.8 1.2 1.8 4.1
    "AUT" 4.3 2.9 .1 2.4 1.1 25.7 3.1 17.7 1.5 3.6 -5.6 5.3 1.3 .1 .4 -2.1 -7.3 3.2 -6.3 -2.8 -2.9 3.7 2.1
    "AZE" 2.5 14.4 32.5 55.1 54.4 33.8 21.4 13.9 8.2 6.5 6.3 6.8 7.6 3.5 5.9 7.6 11.9 7 3 3.1 1.2 -3.1 -5.7
    "BDI" 1.3 0 . . 0 .1 0 0 .2 0 0 .2 0 4.8 3 1.6 0 0 0 0 .3 .4 .4
    "BEL" 37.5 37.3 7 10.9 12.1 8.7 14.4 20.5 36.8 16 26.1 31.3 2.4 -5.7 -2.8 -4.2 12.1 -7.4 -7.7 -4 -5.2 4.9 2.1
    "BEN" -.4 .5 -.5 .2 -.7 -.1 -.2 1.7 .5 -.2 .6 1.5 2.5 2.9 3.1 1.3 1.1 1.6 1.4 1.5 1.1 2 1.5
    "BFA" .8 .2 .4 .6 .3 .8 1.3 .3 .4 .6 .4 1.2 2.6 3.6 2.6 2 3 0 1.7 1 -.6 -.4 3.6
    "BGD" .5 .1 .1 .4 .7 1.2 .6 .8 1.4 .9 1.1 1 1.2 1.7 1.5 1.5 .9 .6 .8 .5 .4 .4 .4
    "BGR" 7.6 5.7 5.5 9.9 11.7 13.7 22.9 31.2 18.9 7.5 3.6 3.6 3.3 3.6 1.9 4.4 2.8 3.4 2.7 3.2 5.1 3 3.6
    "BHR" 4 .9 2.3 4.7 6.6 6.6 15.8 8.1 7 1.1 .6 2.7 5 11.5 4.5 .2 .8 4 4.4 2.4 2.9 4.5 4.4
    "BHS" 3.1 1.2 1.7 2.1 3 5.7 6.9 6.7 8.2 6.7 8.6 6.6 4.9 3.7 2.3 .7 3.3 2.5 3.9 3.7 4.4 3.4 4
    "BIH" 2.6 2 4 4.5 8.8 5.6 6.6 11.7 5.3 .8 2.6 2.5 2.3 1.7 2.9 2.3 1.8 2.8 2.9 2.2 2.4 3.1 3.3
    "BLR" .9 .8 1.7 1 .7 1 1 4 3.6 3.7 2.4 6.5 2.2 3 2.4 2.9 2.6 2.3 2.4 2 2.3 1.8 2.2
    "BLZ" 2.6 5.2 2.1 -.8 8 8.6 6.9 8.3 9.8 6.5 5.5 5.2 10.2 4.6 6.6 2.7 1.5 1.4 5.3 3.9 3.7 5.2 5
    "BMU" 1.9 1.1 .1 .3 18.5 .9 -1.4 9.1 2.5 -1.1 3.4 -4.1 .7 .8 -.1 -2.2 -1.1 -4 1.3 .1 6.9 .7 -.4
    "BOL" 8.8 8.7 8.6 2.4 .7 -2.5 2.5 2.8 3.1 2.4 3.2 3.6 3.9 5.7 2 1.7 1 1.9 .8 -.5 -3.1 1.4 0
    "BRA" 5 4.1 3.3 1.8 2.7 1.7 1.8 3.2 3 1.9 3.7 3.9 3.8 3 3.6 3.6 4.1 3.3 4.1 3.7 2.6 2.8 3.8
    "BRB" 2.4 3 7.4 5.8 6.6 10.2 8.1 10.2 12.8 8 9.4 9.9 11.4 2.2 16 14.5 11.5 1.8 4.7 4 5.5 4.8 3.4
    "BRN" 9.2 1.1 3.9 1.9 1.4 1.8 .8 2.1 1.5 3 3.5 3.7 4.5 4.3 3.4 1.3 -1.3 3.9 3.8 2.8 4.7 1.5 -1.8
    "BTN" . . .4 .5 1.2 .7 .6 5.9 .2 1.4 4.5 1.6 1.3 1.1 1.1 .3 .5 -.6 .1 .5 -.1 .2 .3
    "BWA" 1 .6 7.5 5.6 4.4 4.2 4.9 4.7 4.9 2.1 1.7 1.9 1.1 .5 3.3 2.8 .9 1.6 1.7 .6 .2 -1.7 1.1
    "CAN" 9.2 3.8 3.2 .8 .1 2.2 4.9 8.2 4.5 1.5 1.8 2.1 2.7 3.6 3.6 3.9 2.2 1.5 2.5 2.8 1.8 2.9 2.3
    "CHE" 8.3 3.4 2.7 5.4 1.8 .6 12.2 9.9 .5 8.6 3 2.9 5.8 -3.5 2.9 17.1 24.2 20.6 -22.1 1.2 -32.6 -14.4 -1.3
    "CHL" 6.2 5.9 3.6 4.6 5 4.9 3.1 6.1 10.5 7.4 6.8 10.5 11.9 7.6 9.8 7.3 4.6 1.9 2.7 4.9 4.5 5 6.9
    "CHN" 3.5 3.5 3.6 3.5 3.5 4.6 4.5 4.4 3.7 2.6 4 3.7 2.8 3 2.6 2.2 1.6 1.3 1.7 1.3 1.7 1.9 1
    "CIV" 1.4 1.6 1.2 .8 1.2 1.5 1.4 1.5 1.4 1.2 1 .8 .9 1 .9 1.1 1.2 1.9 1.1 1.4 1.1 1.9 2.3
    "CMR" 1.5 -.1 4.1 2.1 .4 1.2 .3 .8 .1 2.7 1.9 2.1 1.7 1.6 2 2.2 2 2.3 1.9 2.6 1.7 2.1 2.1
    "COD" .5 1.4 2.1 4.4 4 1.5 1.8 10.8 8.7 -1.3 12.7 6.2 9.9 5.2 4.2 3.1 2.5 2.8 3 2.6 3.1 3 2.8
    "COG" -3 -4.8 6.6 6.3 1.9 12 18.4 16.2 16.7 12.2 11.6 1.9 -.4 10.5 16.1 34.4 .5 37.3 29.2 -10.2 -17.3 -2.2 3.4
    "COL" 2.4 2.6 2.2 1.8 2.7 7 4.2 4.3 4.4 3.5 2.2 4.4 4.1 4.2 4.2 4 4.9 4.4 3.4 4.3 2.8 3 5
    "COM" 0 .3 .1 .1 .1 .1 .1 1 .5 1.5 .9 2.3 1 .4 .4 .5 .4 .4 .5 .4 .3 .3 .3
    "CPV" 6.3 1.6 2.4 4.8 7.3 8.3 11.9 11.6 10.8 6.8 6.4 5 6.7 4.4 8.8 5.5 6.8 5.6 4.7 5.5 3.7 4.5 5.3
    "CRI" 4.8 3.9 4.4 4.5 5.8 7.6 7.9 8.3 7.9 5.3 5.1 6.4 5.7 6.3 6.2 5.2 4.5 4.8 4.8 4.2 3.4 5.5 5.3
    "CYM" . . . . . . 590.9 631.6 426.4 474.1 504.4 743.7 500.8 792.3 1009 1709.8 54.7 48.5 3.1 18.2 121.6 -17.9 372.5
    "CYP" 8.6 9.1 9.7 6.2 6.5 6.3 9.3 9.6 44.2 248.1 120.3 146.3 279.4 108.4 222.8 145.5 40.4 62.8 -4.3 203.6 -103.2 26.2 1.6
    "CZE" 8.1 8.3 10.3 2 5.4 10 4.6 7.3 3.7 2.5 4.9 1.8 4.5 3.5 3.9 .9 5.5 5.1 3.3 4.3 3.5 4.6 3.6
    "DEU" 12.7 2.9 2.5 2.6 -.7 2.1 2.9 1.5 .8 1.7 2.5 2.6 1.9 1.8 .5 1.9 1.9 3 4.2 1.9 4.5 2.4 1.5
    "DJI" .6 .6 .6 2.3 5.8 3.1 14.1 23 22.8 9.2 3.2 6.4 8.1 14 6.9 5.9 6.1 6 5.8 5.7 5 4.9 5.1
    "DMA" 5.3 4.3 6 9.1 7 5.2 6.7 9.6 12.3 11.6 11.6 10.1 11.6 7.8 2.4 1.3 7.3 4.3 14.1 10.3 4.5 5.1 2.9
    "DNK" 21.9 5.6 2.5 .5 -3.5 4.9 .8 3.7 .6 1.2 -3.7 3.9 -5 .2 1.9 .6 2.5 1.1 2.5 -1.1 -.1 4.3 8.5
    "DOM" 4.1 4.2 3.4 2.9 4.2 3.1 4 5.1 5.7 3.5 3.4 3.8 5.6 2.6 3.6 3.1 3.3 4.5 3.2 3.2 3.1 3.6 3.5
    "DZA" .5 1.9 1.7 .9 1 1.1 1.5 1.2 1.5 1.8 1.3 1.2 .7 .7 .6 -.3 .9 .6 .8 .7 .7 .5 0
    "ECU" -.1 2.3 2.9 2.8 2.4 1.2 .6 .4 1.7 .5 .2 .8 .6 .8 .8 1.4 .8 .6 1.3 .9 1.1 .6 .7
    "EGY" 1.2 .5 .8 .3 1.6 6 9.3 8.9 5.8 3.5 2.9 -.2 1 1.5 1.5 2.1 2.4 3 3.1 2.8 1.5 1.2 2.4
    "EMU" 8.6 4.9 3.5 3 2.7 6 7.3 9.9 4.7 3.4 4.2 6 4.3 4.6 2.9 6.7 4.9 3.8 -.4 2.7 0 2.6 .1
    "ERI" 3.9 1.6 3.1 2.9 2.2 .1 1.3 .5 2.8 4.9 5.7 1.9 . . . . . . . . . . .
    "ESP" 6.8 4.6 5.6 3.4 2.4 2.3 2.6 4.6 4.5 .6 2.6 1.8 1.6 3.5 2.4 1.9 3.6 2.4 4.1 1.9 3 4 3.6
    "EST" 7.3 9.5 4.6 10.5 8.9 21.7 10.3 13.5 8.1 9.5 13.3 4.8 7.8 4.4 6.7 -3.1 3.8 6.4 4 9.8 12 20.5 4.3
    "ETH" 1.6 4.2 3.2 5.4 5.4 2.1 3.6 1.1 .4 .7 1 2 .6 2.8 3.3 4.1 5.6 4.9 4 2.7 2.2 3.8 2.9
    "FIN" 10.7 2.5 5.8 3.5 3.4 5.3 2.1 8.6 6.8 -3.5 4.9 -2.2 1.9 -1.8 6.4 7.5 2.1 6.7 -3.8 5.8 -.9 8 4.7
    "FJI" 0 2.5 1.7 1.8 9.3 5.8 19 13.7 19.3 10.7 5.7 5.7 7 5.8 7.8 4.4 7.9 7.2 8.4 5.9 5.4 9.5 2.1
    "FRA" 3 3.6 3.4 2.3 1.7 3.9 3.4 3.1 2.3 .7 1.5 1.5 1.2 1.1 .2 1.8 1.3 1.4 2.8 2 .7 3.2 3.8
    "GAB" 5.5 -2 0 1.5 4 3.4 2.6 5.3 4.5 5.2 3.6 6.2 3.9 1.8 6.9 .3 8.9 8.8 8.2 9.2 11.2 7.6 5.2
    "GBR" 9.9 3.4 5 1.8 3.6 9.9 7.5 6.8 8.7 .6 2.7 1 1.7 2 1.9 1.5 12.1 4.7 -.9 .7 5.8 .2 1.5
    "GEO" 4.3 3.4 4.7 8.4 9.6 7.1 15.1 18.6 12.5 6.1 7.4 7.6 5.7 6 10.2 11.4 10.7 11.7 7.3 7.8 3.5 6.8 8.5
    "GHA" 3.3 1.7 1 1.8 1.6 1.3 3 5.6 9.5 9.1 7.8 8.3 8 5.1 6.1 6.5 6.2 5.4 4.4 5.7 2.7 3.3 2
    "GIN" .2 0 .7 1.6 1.8 2.5 3 6.1 5.5 1.4 . 14.1 7.9 0 -.8 .6 18.8 5.6 3 .3 1.2 1.2 3.1
    "GMB" 5.6 5.2 7.4 3.8 5.8 5.2 7.8 6.1 4.5 2.7 2.4 2.6 2.9 5 1.9 5.2 4.7 4.3 4.9 3.9 10.5 12.5 10.6
    "GNB" .2 .1 .8 .7 .3 1.4 2.8 2.5 .7 2.1 2.8 2.2 .6 1.8 2.5 1.6 1.1 1.1 1.3 4.8 1.4 1.1 1.3
    "GNQ" 14.8 64.4 17.9 27.8 7.7 9.4 4.7 9.5 -4 10.9 16.8 9.2 4.4 2.7 .8 1.8 .5 2.5 3 4 4.1 3.8 3.4
    "GRC" 0 0 0 .7 .9 .3 2 .6 1.6 .8 .2 .4 .7 1.2 1.1 .6 1.4 1.7 1.9 2.4 1.8 2.9 3.7
    "GRD" 11.1 17.2 14.4 16.8 21.1 11.7 14.7 21.8 17.5 14.1 7.2 11 6.2 15.5 9.2 15.5 10.3 13.6 15.9 17.2 13.5 13.6 12.8
    "GTM" -4.1 -5.1 -5 .1 1.4 2 2.1 2.6 1.9 1.3 2.7 1.9 2.8 2.9 2.4 1.9 1.3 1.4 1.3 1.5 1.3 4.2 1.5
    "GUY" 9.4 7.9 6 3.5 3.8 9.3 4.3 5.6 5.9 5.2 5.8 6.7 6.8 4.8 5.8 3.2 3.6 6.9 24.7 32.8 23.7 27.8 3
    "HIC" 5.1 2.6 2.1 1.8 2.2 3.3 4.5 5.8 3.9 2.2 2.7 3.2 2.6 2.7 2.4 4.2 4.3 3.1 .5 2.2 1.2 2.4 1.8
    "HKG" 41.1 18.5 4.1 11.5 13.1 22.6 23.2 29.4 30.6 25.4 36.2 38.7 28.5 27.9 44.6 58.5 41.5 36.8 26.8 16.1 34 37.2 34.1
    "HND" 4.9 4 3.7 4.7 6.7 6.2 6.6 7.8 8.7 3.4 3.8 5.9 5.8 5.8 8.6 6.3 5.3 4.1 6 3.8 1 2.8 2.4
    "HRV" 4.6 4.5 3.7 5.2 3.1 4 6.7 7.8 7.7 4.9 2.6 2 2.6 1.6 5.3 .1 .8 .8 2.1 6.4 2.1 6.7 5
    "HTI" .2 .1 .1 .3 .1 .4 2.1 .8 .3 .5 1.5 .9 1.1 1.1 .7 .7 .7 2.5 .6 .5 .2 .2 .2
    "HUN" 5.8 7.6 5.4 4.9 4.4 24.3 16.1 50.4 47.4 -2.1 -15.7 7.6 8.4 -2.6 9.3 -4.2 54.2 -8.5 -40.1 60 106.5 17.4 -5.8
    "IDN" -2.8 -1.9 .1 -.3 .7 2.9 1.3 1.6 1.8 .9 2 2.3 2.3 2.6 2.8 2.3 .5 2 1.8 2.2 1.8 1.8 1.9
    "IDX" 1.6 1.9 1.8 2.2 2.5 2.2 2.6 3.3 3.6 2.9 3.5 3.9 4.4 4.1 3.2 3.5 3.1 3 2.7 2.6 2.3 2.8 2.5
    "IND" .8 1.1 1 .6 .8 .9 2.1 2.1 3.6 2.7 1.6 2 1.3 1.5 1.7 2.1 1.9 1.5 1.6 1.8 2.4 1.4 1.5
    "IRL" 25.7 8.8 22.8 13.8 -5.5 22.2 9.5 22.2 8.5 22.8 17 9.9 25.8 29.7 37.5 81.1 34.5 17.3 17.4 -11.7 6.6 17.9 -.4
    "IRN" 0 .3 2.7 1.9 1.6 1.3 .9 .6 .5 .7 .7 .7 .7 .6 .5 .5 .7 1 .7 .5 .6 .4 .4
    "IRQ" 0 0 0 4.6 .8 1 .6 1.1 1.4 1.4 1 1.1 1.6 -1 -4.5 -4.5 -3.8 -2.7 -2.1 -1.3 -1.6 -1.3 -.7
    "ISL" 1.7 2 1 2.9 5.5 18.4 22.2 31.7 6.7 .5 1.9 7.3 6.9 2.9 4.3 6.5 -5.1 -28.3 -2.4 -2.3 -4.1 1.8 4
    "ISR" 5.9 1.3 1.3 2.5 2.1 3.3 9.1 4.8 4.7 2.2 2.9 3.2 3.4 4 1.9 3.7 3.7 4.7 5.7 4.3 5.1 3.9 4.4
    "ITA" 1.1 1.3 1.4 1.2 1.1 2 2.9 3 -.4 .8 .5 1.5 0 .9 .8 .7 1.4 .6 2.1 1.8 -.9 1.2 3
    "JAM" 4.7 6.3 4.6 7.2 5.5 5.7 7.1 6.3 10 4 1.4 1.2 2.8 3.8 4.2 6.5 6.6 6 4.9 4.2 1.9 2.2 1.9
    "JOR" 10.8 3 2.5 5.4 8.2 15.8 23.5 15.3 12.5 9.8 6.2 5 4.9 5.6 5.9 4.1 3.9 4.9 2.2 1.6 1.7 1.3 2.3
    "JPN" .2 .1 .3 .2 .2 .1 -.1 .5 .5 .2 .1 0 0 .2 .4 .1 .8 .4 .5 .8 1.2 .7 1.2
    "KAZ" 7.5 12.7 10.5 8.1 13 4.5 9.4 11.4 12.6 12.4 5 7.1 6.6 4.2 3.3 3.6 12.5 2.9 .2 2.1 4.2 2.3 2.2
    "KEN" .9 0 .2 .5 .3 .1 .2 2.3 .3 .3 .4 3.1 2.4 1.8 1.2 .9 .6 1.6 .8 .5 .4 .4 .3
    "KGZ" -.2 .3 .3 2.4 7.9 1.7 6.4 5.5 7.3 4 9.9 11.1 4 8.3 4.6 17.1 9.1 -1.4 1.7 4.3 -4.9 2.4 .5
    "KHM" 3.2 3.7 3.1 1.8 2.5 6 6.6 10 7.9 8.9 12.5 12 14.1 13.6 11.1 10.1 12.4 12.6 13.1 13.5 14 12.9 12.1
    "KIR" 1 -.4 .3 .7 1.9 2.3 .5 .8 -.9 3.6 -4 -.2 -1.2 .4 1.3 -.4 .9 .4 -.5 -.3 1.2 .4 1.1
    "KNA" 20.4 18.2 15.7 16.1 9.1 9.9 15.6 18.2 19.3 17.3 15.8 10.6 13.8 16.5 16.5 13.4 12.1 4.5 3.7 5.6 .3 2.8 4.4
    "KOR" 2 1.2 .9 1 1.7 1.5 .9 .8 1.1 1 .8 .8 .7 .9 .6 .3 .8 1.1 .7 .6 .5 1.2 1.5
    "KWT" 0 -.3 0 -.1 0 .3 .1 .1 0 1.1 1.1 2.1 1.7 .8 .3 .2 .3 .1 0 .4 -.5 -.2 .4
    end
    [/CODE]
    ------------------ copy up to and including the previous line ------------------

    Thank you in advance
    Tags: None
  • #2
    Andrew:
    without further details on the variables (usually two) that you want to show in the scatter plot, I find unfeasible to help you out.
    Kind regards,
    Carlo
    (Stata 19.0)

    Comment

    • #3
      You have a simple problem.

      Observation 1 is really meta data.

      Code:
      clear
input str10 var1 float(var2 var3 var4 var5 var6 var7 var8 var9 var10 var11 var12 var13 var14 var15 var16 var17 var18 var19 var20 var21 var22 var23 var24)
"Country" 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022
      What I would do is copy the year information like this

      Code:
      foreach v of var var2-var24 { 
    local year = `v'[1] 
    label var `v' "`year" 
    rename `v'  whatever_`year' 
}
      where you should know something that would be a better prefix than whatever_

      Assuming that works, you now should get rid of observation 1.

      Code:
      drop in 1
      Now, what scatter plot and which line do you want?

      Comment

      • #4
        Scatter plot plotting the FDI (%) for each country and year

        Comment

        • #5
          You seem to be saying that the data are FDI measured as %. I guess this to be code for the scatter plots you want. As you presumably have yet more countries than shown, of the order of 200, the only feasible solution is to construct a portfolio of graphs.

          I am flagging the very high values for CYM, which also show up in summary statistics. I have no idea if those data are plausible/

          For how to loop in this case, see https://www.stata.com/support/faqs/d...-with-foreach/

          Code:
          clear
input str10 var1 float(var2 var3 var4 var5 var6 var7 var8 var9 var10 var11 var12 var13 var14 var15 var16 var17 var18 var19 var20 var21 var22 var23 var24)
"Country" 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022
"ABW" -6.8 -14.1 16.9 7.8 -4.7 -8.8 8.9 -17.6 .7 -.4 7.6 18.5 -12 10 7.5 -.9 .9 5.3 4.4 -2.2 6.3 4.3 7
"AFG" 0 0 1.3 1.3 3.6 4.4 3.4 1.9 .5 .5 1.2 .3 .3 .2 .2 .9 .5 .3 .7 .1 .1 .1 .
"AGO" 9.6 24 11.4 20.1 9.3 -3.5 -.1 -1.4 1.9 3.1 -3.9 -2.7 -1.1 -5.4 2.7 11.1 -.3 -10 -8.1 -5.8 -3.8 -6.5 -6.3
"ALB" 4.1 5.3 3.1 3.2 4.8 3.3 3.7 6.1 9.7 11.2 9.1 8.1 7.5 9.8 8.7 8.7 8.8 7.9 7.9 7.8 7.1 6.8 7.6
"ARB" .5 1.2 .8 1.8 2.2 3.2 4 3.8 2.6 2.2 2.1 1.3 1.6 1.3 .9 .9 1.9 1.2 1.5 1.2 1.3 2.2 2.2
"ARE" -.5 1.1 .1 3.4 6.8 6 5.8 5.5 1.6 .4 2.9 2 2.5 2.4 2.7 2.3 2.6 2.7 2.4 4.3 5.7 5 4.5
"ARG" 3.7 .8 2.2 1.3 2.5 2.6 2.4 2.3 2.7 1.2 2.7 2 2.8 1.8 1 2 .6 1.8 2.2 1.5 1.3 1.4 2.4
"ARM" 5.5 3.3 4.7 4.4 6.9 6 7.3 7.3 8.1 8.8 5.7 6.4 4.7 3.1 3.5 1.7 3.2 2.2 2.1 .7 .5 2.6 5.1
"ATG" 10.7 16.6 10.3 12.7 10.2 10.8 22.1 23.3 9.9 6.1 7.2 5.4 9.4 7 3.4 7.9 6.5 9.9 12.2 7.8 7.5 18.1 16.2
"AUS" 3.6 2.8 3.7 1.9 7 -3.6 4.1 5.2 4.3 3.1 3.1 4.7 3.7 3.5 4.3 3.5 3.6 3.6 4.2 2.8 1.2 1.8 4.1
"AUT" 4.3 2.9 .1 2.4 1.1 25.7 3.1 17.7 1.5 3.6 -5.6 5.3 1.3 .1 .4 -2.1 -7.3 3.2 -6.3 -2.8 -2.9 3.7 2.1
"AZE" 2.5 14.4 32.5 55.1 54.4 33.8 21.4 13.9 8.2 6.5 6.3 6.8 7.6 3.5 5.9 7.6 11.9 7 3 3.1 1.2 -3.1 -5.7
"BDI" 1.3 0 . . 0 .1 0 0 .2 0 0 .2 0 4.8 3 1.6 0 0 0 0 .3 .4 .4
"BEL" 37.5 37.3 7 10.9 12.1 8.7 14.4 20.5 36.8 16 26.1 31.3 2.4 -5.7 -2.8 -4.2 12.1 -7.4 -7.7 -4 -5.2 4.9 2.1
"BEN" -.4 .5 -.5 .2 -.7 -.1 -.2 1.7 .5 -.2 .6 1.5 2.5 2.9 3.1 1.3 1.1 1.6 1.4 1.5 1.1 2 1.5
"BFA" .8 .2 .4 .6 .3 .8 1.3 .3 .4 .6 .4 1.2 2.6 3.6 2.6 2 3 0 1.7 1 -.6 -.4 3.6
"BGD" .5 .1 .1 .4 .7 1.2 .6 .8 1.4 .9 1.1 1 1.2 1.7 1.5 1.5 .9 .6 .8 .5 .4 .4 .4
"BGR" 7.6 5.7 5.5 9.9 11.7 13.7 22.9 31.2 18.9 7.5 3.6 3.6 3.3 3.6 1.9 4.4 2.8 3.4 2.7 3.2 5.1 3 3.6
"BHR" 4 .9 2.3 4.7 6.6 6.6 15.8 8.1 7 1.1 .6 2.7 5 11.5 4.5 .2 .8 4 4.4 2.4 2.9 4.5 4.4
"BHS" 3.1 1.2 1.7 2.1 3 5.7 6.9 6.7 8.2 6.7 8.6 6.6 4.9 3.7 2.3 .7 3.3 2.5 3.9 3.7 4.4 3.4 4
"BIH" 2.6 2 4 4.5 8.8 5.6 6.6 11.7 5.3 .8 2.6 2.5 2.3 1.7 2.9 2.3 1.8 2.8 2.9 2.2 2.4 3.1 3.3
"BLR" .9 .8 1.7 1 .7 1 1 4 3.6 3.7 2.4 6.5 2.2 3 2.4 2.9 2.6 2.3 2.4 2 2.3 1.8 2.2
"BLZ" 2.6 5.2 2.1 -.8 8 8.6 6.9 8.3 9.8 6.5 5.5 5.2 10.2 4.6 6.6 2.7 1.5 1.4 5.3 3.9 3.7 5.2 5
"BMU" 1.9 1.1 .1 .3 18.5 .9 -1.4 9.1 2.5 -1.1 3.4 -4.1 .7 .8 -.1 -2.2 -1.1 -4 1.3 .1 6.9 .7 -.4
"BOL" 8.8 8.7 8.6 2.4 .7 -2.5 2.5 2.8 3.1 2.4 3.2 3.6 3.9 5.7 2 1.7 1 1.9 .8 -.5 -3.1 1.4 0
"BRA" 5 4.1 3.3 1.8 2.7 1.7 1.8 3.2 3 1.9 3.7 3.9 3.8 3 3.6 3.6 4.1 3.3 4.1 3.7 2.6 2.8 3.8
"BRB" 2.4 3 7.4 5.8 6.6 10.2 8.1 10.2 12.8 8 9.4 9.9 11.4 2.2 16 14.5 11.5 1.8 4.7 4 5.5 4.8 3.4
"BRN" 9.2 1.1 3.9 1.9 1.4 1.8 .8 2.1 1.5 3 3.5 3.7 4.5 4.3 3.4 1.3 -1.3 3.9 3.8 2.8 4.7 1.5 -1.8
"BTN" . . .4 .5 1.2 .7 .6 5.9 .2 1.4 4.5 1.6 1.3 1.1 1.1 .3 .5 -.6 .1 .5 -.1 .2 .3
"BWA" 1 .6 7.5 5.6 4.4 4.2 4.9 4.7 4.9 2.1 1.7 1.9 1.1 .5 3.3 2.8 .9 1.6 1.7 .6 .2 -1.7 1.1
"CAN" 9.2 3.8 3.2 .8 .1 2.2 4.9 8.2 4.5 1.5 1.8 2.1 2.7 3.6 3.6 3.9 2.2 1.5 2.5 2.8 1.8 2.9 2.3
"CHE" 8.3 3.4 2.7 5.4 1.8 .6 12.2 9.9 .5 8.6 3 2.9 5.8 -3.5 2.9 17.1 24.2 20.6 -22.1 1.2 -32.6 -14.4 -1.3
"CHL" 6.2 5.9 3.6 4.6 5 4.9 3.1 6.1 10.5 7.4 6.8 10.5 11.9 7.6 9.8 7.3 4.6 1.9 2.7 4.9 4.5 5 6.9
"CHN" 3.5 3.5 3.6 3.5 3.5 4.6 4.5 4.4 3.7 2.6 4 3.7 2.8 3 2.6 2.2 1.6 1.3 1.7 1.3 1.7 1.9 1
"CIV" 1.4 1.6 1.2 .8 1.2 1.5 1.4 1.5 1.4 1.2 1 .8 .9 1 .9 1.1 1.2 1.9 1.1 1.4 1.1 1.9 2.3
"CMR" 1.5 -.1 4.1 2.1 .4 1.2 .3 .8 .1 2.7 1.9 2.1 1.7 1.6 2 2.2 2 2.3 1.9 2.6 1.7 2.1 2.1
"COD" .5 1.4 2.1 4.4 4 1.5 1.8 10.8 8.7 -1.3 12.7 6.2 9.9 5.2 4.2 3.1 2.5 2.8 3 2.6 3.1 3 2.8
"COG" -3 -4.8 6.6 6.3 1.9 12 18.4 16.2 16.7 12.2 11.6 1.9 -.4 10.5 16.1 34.4 .5 37.3 29.2 -10.2 -17.3 -2.2 3.4
"COL" 2.4 2.6 2.2 1.8 2.7 7 4.2 4.3 4.4 3.5 2.2 4.4 4.1 4.2 4.2 4 4.9 4.4 3.4 4.3 2.8 3 5
"COM" 0 .3 .1 .1 .1 .1 .1 1 .5 1.5 .9 2.3 1 .4 .4 .5 .4 .4 .5 .4 .3 .3 .3
"CPV" 6.3 1.6 2.4 4.8 7.3 8.3 11.9 11.6 10.8 6.8 6.4 5 6.7 4.4 8.8 5.5 6.8 5.6 4.7 5.5 3.7 4.5 5.3
"CRI" 4.8 3.9 4.4 4.5 5.8 7.6 7.9 8.3 7.9 5.3 5.1 6.4 5.7 6.3 6.2 5.2 4.5 4.8 4.8 4.2 3.4 5.5 5.3
"CYM" . . . . . . 590.9 631.6 426.4 474.1 504.4 743.7 500.8 792.3 1009 1709.8 54.7 48.5 3.1 18.2 121.6 -17.9 372.5
"CYP" 8.6 9.1 9.7 6.2 6.5 6.3 9.3 9.6 44.2 248.1 120.3 146.3 279.4 108.4 222.8 145.5 40.4 62.8 -4.3 203.6 -103.2 26.2 1.6
"CZE" 8.1 8.3 10.3 2 5.4 10 4.6 7.3 3.7 2.5 4.9 1.8 4.5 3.5 3.9 .9 5.5 5.1 3.3 4.3 3.5 4.6 3.6
"DEU" 12.7 2.9 2.5 2.6 -.7 2.1 2.9 1.5 .8 1.7 2.5 2.6 1.9 1.8 .5 1.9 1.9 3 4.2 1.9 4.5 2.4 1.5
"DJI" .6 .6 .6 2.3 5.8 3.1 14.1 23 22.8 9.2 3.2 6.4 8.1 14 6.9 5.9 6.1 6 5.8 5.7 5 4.9 5.1
"DMA" 5.3 4.3 6 9.1 7 5.2 6.7 9.6 12.3 11.6 11.6 10.1 11.6 7.8 2.4 1.3 7.3 4.3 14.1 10.3 4.5 5.1 2.9
"DNK" 21.9 5.6 2.5 .5 -3.5 4.9 .8 3.7 .6 1.2 -3.7 3.9 -5 .2 1.9 .6 2.5 1.1 2.5 -1.1 -.1 4.3 8.5
"DOM" 4.1 4.2 3.4 2.9 4.2 3.1 4 5.1 5.7 3.5 3.4 3.8 5.6 2.6 3.6 3.1 3.3 4.5 3.2 3.2 3.1 3.6 3.5
"DZA" .5 1.9 1.7 .9 1 1.1 1.5 1.2 1.5 1.8 1.3 1.2 .7 .7 .6 -.3 .9 .6 .8 .7 .7 .5 0
"ECU" -.1 2.3 2.9 2.8 2.4 1.2 .6 .4 1.7 .5 .2 .8 .6 .8 .8 1.4 .8 .6 1.3 .9 1.1 .6 .7
"EGY" 1.2 .5 .8 .3 1.6 6 9.3 8.9 5.8 3.5 2.9 -.2 1 1.5 1.5 2.1 2.4 3 3.1 2.8 1.5 1.2 2.4
"EMU" 8.6 4.9 3.5 3 2.7 6 7.3 9.9 4.7 3.4 4.2 6 4.3 4.6 2.9 6.7 4.9 3.8 -.4 2.7 0 2.6 .1
"ERI" 3.9 1.6 3.1 2.9 2.2 .1 1.3 .5 2.8 4.9 5.7 1.9 . . . . . . . . . . .
"ESP" 6.8 4.6 5.6 3.4 2.4 2.3 2.6 4.6 4.5 .6 2.6 1.8 1.6 3.5 2.4 1.9 3.6 2.4 4.1 1.9 3 4 3.6
"EST" 7.3 9.5 4.6 10.5 8.9 21.7 10.3 13.5 8.1 9.5 13.3 4.8 7.8 4.4 6.7 -3.1 3.8 6.4 4 9.8 12 20.5 4.3
"ETH" 1.6 4.2 3.2 5.4 5.4 2.1 3.6 1.1 .4 .7 1 2 .6 2.8 3.3 4.1 5.6 4.9 4 2.7 2.2 3.8 2.9
"FIN" 10.7 2.5 5.8 3.5 3.4 5.3 2.1 8.6 6.8 -3.5 4.9 -2.2 1.9 -1.8 6.4 7.5 2.1 6.7 -3.8 5.8 -.9 8 4.7
"FJI" 0 2.5 1.7 1.8 9.3 5.8 19 13.7 19.3 10.7 5.7 5.7 7 5.8 7.8 4.4 7.9 7.2 8.4 5.9 5.4 9.5 2.1
"FRA" 3 3.6 3.4 2.3 1.7 3.9 3.4 3.1 2.3 .7 1.5 1.5 1.2 1.1 .2 1.8 1.3 1.4 2.8 2 .7 3.2 3.8
"GAB" 5.5 -2 0 1.5 4 3.4 2.6 5.3 4.5 5.2 3.6 6.2 3.9 1.8 6.9 .3 8.9 8.8 8.2 9.2 11.2 7.6 5.2
"GBR" 9.9 3.4 5 1.8 3.6 9.9 7.5 6.8 8.7 .6 2.7 1 1.7 2 1.9 1.5 12.1 4.7 -.9 .7 5.8 .2 1.5
"GEO" 4.3 3.4 4.7 8.4 9.6 7.1 15.1 18.6 12.5 6.1 7.4 7.6 5.7 6 10.2 11.4 10.7 11.7 7.3 7.8 3.5 6.8 8.5
"GHA" 3.3 1.7 1 1.8 1.6 1.3 3 5.6 9.5 9.1 7.8 8.3 8 5.1 6.1 6.5 6.2 5.4 4.4 5.7 2.7 3.3 2
"GIN" .2 0 .7 1.6 1.8 2.5 3 6.1 5.5 1.4 . 14.1 7.9 0 -.8 .6 18.8 5.6 3 .3 1.2 1.2 3.1
"GMB" 5.6 5.2 7.4 3.8 5.8 5.2 7.8 6.1 4.5 2.7 2.4 2.6 2.9 5 1.9 5.2 4.7 4.3 4.9 3.9 10.5 12.5 10.6
"GNB" .2 .1 .8 .7 .3 1.4 2.8 2.5 .7 2.1 2.8 2.2 .6 1.8 2.5 1.6 1.1 1.1 1.3 4.8 1.4 1.1 1.3
"GNQ" 14.8 64.4 17.9 27.8 7.7 9.4 4.7 9.5 -4 10.9 16.8 9.2 4.4 2.7 .8 1.8 .5 2.5 3 4 4.1 3.8 3.4
"GRC" 0 0 0 .7 .9 .3 2 .6 1.6 .8 .2 .4 .7 1.2 1.1 .6 1.4 1.7 1.9 2.4 1.8 2.9 3.7
"GRD" 11.1 17.2 14.4 16.8 21.1 11.7 14.7 21.8 17.5 14.1 7.2 11 6.2 15.5 9.2 15.5 10.3 13.6 15.9 17.2 13.5 13.6 12.8
"GTM" -4.1 -5.1 -5 .1 1.4 2 2.1 2.6 1.9 1.3 2.7 1.9 2.8 2.9 2.4 1.9 1.3 1.4 1.3 1.5 1.3 4.2 1.5
"GUY" 9.4 7.9 6 3.5 3.8 9.3 4.3 5.6 5.9 5.2 5.8 6.7 6.8 4.8 5.8 3.2 3.6 6.9 24.7 32.8 23.7 27.8 3
"HIC" 5.1 2.6 2.1 1.8 2.2 3.3 4.5 5.8 3.9 2.2 2.7 3.2 2.6 2.7 2.4 4.2 4.3 3.1 .5 2.2 1.2 2.4 1.8
"HKG" 41.1 18.5 4.1 11.5 13.1 22.6 23.2 29.4 30.6 25.4 36.2 38.7 28.5 27.9 44.6 58.5 41.5 36.8 26.8 16.1 34 37.2 34.1
"HND" 4.9 4 3.7 4.7 6.7 6.2 6.6 7.8 8.7 3.4 3.8 5.9 5.8 5.8 8.6 6.3 5.3 4.1 6 3.8 1 2.8 2.4
"HRV" 4.6 4.5 3.7 5.2 3.1 4 6.7 7.8 7.7 4.9 2.6 2 2.6 1.6 5.3 .1 .8 .8 2.1 6.4 2.1 6.7 5
"HTI" .2 .1 .1 .3 .1 .4 2.1 .8 .3 .5 1.5 .9 1.1 1.1 .7 .7 .7 2.5 .6 .5 .2 .2 .2
"HUN" 5.8 7.6 5.4 4.9 4.4 24.3 16.1 50.4 47.4 -2.1 -15.7 7.6 8.4 -2.6 9.3 -4.2 54.2 -8.5 -40.1 60 106.5 17.4 -5.8
"IDN" -2.8 -1.9 .1 -.3 .7 2.9 1.3 1.6 1.8 .9 2 2.3 2.3 2.6 2.8 2.3 .5 2 1.8 2.2 1.8 1.8 1.9
"IDX" 1.6 1.9 1.8 2.2 2.5 2.2 2.6 3.3 3.6 2.9 3.5 3.9 4.4 4.1 3.2 3.5 3.1 3 2.7 2.6 2.3 2.8 2.5
"IND" .8 1.1 1 .6 .8 .9 2.1 2.1 3.6 2.7 1.6 2 1.3 1.5 1.7 2.1 1.9 1.5 1.6 1.8 2.4 1.4 1.5
"IRL" 25.7 8.8 22.8 13.8 -5.5 22.2 9.5 22.2 8.5 22.8 17 9.9 25.8 29.7 37.5 81.1 34.5 17.3 17.4 -11.7 6.6 17.9 -.4
"IRN" 0 .3 2.7 1.9 1.6 1.3 .9 .6 .5 .7 .7 .7 .7 .6 .5 .5 .7 1 .7 .5 .6 .4 .4
"IRQ" 0 0 0 4.6 .8 1 .6 1.1 1.4 1.4 1 1.1 1.6 -1 -4.5 -4.5 -3.8 -2.7 -2.1 -1.3 -1.6 -1.3 -.7
"ISL" 1.7 2 1 2.9 5.5 18.4 22.2 31.7 6.7 .5 1.9 7.3 6.9 2.9 4.3 6.5 -5.1 -28.3 -2.4 -2.3 -4.1 1.8 4
"ISR" 5.9 1.3 1.3 2.5 2.1 3.3 9.1 4.8 4.7 2.2 2.9 3.2 3.4 4 1.9 3.7 3.7 4.7 5.7 4.3 5.1 3.9 4.4
"ITA" 1.1 1.3 1.4 1.2 1.1 2 2.9 3 -.4 .8 .5 1.5 0 .9 .8 .7 1.4 .6 2.1 1.8 -.9 1.2 3
"JAM" 4.7 6.3 4.6 7.2 5.5 5.7 7.1 6.3 10 4 1.4 1.2 2.8 3.8 4.2 6.5 6.6 6 4.9 4.2 1.9 2.2 1.9
"JOR" 10.8 3 2.5 5.4 8.2 15.8 23.5 15.3 12.5 9.8 6.2 5 4.9 5.6 5.9 4.1 3.9 4.9 2.2 1.6 1.7 1.3 2.3
"JPN" .2 .1 .3 .2 .2 .1 -.1 .5 .5 .2 .1 0 0 .2 .4 .1 .8 .4 .5 .8 1.2 .7 1.2
"KAZ" 7.5 12.7 10.5 8.1 13 4.5 9.4 11.4 12.6 12.4 5 7.1 6.6 4.2 3.3 3.6 12.5 2.9 .2 2.1 4.2 2.3 2.2
"KEN" .9 0 .2 .5 .3 .1 .2 2.3 .3 .3 .4 3.1 2.4 1.8 1.2 .9 .6 1.6 .8 .5 .4 .4 .3
"KGZ" -.2 .3 .3 2.4 7.9 1.7 6.4 5.5 7.3 4 9.9 11.1 4 8.3 4.6 17.1 9.1 -1.4 1.7 4.3 -4.9 2.4 .5
"KHM" 3.2 3.7 3.1 1.8 2.5 6 6.6 10 7.9 8.9 12.5 12 14.1 13.6 11.1 10.1 12.4 12.6 13.1 13.5 14 12.9 12.1
"KIR" 1 -.4 .3 .7 1.9 2.3 .5 .8 -.9 3.6 -4 -.2 -1.2 .4 1.3 -.4 .9 .4 -.5 -.3 1.2 .4 1.1
"KNA" 20.4 18.2 15.7 16.1 9.1 9.9 15.6 18.2 19.3 17.3 15.8 10.6 13.8 16.5 16.5 13.4 12.1 4.5 3.7 5.6 .3 2.8 4.4
"KOR" 2 1.2 .9 1 1.7 1.5 .9 .8 1.1 1 .8 .8 .7 .9 .6 .3 .8 1.1 .7 .6 .5 1.2 1.5
"KWT" 0 -.3 0 -.1 0 .3 .1 .1 0 1.1 1.1 2.1 1.7 .8 .3 .2 .3 .1 0 .4 -.5 -.2 .4
end

foreach v of var var2-var24 { 
    local year = `v'[1]
    rename `v' FDI`year'
}

drop in 1 

destring *, replace 

rename var1 Country 

reshape long FDI, i(Country) j(year)

su FDI, detail 

quantile FDI , name(FDI) 

scatter FDI year if Country == "CYM" || lfit FDI year if Country == "CYM",  subtitle(CYM) legend(off) ytitle(FDI)

encode Country, gen(id)

su id, meanonly 

forval i = 1/`r(max)' { 
    local which : label (id) `i'
    scatter FDI year if id == `i' || lfit FDI year if id == `i', subtitle("`which'") legend(off) ytitle(FDI) name(`which') 
}
          Click image for larger version Name: CYM.png Views: 1 Size: 30.1 KB ID: 1762341


          • 1 like

          Comment

          Previous Next
          Working...
          X