Excel Data analysis

SampCountries

Country	LandArea	Population	Energy	Rural	Military	Health	HIV	Internet Access	Developed	BirthRate	ElderlyPop	LifeExpectancy	Government
(source: World Health Organization Statistics, 2015)	(km^2)	(million)	(millions of kg of oil equivalent)	(% of population)	(% of population)	(propability of dying during adult ages of 30-70)	(% of population infected)	(% of population)	(0-3=undeveloped, under-developed, developing, developed)	(annual number of births per 1,000 persons)	(% population over 65)	(years)	(type)
Slovenia	20,140	2.021	7,735	51.4	4.08	12.9%	0.1	57.5	3	10.80	16.027	78.77	Republic
Luxembourg	2,590	0.489	4,119	17.6	0.00	13.7%	0.3	80.9	3	11.50	14.037	80.09	Constitutional Monarchy
Belgium	30,280	10.708	58,583	2.6	2.75	14.8%	0.2	70.5	3	11.70	17.243	80.43	Constitutional Monarchy
Russian Federation	16,376,870	141.95	686,757	27.2	16.29	9.2%	1.0	32.0	3	12.10	13.295	67.85	Republic
Norway	305,470	4.768	29,670	22.5	4.22	16.7%	0.1	90.5	3	12.70	14.646	80.59	Constitutional Monarchy
United Kingdom	241,930	61.407	208,450	10.1	5.77	15.1%	0.2	78.2	3	12.90	16.302	79.60	Constitutional Monarchy
Australia	7,682,300	21.432	130,113	11.3	7.71	17.1%	0.1	70.8	3	13.80	13.415	81.40	Constitutional Monarchy
United Arab Emirates	83,600	4.485	58,439	22.1	0.00	8.9%	0.0	72.0	3	14.00	1.007	77.75	Absolute Monarchy
New Zealand	263,310	4.269	16,935	13.4	0.00	18.3%	0.1	71.4	3	15.15	12.543	80.35	Constitutional Monarchy
Kuwait	17,820	2.728	26,291	1.6	14.42	6.1%	0.0	36.7	3	17.71	2.087	77.97	Constitutional Monarchy
Israel	21,640	7.309	22,009	8.3	17.12	10.0%	0.2	47.9	3	21.50	10.042	81.00	Republic
Saudi Arabia	2,000,000	24.807	161,600	17.6	0.00	8.4%	0.0	31.3	3	23.42	2.869	73.12	Absolute Monarchy
Portugal	91,470	10.622	24,159	40.5	4.80	15.4%	0.5	44.4	2	9.80	17.501	78.52	Republic
Malta	320	0.412	819	5.7	1.51	12.3%	0.1	49.5	2	10.00	14.017	79.43	Republic
Lithuania	62,670	3.358	9,177	33.0	4.85	12.8%	0.1	54.6	2	10.40	15.968	71.81	Republic
Latvia	62,190	2.266	4,484	31.9	6.40	10.2%	0.6	63.2	2	10.60	17.186	72.42	Republic
Ukraine	579,320	46.258	136,143	32.0	7.16	8.6%	1.1	22.5	2	11.00	15.904	68.25	Republic
Chile	743,530	16.804	31,446	11.6	17.94	15.6%	0.4	32.5	2	14.94	8.755	78.61	Republic
Argentina	2,736,690	39.883	76,359	8.0	0.00	13.7%	0.5	28.1	2	17.27	10.511	75.33	Republic
Oman	309,500	2.785	16,443	28.4	0.00	4.9%	0.1	20.0	2	21.96	2.885	75.91	Absolute Monarchy
South Africa	1,214,470	48.793	134,489	39.3	4.34	10.4%	17.9	8.6	2	22.04	4.369	51.48	Republic
Libya	1,759,540	6.294	18,221	22.5	0.00	5.5%	0.0	5.1	2	23.30	4.130	74.33	NA
Bosnia and Herzegovina	51,200	3.773	5,990	52.6	3.37	14.0%	0.0	34.7	1	9.10	13.788	75.11	Republic
Moldova	32,890	3.633	3,150	58.2	1.86	13.0%	0.4	23.4	1	12.32	11.137	68.44	Republic
Armenia	28,480	3.077	2,997	36.1	16.06	7.2%	0.1	6.2	1	15.30	11.563	73.54	Republic
Costa Rica	51,060	4.519	4,897	36.7	0.00	26.1%	0.3	32.3	1	16.68	6.183	78.92	Republic
Azerbaijan	82,620	8.68	13,367	48.1	22.88	2.5%	0.1	28.2	1	17.80	6.768	70.18	Republic
Mexico	1,943,950	106.35	180,605	22.8	0.00	15.0%	0.3	21.9	1	18.33	6.225	75.07	Republic
Sri Lanka	62,710	20.156	8,935	84.9	18.54	7.9%	0.1	5.8	1	18.80	7.254	74.13	Republic
El Salvador	20,720	6.134	4,882	39.3	2.86	11.9%	0.8	10.6	1	20.24	7.040	71.26	Republic
Panama	74,340	3.399	2,899	26.8	0.00	13.5%	0.9	27.6	1	20.64	6.380	75.66	Republic
Peru	1,280,000	28.837	14,710	28.6	6.50	15.6%	0.4	24.7	1	21.11	5.731	73.26	Republic
Uzbekistan	425,400	27.314	50,501	63.2	0.00	8.6%	0.1	9.0	1	21.68	4.570	67.76	Republic
Turkmenistan	469,930	5.044	18,814	51.4	0.00	7.0%	0.0	1.5	1	21.93	4.310	64.82	Republic
Philippines	298,170	90.348	41,067	35.1	4.90	6.1%	0.1	6.2	1	24.73	4.115	71.83	Republic
Bolivia	1,083,300	9.694	5,694	34.4	0.00	8.2%	0.2	10.8	1	27.10	4.664	65.68	Republic
Namibia	823,290	2.13	1,752	63.2	0.00	12.1%	13.7	5.3	1	27.56	3.592	61.01	Republic
Ethiopia	1,000,000	80.713	31,704	83.0	0.00	11.5%	0.0	0.4	1	38.23	3.148	55.20	Republic
Kenya	569,140	38.765	18,021	78.4	8.90	5.8%	6.3	8.7	1	38.77	2.658	54.24	Republic
Fiji	18,270	0.844	- 0	47.6	0.00	10.2%	0.1	12.2	0	20.95	4.626	68.87	Republic
Samoa	2,830	0.179	- 0	77.0	0.00	14.9%	0.0	5.0	0	23.51	4.805	71.75	Republic
Djibouti	23,180	0.849	- 0	12.7	0.00	15.3%	2.6	2.3	0	28.44	3.166	55.39	Republic
Lesotho	30,360	2.049	- 0	74.5	3.14	8.2%	23.6	3.6	0	28.94	4.750	44.99	Constitutional Monarchy
Vanuatu	12,190	0.234	- 0	75.2	0.00	13.5%	0.0	7.3	0	30.20	3.280	70.29	Republic
Solomon Islands	27,990	0.511	- 0	82.0	0.00	14.4%	0.0	2.0	0	30.45	3.065	66.26	Constitutional Monarchy
Central African Republic	622,980	4.339	- 0	61.4	0.00	11.0%	5.1	0.4	0	35.42	3.880	46.96	Republic
Gambia, The	10,000	1.66	- 0	43.6	0.00	11.6%	1.7	6.9	0	36.76	2.818	55.93	Republic
Guinea	245,720	9.833	- 0	65.6	0.00	4.3%	1.4	0.9	0	39.63	3.205	57.82	Republic
Uganda	197,100	31.657	- 0	87.0	17.04	10.5%	6.4	7.9	0	46.15	2.562	52.67	Republic
Niger	1,266,700	14.704	- 0	83.5	0.00	14.8%	0.8	0.5	0	53.54	1.979	51.40	Republic

