Calculate standard deviation of urban population variable

Assignment Help Applied Statistics

Reference no: EM133954895

Assignment: Excel data

The "country_data.xlsx" Excel file (posted in the Data module) contains various statistics for the countries of the world. (Some small countries are not included.) The file "country_variables.txt" contains short descriptions of what each of the statistics measures.

I. Make a histogram of the infant mortality rate variable (Column AE). Discuss this graph. What kind of shape does it have?

II. Calculate the mean and the median of the infant mortality rate variable. Do these match with what you expect from the shape of the graph?

III. Make a histogram of the urban population variable (Column V). (This variable measures the percentage of the population of each country that lives in cities.) Discuss this graph. What kind of shape does it have?

IV. Calculate the mean and the median of the urban population variable. Do these match with what you expect from the shape of the graph?

V. Calculate the standard deviation of the urban population variable. What percentage of the countries turn out to be within one standard deviation of the mean? Get the instant assignment help. What percentage of the countries turn out to be within two standard deviations of the mean? How close are these to the percentages you would see in the Normal distribution?

VI. Make side-by-side boxplots of the urban population variable, for the different regions of the world (Column B). Discuss what you learn from this graph. How do the regions differ in their urban population percentages?

VII. Make a scatterplot for the urban population variable and the GDP per capita variable (Column I). Describe the pattern between these two variables.

VIII. Pick one more variable and make a set of side-by-side boxplots for this variable and the different regions of the world. Discuss what you learn from this graph.

IX. Pick two more variables and make a scatterplot for them. Try to find a pair of variables that have some kind of a pattern between them. Discuss what you learn from this graph.

Reference no: EM133954895

Questions Cloud

Describe the benefits interoperability provides : Describe the benefits interoperability provides between healthcare systems. Discuss some of the actual or potential concerns that may be associated.

Address the moral issues associated with limiting life : Address the moral issues associated with limiting life support - Important considerations such as implications, justifications, and any conflicts of interest

Intensive care area handling pulmonary problem patient : Assuming that you are assigned in the Intensive Care Area handling a pulmonary problem patient.

Discuss the role bullying and incivility plays : Discuss the role bullying and incivility plays in the creation of conflict. What are some steps management can take to reduce and/or eliminate bullying

Calculate standard deviation of urban population variable : Calculate the standard deviation of the urban population variable. What percentage of the countries turn out to be within one standard deviation of the mean?

Hemorrhagic stroke and ischemic stroke : What are the differences in clinical manifestations between a hemorrhagic stroke and an ischemic stroke?

Discuss the moral principles : Provide two examples of ethical issues frequently encountered in healthcare-related to finance. Also, discuss the moral principles

Repaired fracture and persistent tremors-muscle cramping : Daisy has had great difficulty mobilizing- related to ongoing pain with weightbearing to her repaired fracture and the persistent tremors, muscle cramping

Discuss the applicable labor laws for protecting employee : Address the following in your paper: Discuss the applicable labor laws for protecting (a) the employee and (b) the independent contractor.

User Account

All Pages