Hi i want one and half page for this assignment. you need to look at the excel that i will post and you have to answer the question below
Q1. Use the data and averages to analyze the regions selected. Based on the data, which individual countries
passed/failed the sustainable criterion?
In your answer explain how the sustainable criterion is measured. Which three countries ranked the highest in
“genuine investment” in each 10 year span (1985-1994) (1995-2004) and
(2005-2014)? Which countries are improving over the three consecutive time
periods? Which countries are getting worse over the three consecutive time periods?
sustainable_excel_1.xlsx
Unformatted Attachment Preview
Series Name
Series Code
Country Name
Country Code
1985 [YR1985]
1986 [YR1986]
1987 [YR1987]
1990 [YR1990]
1991 [YR1991]
1992 [YR1992]
Adjusted net savings, including
NY.ADJ.SVNG.GN.ZSBrazil
particulate emission damage (% of GNI)
BRA
..
..
..
7.441109 8.226682 9.619561
Adjusted net savings, including
NY.ADJ.SVNG.GN.ZSChina
particulate emission damage (% of GNI)
CHN
..
..
..
21.00582 21.69231 22.85464
Adjusted net savings, including
NY.ADJ.SVNG.GN.ZSUnited
particulate emission
States
damage (% of GNI)
USA
..
..
..
6.838558 6.910457 7.248867
Adjusted net savings, including
NY.ADJ.SVNG.GN.ZSSpain
particulate emission damage (% of GNI)
ESP
..
..
..
12.36273 12.00731 10.42756
Adjusted net savings, including
NY.ADJ.SVNG.GN.ZSLow
particulate emission
& middle
damage
income
(% of GNI)
LMY
..
..
..
7.398753 7.788972 8.659706
Adjusted net savings, including
NY.ADJ.SVNG.GN.ZSIndia
particulate emission damage (% of GNI)
IND
..
..
..
10.2627 8.307185 9.622703
Adjusted net savings, including
NY.ADJ.SVNG.GN.ZSGermany
particulate emission damage (% of GNI)
DEU
..
..
..
..
11.69583 11.25881
Adjusted net savings, including
NY.ADJ.SVNG.GN.ZSJapan
particulate emission damage (% of GNI)
JPN
..
..
..
19.89595 19.43462 17.39951
Adjusted net savings, including
NY.ADJ.SVNG.GN.ZSSouth
particulate emission
Africa
damage (% of GNI)
ZAF
..
..
..
3.228581 4.193501 4.226735
Adjusted net savings, including
NY.ADJ.SVNG.GN.ZSUnited
particulate emission
Kingdom
damage (% of GNI)
GBR
..
..
..
1.381063 0.328525 0.326355
Adjusted net savings, including
NY.ADJ.SVNG.GN.ZSCongo,
particulate emission
Dem.
damage
Rep. (% of GNI)
ZAR
..
..
..
..
..
..
Data from database: World Development Indicators
Last Updated: 08/10/2016
1993 [YR1993]
1994 [YR1994]
2000 [YR2000]
2006 [YR2006]
2007 [YR2007]
2008 [YR2008]
2009 [YR2009]
2010 [YR2010]
2011 [YR2011]
2012 [YR2012]
2013 [YR2013]
2014 [YR2014]
2015 [YR2015]
10.83752 11.30785
1.9558 6.308232 6.966317 6.608499 5.003699 10.46337 10.34018 7.816697 6.001188 7.341889 ..
26.16684 28.24496 22.81787 33.3566 33.41062 32.83834 37.47435 34.38165 31.24381 33.81303 34.03785 34.54056 ..
6.392807 7.703446 9.13111 6.774396 4.670325 1.889611 1.54893 2.797694 3.545417 5.690151 5.470228 6.418385 ..
9.99173 9.760466 12.15694 10.72477 10.15112 8.650463 7.980035 6.849515 5.407035 5.786219 6.563976 6.635295 ..
9.973951 12.14813 11.71369 16.62763 17.23284 16.78858 19.27268 19.45498 18.58675 19.74971 19.60059 21.23534 ..
7.796879 10.96029 13.38141 22.60623 24.0335 19.33024 21.83767 21.17592 20.82322 19.80747 19.42935 18.97784 ..
9.543332 9.619331 8.81628 11.99935 14.18417 12.86088 9.557726 11.49069 13.44018 12.43697 12.20977 13.26253 ..
15.43004 13.96812
10.105 8.54466 9.389202 7.026684 2.628755 4.793784 3.455726 3.633541 3.457866 3.379964 ..
5.22451 5.463766 3.989758 3.425343 2.679586 0.62439 4.363496 4.638216 4.080526 3.08334 1.49471 2.127864 ..
1.216597 4.589514 5.789769 4.941678 5.493166 3.327736 1.828803 4.092257 4.837336 3.641913 3.340382 3.617044 ..
..
..
-4.50866 -11.5355 -16.8889 -24.7247 -20.5681 -18.7602 -19.2206 -17.9945 -29.3911 -26.6406 ..
Average average 1985 – 1994 Average 1995 -2004 Average 2005 – 2014
7.281822
9.486545112
3.278721214 7.281821757
33.57049
23.9929121
27.01879284 33.57048824
4.440905
7.018826883
8.249873237 4.440904658
7.990707
10.90995766
12.55045109 7.990707108
18.3283
9.193901632
12.45902669 18.32830422
20.97546
9.389950695
14.06997936 20.97546469
12.12202
10.52932445
9.055872992 12.12201688
5.48459
17.22564727
10.4801208 5.484590435
3.002894
4.46741882
4.712398217
3.00289429
4.089855
1.568410908
6.407285487 4.089855451
-19.6708 ..
-10.73371482 -19.67083306
Code
Indicator Name
NY.ADJ.SVNG.GN.ZSAdjusted net savings, including particulate emission damage (% of GNI)
Long definition
Adjusted net savings are equal to net national savings plus education expenditure and minus energy depletion, mineral deple
Source
World Bank staff estimates based on sources and methods in World Bank’s “The Changing Wealth of Nations: Measuring Sust
h of Nations: Measuring Sustainable Development in the New Millennium” (2011).
…
Purchase answer to see full
attachment
Recent Comments