How to do survival analysis in excel with this data Life expectancy of females in years...

60.1K

Verified Solution

Question

Statistics

How to do survival analysis in excel with this data

Life expectancy of females in years from 2005 to 2015

Country2005, LE-F(years)2015, LE-F(years)
Afghanistan58.163.5
Albania77.879.9
Algeria72.976.5
Angola52.563
Antigua and Barbuda76.478.2
Argentina78.179.8
Armenia75.377
Aruba76.477.8
Australia82.884.4
Austria81.783.5
Azerbaijan70.374.6
Bahamas76.278.1
Bahrain75.977.5
Bangladesh67.372.9
Barbados7677.7
Belarus73.777.7
Belgium81.483
Belize71.672.7
Benin57.761.4
Bhutan63.168.9
Bolivia (Plurin. State of)64.370.2
Bosnia and Herzegovina77.578.8
Botswana5166.1
Brazil7578.4
Brunei Darussalam77.578.4
Bulgaria75.877.8
Burkina Faso52.659.3
Burundi53.758
Cabo Verde72.874
Cambodia6369.6
Cameroon52.357.7
Canada82.183.8
Central African Republic44.951
Chad48.552.8
Channel Islands80.582.4
Chile80.381.3
China74.777.2
China, Hong Kong SAR84.586.4
China, Macao SAR83.686.2
Colombia75.477.4
Comoros61.264.5
Congo53.164.1
Costa Rica80.281.7
Côte d'Ivoire47.653.2
Croatia78.480.4
Cuba79.181.3
Curaçao78.680.7
Cyprus80.582.2
Czechia78.881.2
Dem. People's Rep. Korea71.574.1
Dem. Rep. of the Congo53.359.5
Denmark79.682.2
Djibouti58.863.2
Dominican Republic74.476.5
Ecuador76.878.4
Egypt71.473.1
El Salvador74.177.1
Equatorial Guinea54.958.4
Eritrea58.865.6
Estonia77.181.2
Ethiopia5565.5
Fiji70.772.9
Finland81.783.7
France83.185
French Guiana80.182.6
French Polynesia76.178.6
Gabon59.865.8
Gambia58.161.6
Georgia76.177
Germany81.582.9
Ghana58.362.6
Greece81.983.3
Grenada73.275.6
Guadeloupe81.484
Guam78.581.5
Guatemala72.175.6
Guinea51.358.4
Guinea-Bissau53.357.7
Guyana68.168.6
Haiti60.164.4
Honduras73.475.4
Hungary76.778.9
Iceland82.683.8
India64.469.1
Indonesia68.570.7
Iran (Islamic Republic of)72.376.2
Iraq7171.4
Ireland80.483
Israel81.683.7
Italy83.184.7
Jamaica75.677.9
Japan85.286.4
Jordan73.875.5
Kazakhstan70.473.9
Kenya54.567.8
Kiribati67.568.9
Kuwait74.475.5
Kyrgyzstan7174.3
Lao People's Dem. Rep.61.766.8
Latvia76.278.7
Lebanon77.480.9
Lesotho46.454.7
Liberia53.261.6
Libya72.874.4
Lithuania77.579.3
Luxembourg81.483.5
Madagascar61.366
Malawi48.963.1
Malaysia75.477.1
Maldives73.977.4
Mali50.656.9
Malta80.282
Martinique82.284.4
Mauritania61.964.1
Mauritius75.577.7
Mayotte80.682.9
Mexico77.478.9
Micronesia (Fed. States of)68.269.9
Mongolia67.772.7
Montenegro76.278.8
Morocco71.476
Mozambique51.258.1
Myanmar6568.3
Namibia55.964.3
Nepal65.270.5
Netherlands8183.1
New Caledonia77.279.3
New Zealand81.383.1
Nicaragua73.877.5
Niger5259.5
Nigeria47.852.6
Norway81.883.6
Oman75.578.7
Pakistan64.366.8
Palau72.177.8
Panama78.280.5
Papua New Guinea65.167.5
Paraguay72.974.9
Peru74.376.8
Philippines70.872.1
Poland78.881
Portugal8183.5
Puerto Rico80.983.2
Qatar78.179.4
Republic of Korea80.684.4
Republic of Moldova71.675.2
Réunion80.682.9
Romania75.278.4
Russian Federation7275.9
Rwanda51.567.1
Saint Lucia7477.6
Saint Vincent & Grenadines73.374.9
Samoa73.677.4
Sao Tome and Principe65.668.2
Saudi Arabia74.675.6
Senegal60.667.5
Serbia75.477.5
Seychelles76.877.9
Sierra Leone42.650.7
Singapore81.884.5
Slovakia77.879.8
Slovenia80.483.3
Solomon Islands6671.1
Somalia53.156.5
South Africa56.763
South Sudan51.356
Spain83.385.3
Sri Lanka77.178
State of Palestine72.974.8
Sudan61.365.1
Suriname71.774.2
Swaziland47.658.2
Sweden82.383.7
Switzerland83.184.8
Syrian Arab Republic75.976.3
Tajikistan69.673.5
TFYR of Macedonia76.477.2
Thailand74.978.4
Timor-Leste6369.5
Togo54.759.8
Tonga73.575.6
Trinidad and Tobago72.573.8
Tunisia76.377.1
Turkey74.978.1
Turkmenistan68.270.8
Uganda52.160.7
Ukraine73.476
United Arab Emirates76.378.2
United Kingdom80.682.8
United Rep. of Tanzania55.464.8
United States of America79.781.3
United States Virgin Islands79.581.5
Uruguay78.980.4
Uzbekistan7173.5
Vanuatu70.373.6
Venezuela (Boliv. Rep. of)77.278.2
Viet Nam78.780.3
Western Sahara65.870.3
Yemen62.465.6
Zambia48.561.9
Zimbabwe45.559

Answer & Explanation Solved by verified expert
4.2 Ratings (610 Votes)
The mean std deviation and no of sample data points for 2005and 2015 females survival data given are as follows20052015Mean70258717380846Std    See Answer
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students