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.

Prepare a report (see below) using the numerical methods of descriptive 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 descriptive statistics for each of the years along with an explanation of what the descriptive statistics tell us about the different years. Are the cities 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 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.
Explain how you approached and answered the question or solved the problem, and, for each question, show all steps involved.