Question

How to do survival analysis in excel with this data

Life expectancy of males in years from 2005 to 2015

Country	2005, LE-M (years)	2015, LE-M (years)
Afghanistan	55.8	61.1
Albania	72.3	75.6
Algeria	70.1	74.1
Angola	47.5	57.4
Antigua and Barbuda	71.5	73.3
Argentina	70.6	72.2
Armenia	69.1	70.6
Aruba	71.5	72.9
Australia	77.8	80.2
Austria	75.9	78.4
Azerbaijan	64.6	68.6
Bahamas	70	72
Bahrain	74.2	75.6
Bangladesh	66.2	69.8
Barbados	71.4	72.9
Belarus	62.3	66.5
Belgium	75.3	78
Belize	65.7	67.2
Benin	54.6	58.5
Bhutan	62.7	68.6
Bolivia (Plurin. State of)	60.1	65.3
Bosnia and Herzegovina	72	73.7
Botswana	47.3	59.8
Brazil	67.3	71
Brunei Darussalam	74.2	75.1
Bulgaria	68.8	70.8
Burkina Faso	50.5	58
Burundi	50.3	54.2
Cabo Verde	69.5	70.1
Cambodia	58.5	65.5
Cameroon	50.6	55.1
Canada	77.2	79.7
Central African Republic	42.5	47.8
Chad	46.8	50.5
Channel Islands	76	78.7
Chile	74.3	76.2
China	71.7	74.2
China, Hong Kong SAR	78.5	80.5
China, Macao SAR	78.2	80.3
Colombia	68	70.2
Comoros	58	61.2
Congo	51.1	61
Costa Rica	75.5	76.7
Côte d'Ivoire	45.9	50.4
Croatia	71.4	73.6
Cuba	75.3	77.1
Curaçao	71.2	74.5
Cyprus	76.3	77.7
Czechia	72.2	75.1
Dem. People's Rep. Korea	64.2	67.2
Dem. Rep. of the Congo	50.4	56.7
Denmark	75	78.1
Djibouti	55.9	60
Dominican Republic	68.1	70.2
Ecuador	70.7	72.8
Egypt	66.7	68.7
El Salvador	65	67.9
Equatorial Guinea	52.3	55.5
Eritrea	54.7	61.4
Estonia	66	71.9
Ethiopia	52.3	61.9
Fiji	65.5	66.9
Finland	74.9	77.7
France	75.8	78.8
French Guiana	72.8	76.1
French Polynesia	70.7	74
Gabon	58.3	63.1
Gambia	55.9	59.1
Georgia	68.9	68.5
Germany	75.6	77.9
Ghana	56.7	60.7
Greece	76.4	78
Grenada	68.5	70.8
Guadeloupe	74.3	76.8
Guam	73.6	76.4
Guatemala	65.7	69.2
Guinea	51.3	57.5
Guinea-Bissau	52	54.3
Guyana	62.6	64
Haiti	56.5	60.2
Honduras	68.6	70.4
Hungary	68.3	71.7
Iceland	78.8	80.6
India	62.7	66.2
Indonesia	64.9	66.6
Iran (Islamic Republic of)	70	74
Iraq	66.9	67
Ireland	75.3	78.7
Israel	77.4	80
Italy	77.3	79.9
Jamaica	70.1	73.1
Japan	78.3	80
Jordan	70.8	72.2
Kazakhstan	59.1	64.3
Kenya	51	63
Kiribati	61.6	62.4
Kuwait	72.6	73.5
Kyrgyzstan	63	66.4
Lao People's Dem. Rep.	59	63.9
Latvia	65.2	68.8
Lebanon	73.9	77.3
Lesotho	44.7	50.1
Liberia	51.6	59.8
Libya	69.1	68.8
Lithuania	65.7	68.5
Luxembourg	75.1	78.8
Madagascar	58.8	63
Malawi	45.7	58.2
Malaysia	71.2	72.6
Maldives	71.1	75.4
Mali	49.3	55.6
Malta	76.8	78.6
Martinique	75.5	77.8
Mauritania	58.6	61.2
Mauritius	68.9	70.7
Mayotte	73	76
Mexico	72.4	74
Micronesia (Fed. States of)	66.9	67.7
Mongolia	60.8	64.5
Montenegro	70.6	74
Morocco	68.5	73.7
Mozambique	47.9	54
Myanmar	60.9	63.7
Namibia	51.7	59.1
Nepal	62.9	67.4
Netherlands	76.2	79.4
New Caledonia	71.3	73.7
New Zealand	76.8	79.5
Nicaragua	68	71.4
Niger	50.8	57.6
Nigeria	46.1	51.2
Norway	76.8	79.5
Oman	71.4	74.5
Pakistan	62.5	65
Palau	66.3	68.1
Panama	73	74.3
Papua New Guinea	60.3	62.6
Paraguay	68.7	70.7
Peru	69	71.5
Philippines	64.4	65.4
Poland	70.4	72.9
Portugal	74.1	77.3
Puerto Rico	72.7	75.2
Qatar	75.6	76.9
Republic of Korea	73.6	77.9
Republic of Moldova	63.6	66.7
Réunion	73	76
Romania	67.9	71.4
Russian Federation	58.6	64.7
Rwanda	49.6	63.1
Saint Lucia	70.1	72.2
Saint Vincent & Grenadines	68.3	70.7
Samoa	67.2	71.1
Sao Tome and Principe	62	64.1
Saudi Arabia	71.5	72.7
Senegal	57.3	63.8
Serbia	69.4	71.8
Seychelles	67.9	68.7
Sierra Leone	40.1	49.7
Singapore	76.7	80.1
Slovakia	69.8	72.7
Slovenia	72.8	77.3
Solomon Islands	63.5	68.3
Somalia	50	53.3
South Africa	51.2	56.1
South Sudan	49.1	54.1
Spain	76.5	79.6
Sri Lanka	69.6	71.2
State of Palestine	69.5	71.1
Sudan	57.5	62.1
Suriname	64.8	67.8
Swaziland	44.2	51.6
Sweden	77.9	80
Switzerland	77.7	80.5
Syrian Arab Republic	71.4	64.4
Tajikistan	63.6	67.7
TFYR of Macedonia	71.3	73.2
Thailand	67.7	70.8
Timor-Leste	60	66.1
Togo	53	58.3
Tonga	68.8	69.6
Trinidad and Tobago	65.1	66.9
Tunisia	71.4	73
Turkey	68	71.5
Turkmenistan	60.3	63.9
Uganda	47.8	56.5
Ukraine	61.9	66.1
United Arab Emirates	74.1	76
United Kingdom	76.1	79
United Rep. of Tanzania	52	60.8
United States of America	74.5	76.5
United States Virgin Islands	74.9	76.7
Uruguay	71.6	73.3
Uzbekistan	64.5	68.1
Vanuatu	66.7	69.4
Venezuela (Boliv. Rep. of)	68.8	69.9
Viet Nam	68.9	70.7
Western Sahara	62.3	66.9
Yemen	59.7	62.8
Zambia	45.3	57.5
Zimbabwe	42.7	56.1

Answer 1

The mean, std deviation and no. of sample data points for 2005 and 2015 survival data given, are as follows:

	2005	2015
Mean	65.35224	68.86468
Std dev	9.453434	7.873728
n	201	201

Looking at the mean survival years for 2005 and 2015, we see that the mean survival rate seems to have increase from 2005->2015. As we do not know the population std deviations, let's do 2 sample paired (right tailed) T-test to test the hypotheses:

H0: μ1 - μ2 <= 0

Ha: μ1 - μ2 > 0

where μ1 is the mean population survival rate for 2005 and μ2 is the mean population survival rate for 2015.

Now, assuming we do the test at 5% significance level,

T-statistic, t = [ ( - ) - d ] / sqrt[(s1^2/n1) + (s2^2/n2)]

= -4.048

Now, right-tailed critical T-score at alpha = 0.05 and df = 201+201-2 = 400,

T-critical, T_{0.05, 400} = -1.649

Since | t | > | T-critical |, we reject the null hypothesis at the 5% significance level. Hence, the mean survival years indeed seem to have statistically increased from 2005->2015.