A. List the country with the highest and the country with the lowest HDI. [Hint use MIN and MAXfunctions in Excel or sort the data]

B. List GNI Index and HDI for USA and Qatar.

C. Plot HDI against GNI per capita.Figure 2C: HDI against Income

D. Identify trends and outliers. Interpret. [Hint: To give a sufficient answer about trends and outliers,look at individual indices for the countries that are outliers]

Country	Expectedyearsofschooling	Meanyearsofschooling	Lifeexpectancyatbirth	GNIpercapita(2011PPP$)	EducationIndex	LifeExcpectancyIndex	GNIIndex	HDI
Qatar	12.2	9.7	80.1	110,489
Liechtenstein	14.7	12.5	80.5	99,732
Singapore	16.3	11.5	83.5	83,793
BruneiDarussalam	14.4	9.1	75.7	76,389
Kuwait	13.8	7.3	75.4	71,164
Norway	18.1	12.6	82.3	68,059
UnitedArabEmirates	13.6	11	77.8	66,912
Luxembourg	14.2	12.2	82.1	65,543
HongKong,Congo	16.5	12	84.7	60,221
Switzerland	16.2	13.4	83.6	59,375
UnitedStates	16.3	13.4	78.9	56,140
Ireland	18.8	12.5	82.1	55,660
Netherlands	18	12.2	82.1	50,013
SaudiArabia	17	9.7	75	49,338
Denmark	19.1	12.6	80.8	48,836
Andorra	13.3	10.2	81.8	48,641
Sweden	18.8	12.4	82.7	47,955
Iceland	19.2	12.5	82.9	47,566
Germany	17.1	14.1	81.2	46,946
Austria	16.3	12.6	81.4	46,231
Australia	22.1	12.7	83.3	44,097
Belgium	19.7	11.8	81.5	43,821
Canada	16.1	13.3	82.3	43,602
Finland	19.3	12.4	81.7	41,779
Japan	15.2	12.8	84.5	40,799
France	15.5	11.4	82.5	40,511
Bahrain	15.3	9.4	77.2	40,399
UnitedKingdom	17.4	13	81.2	39,507
Oman	14.7	9.7	77.6	37,039
Italy	16.2	10.2	83.4	36,141
NewZealand	18.8	12.7	82.1	35,108
Spain	17.9	9.8	83.4	35,041
Malta	15.9	11.3	82.4	34,795
Israel	16	13	82.8	33,650
Cyprus	14.7	12.1	80.8	33,100
Slovenia	17.4	12.3	81.2	32,143
Czechia	16.8	12.7	79.2	31,597
Slovakia	14.5	12.6	77.4	30,672
Estonia	16.1	13	78.6	30,379
Lithuania	16.5	13	75.7	29,775
TrinidadandTobago	13	11	73.4	28,497
Bahamas	12.8	11.5	73.8	28,395
Portugal	16.3	9.2	81.9	27,935
Poland	16.4	12.3	78.5	27,626
Malaysia	13.5	10.2	76	27,227
Hungary	15.1	11.9	76.7	27,144
SaintKittsandNevis	13.6	8.5	74.6	26,770
Latvia	16	12.8	75.2	26,301
Seychelles	15.5	9.7	73.3	25,077
RussianFederation	15.5	12	72.4	25,036
Greece	17.3	10.5	82.1	24,909
Turkey	16.4	7.7	77.4	24,905
Romania	14.3	11	75.9	23,906
Croatia	15	11.4	78.3	23,061
Mauritius	15	9.4	74.9	22,724
AntiguaandBarbuda	12.5	9.3	76.9	22,201
Kazakhstan	15.3	11.8	73.2	22,168
Chile	16.5	10.4	80	21,972
Panama	12.9	10.2	78.3	20,455
Bulgaria	14.8	11.8	74.9	19,646
Uruguay	16.3	8.7	77.8	19,435
Iran	14.7	10	76.5	18,166
EquatorialGuinea	9.2	5.6	58.4	17,796
Mexico	14.3	8.6	75	17,628
Argentina	17.6	10.6	76.5	17,611
Montenegro	15	11.4	76.8	17,511
Belarus	15.4	12.3	74.6	17,039
Palau	15.6	12.4	73.7	16,720
Turkmenistan	10.9	9.8	68.1	16,407
Thailand	14.7	7.7	76.9	16,129
China	13.9	7.9	76.7	16,127
Botswana	12.7	9.3	69.3	15,951
Barbados	15.2	10.6	79.1	15,912
Gabon	12.9	8.3	66.2	15,794
Iraq	11.1	7.3	70.5	15,365
Azerbaijan	12.4	10.5	72.9	15,240
Serbia	14.8	11.2	75.8	15,218
DominicanRepublic	14.1	7.9	73.9	15,074
CostaRica	15.4	8.7	80.1	14,790
Brazil	15.4	7.8	75.7	14,068
Algeria	14.7	8	76.7	13,639
Colombia	14.6	8.3	77.1	12,896
NorthMacedonia	13.5	9.7	75.7	12,874
BosniaandHerzegovina	13.8	9.7	77.3	12,690
Grenada	16.6	8.8	72.4	12,684
Maldives	12.1	6.8	78.6	12,549
Peru	13.8	9.2	76.5	12,323
Albania	15.2	10.1	78.5	12,300
Suriname	12.9	9.1	71.6	11,933
SouthAfrica	13.7	10.2	63.9	11,756
SaintVincentandtheGrenadines	13.6	8.6	72.4	11,746
Paraguay	12.7	8.4	74.1	11,720
Libya	12.8	7.6	72.7	11,685
SriLanka	14	11.1	76.8	11,611
SaintLucia	13.9	8.5	76.1	11,528
Indonesia	12.9	8	71.5	11,256
Lebanon	11.3	8.7	78.9	11,136
Mongolia	14.2	10.2	69.7	10,784
Egypt	13.1	7.3	71.8	10,744
Tunisia	15.1	7.2	76.5	10,677
Ecuador	14.9	9	76.8	10,141
Namibia	12.6	6.9	63.4	9,683
Georgia	15.4	12.8	73.6	9,570
Philippines	12.7	9.4	71.1	9,540
Eswatini	11.4	6.7	59.4	9,359
Armenia	13.2	11.8	74.9	9,277
Dominica	13	7.8	78.1	9,245
Fiji	14.4	10.9	67.3	9,110
Venezuela	12.8	10.3	72.1	9,070
Bhutan	12.1	3.1	71.5	8,609
Jordan	11.9	10.5	74.4	8,268
Ukraine	15.1	11.3	72	7,994
Jamaica	13.1	9.8	74.4	7,932
Cuba	14.4	11.8	78.7	7,811
Guyana	11.5	8.5	69.8	7,615
Timor-Leste	12.4	4.5	69.3	7,527
Morocco	13.1	5.5	76.5	7,480
Guatemala	10.6	6.5	74.1	7,378
Belize	13.1	9.8	74.5	7,136
ElSalvador	12	6.9	73.1	6,973
Bolivia	14	9	71.2	6,849
Moldova	11.6	11.6	71.8	6,833
India	12.3	6.5	69.4	6,829
CaboVerde	11.9	6.2	72.8	6,513
Uzbekistan	12	11.5	71.6	6,462
Lao	11.1	5.2	67.6	6,317
VietNam	12.7	8.2	75.3	6,220
Samoa	12.5	10.6	73.2	5,885
Congo	11.6	6.5	64.3	5,804
Tonga	14.3	11.2	70.8	5,783
Myanmar	10.3	5	66.9	5,764
Angola	11.8	5.1	60.8	5,555
Palestine,Stateof	12.8	9.1	73.9	5,314
Pakistan	8.5	5.2	67.1	5,190
Nigeria	9.7	6.5	54.3	5,086
Nicaragua	12.2	6.8	74.3	4,790
MarshallIslands	12.4	10.9	73.9	4,633
Honduras	10.2	6.6	75.1	4,258
Ghana	11.5	7.2	63.8	4,099
Bangladesh	11.2	6.1	72.3	4,057
Sudan	7.7	3.7	65.1	3,962
Kiribati	11.8	7.9	68.1	3,917
Mauritania	8.5	4.6	64.7	3,746
Micronesia	11.5	7.7	67.8	3,700
PapuaNewGuinea	10	4.6	64.3	3,686
Djibouti	6.5	4	66.6	3,601
Cambodia	11.3	4.8	69.6	3,597
Cted'Ivoire	9.6	5.2	57.4	3,589
Zambia	12.1	7.1	63.5	3,582
Tajikistan	11.4	10.7	70.9	3,482
Kyrgyzstan	13.4	10.9	71.3	3,317
Cameroon	12.7	6.3	58.9	3,291
Senegal	9	3.1	67.7	3,256
Lesotho	10.7	6.3	53.7	3,244
Kenya	11.1	6.6	66.3	3,052
SaoTomeandPrincipe	12.7	6.4	70.2	3,024
Vanuatu	11.4	6.8	70.3	2,808
Tanzania	8	6	65	2,805
Nepal	12.2	4.9	70.5	2,748
SyrianArabRepublic	8.8	5.1	71.8	2,725
Zimbabwe	10.5	8.3	61.2	2,661
Comoros	11.2	4.9	64.1	2,426
Guinea	9	2.7	61.2	2,211
Benin	12.6	3.8	61.5	2,135
SolomonIslands	10.2	5.5	72.8	2,027
Mali	7.6	2.4	58.9	1,965
Rwanda	11.2	4.4	68.7	1,959
Ethiopia	8.7	2.8	66.2	1,782
Uganda	11.2	6.1	63	1,752
Afghanistan	10.1	3.9	64.5	1,746
Chad	7.5	2.4	54	1,716
Eritrea	5	3.9	65.9	1,708
BurkinaFaso	8.9	1.6	61.2	1,705
Haiti	9.5	5.4	63.7	1,665
Guinea-Bissau	10.5	3.3	58	1,593
Togo	12.6	5	60.8	1,593
Gambia	9.5	3.7	61.7	1,490
SouthSudan	5	4.8	57.6	1,455
Yemen	8.7	3.2	66.1	1,433
Madagascar	10.4	6.1	66.7	1,404
SierraLeone	10.2	3.6	54.3	1,381
Malawi	11	4.6	63.8	1,159
Mozambique	9.7	3.5	60.2	1,154
Liberia	9.6	4.7	63.7	1,040
Niger	6.5	2	62	912
DemocraticRepublicoftheCongo	9.7	6.8	60.4	800
CentralAfricanRepublic	7.6	4.3	52.8	777
Burundi	11.3	3.1	61.2	660