There are 195 sovereign countries in the world today that are officially recognized. One can choose to look at many types of data coming from these countries, as there is a plethora of existing information. For this assignment, you will be looking at populations of cities within Brazil at four different points in time (depending on when a census was taken). The data for these cities can be found in the file named POPULATIONS Download POPULATIONS. Use all of the data points for each of the years given, but note that not every city has a population for each census.
Prepare a report (see below) using the numerical methods of descriiptive statistics presented in this module to show how the populations of the cities vary over the years (growth rates). Be sure to include the following three (3) items in your report:
Compute descriiptive statistics for each of the years along with an explanation of what the descriiptive statistics tell us about the different years. Are the cities continually growing or is there a decrease in the number of people? The descriiptive statistics will include the mean, mode, range, standard deviation, and the five-number summary (minimum, first quartile (Q1), median (Q2), third quartile (Q3), and maximum).
Determine which cities, if any, should be considered outliers in each of the years. If there are any outliers in any year, list them and state for which year each one is an outlier. Use the z-score method to determine outliers for this question showing the z-score calculations for each city and year in your spreadsheet.
Determine the correlation coefficient between the first year and each of the other years. Provide an explanation of these relationships. Show your calculations for each correlation coefficient within the spreadsheet.
Requirements:
Your paper should be 2-3 pages in length (not counting the title page and references page) and cite and integrate at least one credible outside source. Include a title page, introduction, body, conclusion, and a reference page.
The introduction should describe or summarize the topic or problem. It might discuss the general applications of the topic or it might introduce the unique terminology associated with the topic.
The body of your paper should address the questions posed in the problem. Explain how you approached and answered the question or solved the problem, and, for each question, show all steps involved. Be sure this is in paragraph format, not numbered answers like a homework assignment.
The conclusion should summarize your thoughts about what you have determined from your analysis in completing the assignment. Nothing new should be introduced in the conclusion that was not previously discussed in the body paragraphs.
Include any tables of data or calculations, calculated values, and/or graphs referenced in the paper. (Note: The minimum required length excludes any tables or graphs.)
A short summary containing much that you need to know about paper formatting, citations, and references is contained in the Template Paper.
NOTE: You MUST submit your Excel file with your report. This will allow you to qualify for consideration for partial credit if any errors are found in your report.