Question

Countr Afghanist Algeria Angola Argentina Australia Bahrain Belarus Belize Benin Bhutan Bolivia British Vir Brunei Burkina F Canada Chad Congo, De Congo, Costa Rica Cote d'lvo ion CMR1998CMR2008 257 257 49.4 5 213.9 23.6 158 10.2 19.8 29.9 25.4 5154.3123.4 84 57.4 96.6 26.6 8.92 191.96 190.7 2031 186.8 209 161.4 5112.2125.4 11.5 126.5 15.2 140.4 Denmark Dominica Dominican Egyp Equatoria Estonia France Gabon Gambia German Ghana Guatemala Guinea Guinea-Bi Guyana Honduras Iceland India Indonesia Ireland Israel Ital Kiribati Korea, De Latvia 16.8 39.7 58.8 192.2 13.5 37.6 36.2 206 5 142.5 108.6 5110.515.2 59.6 5 202.6150.3 198 60.2 23.9 227.4 75.4 46.5 102.3 58.8 72.07 31.2 74.2 17.5

ONLY ANSWER THE QUESTIONS AT THE BOTTOM

Case Description

Corporations with international operations need to assess the risks associated with setting up and maintaining operations in different regions of the world. Consideration of the risks include considering such issues as political and economic stability. One indicator of the healthcare and quality of life in a country or region that is considered correlated with the risk and stability in the region is the child mortality rate. As a result, the healthcare and quality of care as measured by the child mortality rate in a region can impact the type and amount of investment in a region and countries within a region. The child mortality rate is the number of children 5 and under that die per thousand people in the population. The Inter-agency Group for Child Mortality Estimation (IGME) was obtained from www.childmortality.org. In 2008 the US rate was 7.6 deaths per thousand and in North America (US and Canada) the rate was 6.65 with a standard deviation of 0.68. The Excel file for this assignment has labels for the year, country name, and continent group.

2)What is the conclusion for t-test concerning if the mean child mortality rate for countries in Eastern Europe is more than the mean child mortality rate for countries in the Middle East?

There is insufficient evidence that the mean child mortality rate for countries in Eastern Europe is more than the mean Child mortality rate for countries in the Middle East.  

The means are exactly the same.  

There is insufficient evidence that the mean child mortality rate for countries in Africa is more than the mean Child mortality rate for countries in South Asia.  

There is evidence that the mean child mortality rate for countries in Africa is more than the mean Child mortality rate for countries in South Asia.  

There is evidence that the mean child mortality rate for countries in Eastern Europe is more than the mean Child mortality rate for countries in the Middle East.

Answer 1

What is the conclusion for t-test concerning if the mean child mortality rate for countries in Eastern Europe is more than the mean child mortality rate for countries in the Middle East?

Step 1 - Using the following region coding, we will filter the data for Eastern Europe and the Middle East as shown below
Countries were categories based on region into 8 continents. The coding scheme was 1= South-East Asia, 2 = South Asia, 3 = Western Europe, 4 = Eastern Europe, 5 =Africa, 6 = South America and Islands, 7 = Oceania with Australia and New Zealand, 8 = Middle East, 9 = North America

Step 2 - We need to find if the mean mortality rate in Eastern Europe is greater than the Middle East

Hypothesis

Let $\mu_{ee}$ = mean child mortality rate for countries in Eastern Europe
Let$\mu_{me}$ = mean child mortality rate for countries in Middle East

$\\H_0 : \mu_{ee} - \mu_{me}>0\\ H_1 : \mu_{ee} -\mu_{me}<0$

Step 3 - To test this hypothesis we need to use the data analysis tab in excel as shown below and select t-test: Two Sample Assuming Unequal Variance

Step 4: Input the data in t-test dialogue box as shown below.

Step 5: The output will be generated as follows

Step 6: In the output, we look at the Pvalue for one tail test.

We see that the pvalue is less than 0.05, hence we reject the null hypothesis and conclude that the mean child mortality rate for Eastern Europe is not greater than the Middle east.

Correct answer : There is insufficient evidence that the mean child mortality rate for countries in Eastern Europe is more than the mean Child mortality rate for countries in the Middle East.