QA_HIV

Country	Population	HIV	Total Infected Population
Ukraine	46,258,000	1.1%	508,838
Guinea	9,833,000	1.4%	137,662
Gambia, The	1,066,000	1.7%	18,122
Djibouti	849,000	2.6%	22,074
Central African Republic	4,339,000	5.1%	221,289
Kenya	38,765,000	6.3%	2,442,195
Uganda	31,657,000	6.4%	2,026,048
Namibia	2,130,000	13.7%	291,810
South Africa	48,793,000	17.9%	8,733,947
Lesotho	2,049,000	23.6%	483,564
TOTAL	185,739,000	8.0%	14,885,549
Africa	139,481,000	10.3%	14,376,711
Difference Between Africa and Ukraine	75.1%		96.6%

QA_HIV

QB_Healthiest Countries

Country	Population	Health	HIV	Rural	Population in Rural Area
Costa Rica	4,519,000	26.1%	0.300%	36.7%	1,660,281
New Zealand	4,269,000	18.3%	0.100%	13.4%	573,754
Australia	21,432,000	17.1%	0.100%	11.3%	2,413,243
Norway	4,768,000	16.7%	0.100%	22.5%	1,073,754
Peru	28,837,000	15.6%	0.400%	28.6%	8,247,382
Chile	16,804,000	15.6%	0.400%	11.6%	1,942,542
Portugal	10,622,000	15.4%	0.500%	40.5%	4,306,159
Djibouti	849,000	15.3%	2.600%	12.7%	107,823
United Kingdom	61,407,000	15.1%	0.200%	10.1%	6,177,544
Mexico	106,350,000	15.0%	0.300%	22.8%	24,247,800
		(propability of dying during adult ages of 30-70)	(% of population infected)	(% of population)
		Data
