Quantitative Project: World Income and Health Inequality

Variables

% Undernourished → Infant Mortality Rate

Q3.

Copy and Past the data to a new worksheet. Keep the original data unchanged.

Highlight all columns without the title of each column, then click Data on the

command menu, select “Column B” in the window under “Sort by”, then “Ok.”

The lowest is Libya with 2.5%; the highest is Eritrea with 75%.

Q4.

The difference is 75% - 2.5% = 72.5%

Q6.

1) To calculate the number of people undernourished in Libya:

In a new column and in the same row for Libya, enter a formula, “=B1*D1”. It will give you “15.75”.

2) Then use the “Copy” and “Paste” function to calculate the number of people undernourished in all the other 9 countries.

3) To calculate the total number of people undernourished in the five lowest countries:

In a separate cell, enter “=sum(f1..f5)”

(Two dots between f1 and f5)

It will give you “1006.75”.

4) To calculate the total population of the five lowest countries:

In a separate cell, enter “=sum(d1..d5)”

It will give you “402.7”.

5) To calculate the average undernourished rate of the five lowest countries,

divide the total number of people undernourished from 3) by the total

population of these five countries 4):

1006.75 / 402.7 = 2.5

6) Similarly, repeat 3), 4), 5), calculate the average undernourished rate of the

five highest countries:

6334.2 / 88.4 = 71.7

7) The difference between these two groups: 71.7% - 2.5% = 69.2%

Interpretation: While only 2.5% of the population are undernourished in the world’s five least undernourished countries, 71.7% of the population are undernourished in the world’s five most undernourished countries. The percentage difference is 69.2%.

Q7 – Q10.

Copy and Past the data to a new worksheet.

Refer to Q3 – Q6.

Q11.

Highlight all the numbers of the two columns of “% Undernourished” and “Infant Mortality Rate”

Click “Insert” on the command bar, and select “Chart”;

Select the “XY (scatter)” chart type. Then click “Next”.

Click “Next”,

Give a title.

“Figure 1. The Relationship between % Undernourished and

Infant Mortality Rate”.

Label the X and Y axis.

Click the “Legend” button, uncheck the “Show legend” box.

Click “Next”, check the “As new sheet” box.

Click “Finish”.