For this assignment, find which indicator you are assigned in the table below, then open the attached excel file. Notice that the file has two sheets: one for the data and another for variable definitions. The data is for all countries in the world, and it represents averages of the indicators over the last five years.
Using excel, select the countries column and the indicator you were assigned. At this point, your sheet should only have two columns, one for the countries and another for your indicator. Start by deleting rows where countries have messing data, if any. If your indicator is in millions or billions, please create a new variable where the units are in millions/billions. For example, if you choose the Population, total indicator, then you should create a new column that is equal to Population, total divided by a million, and name it Population, total (millions). Report a summary statistics table on the selected indicator, and interpret your results. Your table should have the following statistics: Mean, Median, Mode, Standard Deviation, Range, Minimum, and Maximum.
From the summary statistics, what can you say about the typical country in terms of your indicator? Give examples of countries that represent the typical country in your indicator. Give examples of countries that are one, two, and three standard deviations form the mean. What does that mean in terms of your indicator?
Remember, to get a summery statistic you need to go to DATA->Data Analysis->Descriptive Statistics and click OK. In the Input Range, highlight the column you are summarizing. Click on Labels in first row, and don’t forget to select Summery statistics, then click OK.
The table below specifies which indicator you are assigned based on the first letter of your last name.
|Indicator||Choose if last name starts with|
|Population, total||A B Y|
|GDP (current US$)||C D Z|
|Enrolment in primary education, both sexes (number)||E F|
|Average precipitation in depth (mm per year)||G H|
|Mortality rate, infant (per 1,000 live births)||I J|
|Land area (sq. km)||K L|
|CO2 emissions (kt)||M N|
|Exports of goods and services (BoP, current US$)||O P|
|Unemployment, total (% of total labor force) (national estimate)||Q R|
|Hospital beds (per 1,000 people)||S T|
|Internet users (per 100 people)||U V|
|Life expectancy at birth, total (years)||W X|