Population	Country	Sum of Health	Sum of HIV	Sum of Rural
849,000	Djibouti	15.3%	2.600%	12.7%
4,269,000	New Zealand	18.3%	0.100%	13.4%
4,519,000	Costa Rica	26.1%	0.300%	36.7%
4,768,000	Norway	16.7%	0.100%	22.5%
10,622,000	Portugal	15.4%	0.500%	40.5%
16,804,000	Chile	15.6%	0.400%	11.6%
21,432,000	Australia	17.1%	0.100%	11.3%
28,837,000	Peru	15.6%	0.400%	28.6%
61,407,000	United Kingdom	15.1%	0.200%	10.1%
106,350,000	Mexico	15.0%	0.300%	22.8%
總計		170.2%	5.000%	210.2%

QB_Healthiest Countries

Djibouti 849,000	Djibouti 849,000	Djibouti 849,000
New Zealand 4,269,000	New Zealand 4,269,000	New Zealand 4,269,000
Costa Rica 4,519,000	Costa Rica 4,519,000	Costa Rica 4,519,000
Norway 4,768,000	Norway 4,768,000	Norway 4,768,000
Portugal 10,622,000	Portugal 10,622,000	Portugal 10,622,000
Chile 16,804,000	Chile 16,804,000	Chile 16,804,000
Australia 21,432,000	Australia 21,432,000	Australia 21,432,000
Peru 28,837,000	Peru 28,837,000	Peru 28,837,000
United Kingdom 61,407,000	United Kingdom 61,407,000	United Kingdom 61,407,000
Mexico 106,350,000	Mexico 106,350,000	Mexico 106,350,000
總計	總計	總計

QC_Life Expectancy

Country	Population	Health	ElderlyPop	LifeExpectancy
Australia	21,432,000	17.1%	13.41%	81.40
Israel	7,309,000	10.0%	10.04%	81.00
Norway	4,768,000	16.7%	14.65%	80.59
Belgium	10,708,000	14.8%	17.24%	80.43
New Zealand	4,269,000	18.3%	12.54%	80.35
Luxembourg	489,000	13.7%	14.04%	80.09
United Kingdom	61,407,000	15.1%	16.30%	79.60
Malta	412,000	12.3%	14.02%	79.43
Costa Rica	4,519,000	26.1%	6.18%	78.92
Slovenia	2,021,000	12.9%	16.03%	78.77
		(propability of dying during adult ages of 30-70)	(% population over 65)	(years)
		Data
