In this assignment we want to analyze the mortality rate of different regions in the world. Specifically, we will use the data file Mortality2005.xlsx to answer the following questions:

What are the average mortality rate of the 6 regions in the world for men and for women? Note that you could compute the average for each region, or a 95% confidence interval for the mean for each region. Decide which one would be more appropriate and explain your choice. Note that you could use Excel for this (makean appropriate Pivot table for men and another for women), but since you need to group your answers by World Health Organization (WHO) region, it will be easier to use StatCrunch. Recall that to compute a 95% confidence interval in StatCrunch, you select "Stat | Z Stat | 1 sample | With data", then pick the variables to analyze, set the grouping variable, if necessary, and choose the radio button to perform a "Confidence Interval for the mean". Provide your answer(s) in an easy-to-read format such as a table with min and max value for each confidence interval (if you decide on using confidence intervals) or the average for each region (if you decide on using the actual averages). Provide two sets of answers, one for men, the other for women. How would you go about combining the answers, i.e. show the average for each population, regardless of men or women? Could you even do this with the information provided?

Compare the different answers. Which region has the highest, which the lowest life expectancy? What about men versus women's life expectancy? Try to explain the regional differences in a few speculative sentences.

including an introduction to the data set. Write one to two pages, no more (and no less ).

Country	WHO	Life Exp (male)	Life exp (female)			Region
Afghanistan	EMR	41	42			African Region	AFR
Albania	EUR	69	75			Region of the Americas	AMR
Algeria	AFR	69	72			South-East Asia Region	SEAR
Andorra	EUR	78	84			European Region	EUR
Angola	AFR	38	42			Eastern Mediterranean Region	EMR
Antigua and Barbuda	AMR	70	75			Western Pacific Region	WPR
Argentina	AMR	71	78
Armenia	EUR	65	72
Australia	WPR	78	83
Austria	EUR	76	82
Azerbaijan	EUR	62	68
Bahamas	AMR	69	75
Bahrain	EMR	73	75
Bangladesh	SEAR	63	63
Barbados	AMR	71	78
Belarus	EUR	63	75
Belgium	EUR	75	82
Belize	AMR	65	71
Benin	AFR	52	54
Bhutan	SEAR	61	64
Bolivia	AMR	63	67
Bosnia and Herzegovina	EUR	69	76
Botswana	AFR	37	36
Brazil	AMR	66	73
Brunei Darussalam	WPR	75	79
Bulgaria	EUR	69	76
Burkina Faso	AFR	44	46
Burundi	AFR	40	45
Cambodia	WPR	50	57
Cameroon	AFR	47	48
Canada	AMR	78	82
Cape Verde	AFR	67	73
Central African Republic	AFR	42	43
Chad	AFR	44	47
Chile	AMR	74	80
China	WPR	70	73
Colombia	AMR	68	77
Comoros	AFR	62	66
Congo	AFR	53	55
Cook Islands	WPR	68	74
Costa Rica	AMR	75	80
Cte d'Ivoire	AFR	42	49
Croatia	EUR	71	78
Cuba	AMR	75	79
Cyprus	EUR	76	81
Czech Republic	EUR	72	79
Democratic People's Republic of Korea	SEAR	65	68
Democratic Republic of the Congo	AFR	42	47
Denmark	EUR	75	80
Djibouti	EMR	53	56
Dominica	AMR	71	76
Dominican Republic	AMR	65	72
Ecuador	AMR	68	74
Egypt	EMR	65	69
El Salvador	AMR	67	73
Equatorial Guinea	AFR	50	52
Eritrea	AFR	58	61
Estonia	EUR	65	77
Ethiopia	AFR	49	51
Fiji	WPR	66	71
Finland	EUR	75	82
France	EUR	76	84
Gabon	AFR	55	60
Gambia	AFR	56	59
Georgia	EUR	67	75
Germany	EUR	76	82
Ghana	AFR	57	60
Greece	EUR	76	81
Grenada	AMR	66	69
Guatemala	AMR	64	69
Guinea	AFR	51	53
Guinea-Bissau	AFR	45	48
Guyana	AMR	61	64
Haiti	AMR	52	54
Honduras	AMR	65	69
Hungary	EUR	68	77
Iceland	EUR	78	82
India	SEAR	60	63
Indonesia	SEAR	65	68
Iran (Islamic Republic of)	EMR	67	72
Iraq	EMR	50	61
Ireland	EUR	76	81
Israel	EUR	78	82
Italy	EUR	78	84
Jamaica	AMR	71	74
Japan	WPR	78	85
Jordan	EMR	69	73
Kazakhstan	EUR	56	67
Kenya	AFR	50	49
Kiribati	WPR	62	67
Kuwait	EMR	76	79
Kyrgyzstan	EUR	59	68
Lao People's Democratic Republic	WPR	58	60
Latvia	EUR	66	76
Lebanon	EMR	68	72
Lesotho	AFR	35	40
Liberia	AFR	40	43
Libyan Arab Jamahiriya	EMR	71	76
Lithuania	EUR	66	78
Luxembourg	EUR	76	82
Madagascar	AFR	55	59
Malawi	AFR	41	42
Malaysia	WPR	70	75
Maldives	SEAR	66	64
Mali	AFR	44	46
Malta	EUR	76	81
Marshall Islands	WPR	60	63
Mauritania	AFR	48	53
Mauritius	AFR	69	76
Mexico	AMR	72	77
Micronesia (Federated States of)	WPR	68	71
Monaco	EUR	78	85
Mongolia	WPR	62	69
Morocco	EMR	69	73
Mozambique	AFR	44	46
Myanmar	SEAR	56	63
Namibia	AFR	50	53
Nauru	WPR	58	65
Nepal	SEAR	60	61
Netherlands	EUR	76	81
New Zealand	WPR	77	82
Nicaragua	AMR	68	73
Niger	AFR	42	41
Nigeria	AFR	45	46
Niue	WPR	68	74
Norway	EUR	77	82
Oman	EMR	71	77
Pakistan	EMR	62	62
Palau	WPR	66	70
Panama	AMR	73	78
Papua New Guinea	WPR	59	62
Paraguay	AMR	69	75
Peru	AMR	68	73
Philippines	WPR	65	71
Poland	EUR	71	79
Portugal	EUR	74	81
Qatar	EMR	75	74
Republic of Korea	WPR	73	80
Republic of Moldova	EUR	63	71
Romania	EUR	68	75
Russian Federation	EUR	58	72
Rwanda	AFR	43	46
Saint Kitts and Nevis	AMR	69	72
Saint Lucia	AMR	69	75
Saint Vincent and the Grenadines	AMR	68	72
Samoa	WPR	67	70
San Marino	EUR	78	84
Sao Tome and Principe	AFR	58	60
Saudi Arabia	EMR	68	74
Senegal	AFR	54	57
Serbia and Montenegro	EUR	70	75
Seychelles	AFR	67	77
Sierra Leone	AFR	37	39
Singapore	WPR	78	82
Slovakia	EUR	70	78
Slovenia	EUR	73	81
Solomon Islands	WPR	69	73
Somalia	EMR	43	45
South Africa	AFR	48	50
Spain	EUR	76	83
Sri Lanka	SEAR	68	75
Sudan	EMR	57	62
Suriname	AMR	63	69
Swaziland	AFR	33	36
Sweden	EUR	78	83
Switzerland	EUR	78	83
Syrian Arab Republic	EMR	69	74
Tajikistan	EUR	59	63
Thailand	SEAR	67	73
The former Yugoslav Republic of Macedonia	EUR	69	75
Timor-Leste	SEAR	55	61
Togo	AFR	50	54
Tonga	WPR	71	71
Trinidad and Tobago	AMR	67	73
Tunisia	EMR	70	74
Turkey	EUR	68	73
Turkmenistan	EUR	56	65
Tuvalu	WPR	61	62
Uganda	AFR	47	50
Ukraine	EUR	62	73
United Arab Emirates	EMR	72	75
United Kingdom	EUR	76	81
United Republic of Tanzania	AFR	44	46
United States of America	AMR	75	80
Uruguay	AMR	71	80
Uzbekistan	EUR	63	69
Vanuatu	WPR	67	69
Venezuela	AMR	71	77
Viet Nam	WPR	68	74
Yemen	EMR	57	61
Zambia	AFR	39	39
Zimbabwe	AFR	37	36
aThe World Health Report 2005: make every mother and child count. Geneva, World Health Organization, 2005. (http://www.who.int/whr/2005/en/index.html)
bThe World Health Report 2004: changing history. Geneva, World Health Organization, 2004. (http://www.who.int/whr/2004/en/report04_en.pdf)