Raw Data:https://docs.google.com/spreadsheets/d/1PupzAsK_LtwQD0EQt03C4qq-oPJhOXev6V-CqTOOyuU/edit#gid=2077500852

Completed: https://docs.google.com/spreadsheets/d/1PupzAsK_LtwQD0EQt03C4qq-oPJhOXev6V-CqTOOyuU/edit#gid=2077500852

QUESTION

Please explain what the descriptive statistics tell regarding the different years on the attached completed link

Are the cities continually growing or is there a decrease in the number of people?which cities, if any, should be considered outliers in each of the years?

Are there any outliers in any year? Please list them and state which year each one is an outlier and mention how the z-score method determined these outliers.

Please explain the correlation coefficient between the first year and each of the other years.

Please explain these relationships while referencing the calculations for each correlation coefficient within the spreadsheet attached

Again, here is the completed attachment to answer the questions only based on this

https://docs.google.com/spreadsheets/d/1PupzAsK_LtwQD0EQt03C4qq-oPJhOXev6V-CqTOOyuU/edit#gid=2077500852

Respectfully, if you are unable to copy and paste the link to view and answer the question (s) based on the link, move on and let another tutor answer. Everything needed is on the link. Thank you