Question

How to do survival analysis in excel with this data

Life expectancy of females in years from 2005 to 2015

Country	2005, LE-F(years)	2015, LE-F(years)
Afghanistan	58.1	63.5
Albania	77.8	79.9
Algeria	72.9	76.5
Angola	52.5	63
Antigua and Barbuda	76.4	78.2
Argentina	78.1	79.8
Armenia	75.3	77
Aruba	76.4	77.8
Australia	82.8	84.4
Austria	81.7	83.5
Azerbaijan	70.3	74.6
Bahamas	76.2	78.1
Bahrain	75.9	77.5
Bangladesh	67.3	72.9
Barbados	76	77.7
Belarus	73.7	77.7
Belgium	81.4	83
Belize	71.6	72.7
Benin	57.7	61.4
Bhutan	63.1	68.9
Bolivia (Plurin. State of)	64.3	70.2
Bosnia and Herzegovina	77.5	78.8
Botswana	51	66.1
Brazil	75	78.4
Brunei Darussalam	77.5	78.4
Bulgaria	75.8	77.8
Burkina Faso	52.6	59.3
Burundi	53.7	58
Cabo Verde	72.8	74
Cambodia	63	69.6
Cameroon	52.3	57.7
Canada	82.1	83.8
Central African Republic	44.9	51
Chad	48.5	52.8
Channel Islands	80.5	82.4
Chile	80.3	81.3
China	74.7	77.2
China, Hong Kong SAR	84.5	86.4
China, Macao SAR	83.6	86.2
Colombia	75.4	77.4
Comoros	61.2	64.5
Congo	53.1	64.1
Costa Rica	80.2	81.7
Côte d'Ivoire	47.6	53.2
Croatia	78.4	80.4
Cuba	79.1	81.3
Curaçao	78.6	80.7
Cyprus	80.5	82.2
Czechia	78.8	81.2
Dem. People's Rep. Korea	71.5	74.1
Dem. Rep. of the Congo	53.3	59.5
Denmark	79.6	82.2
Djibouti	58.8	63.2
Dominican Republic	74.4	76.5
Ecuador	76.8	78.4
Egypt	71.4	73.1
El Salvador	74.1	77.1
Equatorial Guinea	54.9	58.4
Eritrea	58.8	65.6
Estonia	77.1	81.2
Ethiopia	55	65.5
Fiji	70.7	72.9
Finland	81.7	83.7
France	83.1	85
French Guiana	80.1	82.6
French Polynesia	76.1	78.6
Gabon	59.8	65.8
Gambia	58.1	61.6
Georgia	76.1	77
Germany	81.5	82.9
Ghana	58.3	62.6
Greece	81.9	83.3
Grenada	73.2	75.6
Guadeloupe	81.4	84
Guam	78.5	81.5
Guatemala	72.1	75.6
Guinea	51.3	58.4
Guinea-Bissau	53.3	57.7
Guyana	68.1	68.6
Haiti	60.1	64.4
Honduras	73.4	75.4
Hungary	76.7	78.9
Iceland	82.6	83.8
India	64.4	69.1
Indonesia	68.5	70.7
Iran (Islamic Republic of)	72.3	76.2
Iraq	71	71.4
Ireland	80.4	83
Israel	81.6	83.7
Italy	83.1	84.7
Jamaica	75.6	77.9
Japan	85.2	86.4
Jordan	73.8	75.5
Kazakhstan	70.4	73.9
Kenya	54.5	67.8
Kiribati	67.5	68.9
Kuwait	74.4	75.5
Kyrgyzstan	71	74.3
Lao People's Dem. Rep.	61.7	66.8
Latvia	76.2	78.7
Lebanon	77.4	80.9
Lesotho	46.4	54.7
Liberia	53.2	61.6
Libya	72.8	74.4
Lithuania	77.5	79.3
Luxembourg	81.4	83.5
Madagascar	61.3	66
Malawi	48.9	63.1
Malaysia	75.4	77.1
Maldives	73.9	77.4
Mali	50.6	56.9
Malta	80.2	82
Martinique	82.2	84.4
Mauritania	61.9	64.1
Mauritius	75.5	77.7
Mayotte	80.6	82.9
Mexico	77.4	78.9
Micronesia (Fed. States of)	68.2	69.9
Mongolia	67.7	72.7
Montenegro	76.2	78.8
Morocco	71.4	76
Mozambique	51.2	58.1
Myanmar	65	68.3
Namibia	55.9	64.3
Nepal	65.2	70.5
Netherlands	81	83.1
New Caledonia	77.2	79.3
New Zealand	81.3	83.1
Nicaragua	73.8	77.5
Niger	52	59.5
Nigeria	47.8	52.6
Norway	81.8	83.6
Oman	75.5	78.7
Pakistan	64.3	66.8
Palau	72.1	77.8
Panama	78.2	80.5
Papua New Guinea	65.1	67.5
Paraguay	72.9	74.9
Peru	74.3	76.8
Philippines	70.8	72.1
Poland	78.8	81
Portugal	81	83.5
Puerto Rico	80.9	83.2
Qatar	78.1	79.4
Republic of Korea	80.6	84.4
Republic of Moldova	71.6	75.2
Réunion	80.6	82.9
Romania	75.2	78.4
Russian Federation	72	75.9
Rwanda	51.5	67.1
Saint Lucia	74	77.6
Saint Vincent & Grenadines	73.3	74.9
Samoa	73.6	77.4
Sao Tome and Principe	65.6	68.2
Saudi Arabia	74.6	75.6
Senegal	60.6	67.5
Serbia	75.4	77.5
Seychelles	76.8	77.9
Sierra Leone	42.6	50.7
Singapore	81.8	84.5
Slovakia	77.8	79.8
Slovenia	80.4	83.3
Solomon Islands	66	71.1
Somalia	53.1	56.5
South Africa	56.7	63
South Sudan	51.3	56
Spain	83.3	85.3
Sri Lanka	77.1	78
State of Palestine	72.9	74.8
Sudan	61.3	65.1
Suriname	71.7	74.2
Swaziland	47.6	58.2
Sweden	82.3	83.7
Switzerland	83.1	84.8
Syrian Arab Republic	75.9	76.3
Tajikistan	69.6	73.5
TFYR of Macedonia	76.4	77.2
Thailand	74.9	78.4
Timor-Leste	63	69.5
Togo	54.7	59.8
Tonga	73.5	75.6
Trinidad and Tobago	72.5	73.8
Tunisia	76.3	77.1
Turkey	74.9	78.1
Turkmenistan	68.2	70.8
Uganda	52.1	60.7
Ukraine	73.4	76
United Arab Emirates	76.3	78.2
United Kingdom	80.6	82.8
United Rep. of Tanzania	55.4	64.8
United States of America	79.7	81.3
United States Virgin Islands	79.5	81.5
Uruguay	78.9	80.4
Uzbekistan	71	73.5
Vanuatu	70.3	73.6
Venezuela (Boliv. Rep. of)	77.2	78.2
Viet Nam	78.7	80.3
Western Sahara	65.8	70.3
Yemen	62.4	65.6
Zambia	48.5	61.9
Zimbabwe	45.5	59

Answer 1

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

	2005	2015
Mean	70.25871	73.80846
Std dev	10.5955	8.616187
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)]

= - 3.684

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 for females indeed seem to have statistically increased from 2005->2015.