MTH156 CSU Mod 2 Descriptive Statistics & Correlation Coefficient Report
Instructions
Today there are 195 sovereign countries in the world 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 China at three different times (depending on when a census was taken). The data for these cities can be found in the file named (attached) Populations. Use all of the data points for each of the years given, but please note that not every city has a population for each census.
Prepare a report (see below) using numerical methods of descriptive statistics 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 descriptive statistics for each of the years along with an explanation of what the descriptive statistics tell us about the different years. Are they continually growing, or is there a decrease in the number of people? The descriptive statistics will include the mean, mode, range, standard deviation, and the 5-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, please 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. Please provide an explanation of the relationships. Show your calculations for each correlation coefficient within the spreadsheet.
Paper Requirements
Write a report. Items that should be included, at a minimum, are a title page, an introduction, a body which answers the questions posed in the problem, and a conclusion paragraph that addresses your findings and what you have determined from the data and your analysis. As with all written assignments, you should have in-text citations and a reference page. Please include any tables of calculations, calculated values, and graphs associated with this problem in the body of your assignment response.
Note: You must submit your Excel file with your report. This will aid in grading with partial credit if errors are found in the report.
“Place your order now for a similar assignment and have exceptional work written by our team of experts, guaranteeing you A results.”
Attachments
20190526012109mth156_ct_mod2_option2_china_populations_students (17 kB)