Country	Population	Sum of LifeExpectancy	Sum of Health	Sum of ElderlyPop
Australia	21,432,000	81.40	17.10%	13.41%
Belgium	10,708,000	80.43	14.84%	17.24%
Costa Rica	4,519,000	78.92	26.09%	6.18%
Israel	7,309,000	81.00	10.02%	10.04%
Luxembourg	489,000	80.09	13.72%	14.04%
Malta	412,000	79.43	12.28%	14.02%
New Zealand	4,269,000	80.35	18.33%	12.54%
Norway	4,768,000	80.59	16.68%	14.65%
Slovenia	2,021,000	78.77	12.91%	16.03%
United Kingdom	61,407,000	79.60	15.12%	16.30%
Total		800.57	157.09%	134.45%

QC_Life Expectancy

21,432,000 Australia	21,432,000 Australia	21,432,000 Australia
10,708,000 Belgium	10,708,000 Belgium	10,708,000 Belgium
4,519,000 Costa Rica	4,519,000 Costa Rica	4,519,000 Costa Rica
7,309,000 Israel	7,309,000 Israel	7,309,000 Israel
489,000 Luxembourg	489,000 Luxembourg	489,000 Luxembourg
412,000 Malta	412,000 Malta	412,000 Malta
4,269,000 New Zealand	4,269,000 New Zealand	4,269,000 New Zealand
4,768,000 Norway	4,768,000 Norway	4,768,000 Norway
2,021,000 Slovenia	2,021,000 Slovenia	2,021,000 Slovenia
61,407,000 United Kingdom	61,407,000 United Kingdom	61,407,000 United Kingdom
Total	Total	Total

QD_Birth Rate

Country	Population	BirthRate	Developed
Niger	14,704,000	53.54	0
Uganda	31,657,000	46.15	0
Guinea	9,833,000	39.63	0
Kenya	38,765,000	38.77	1
Ethiopia	80,713,000	38.23	1
Bosnia and Herzegovina	3,773,000	9.10	1
Portugal	10,622,000	9.80	2
Malta	412,000	10.00	2
Lithuania	3,358,000	10.40	2
Latvia	2,266,000	10.60	2
		(annual number of births per 1,000 persons)	(0-3=undeveloped, under-developed, developing, developed)
Sum of BirthRate	Developing Status
Country	0	1	2	Total
Bosnia and Herzegovina
3,773,000		9.097		9.097
Ethiopia
80713000		38.23		38.23
Guinea
9833000	39.633			39.633
Kenya
38765000		38.767		38.767
Latvia
2266000			10.6	10.6
Lithuania
3358000			10.4	10.4
Malta
412000			10	10
Niger
14704000	53.536			53.536
Portugal
10622000			9.8	9.8
Uganda
31657000	46.151			46.151
Total	139.32	86.094	40.8	266.214

QD_Birth Rate

Bosnia and Herzegovina	Bosnia and Herzegovina	Bosnia and Herzegovina
3,773,000	3,773,000	3,773,000
Ethiopia	Ethiopia	Ethiopia
80713000	80713000	80713000
Guinea	Guinea	Guinea
9833000	9833000	9833000
Kenya	Kenya	Kenya
38765000	38765000	38765000
Latvia	Latvia	Latvia
2266000	2266000	2266000
Lithuania	Lithuania	Lithuania
3358000	3358000	3358000
Malta	Malta	Malta
412000	412000	412000
Niger	Niger	Niger
14704000	14704000	14704000
Portugal	Portugal	Portugal
10622000	10622000	10622000
Uganda	Uganda	Uganda
31657000	31657000	31657000
Total	Total	Total