The table below presents the scores of 15 large Canadian cities on two variables. Compute the r and r statistics. Assuming that these 15 cities are a random sample of Canada's 50 largest cities, test the correlations for their statistical significance (0.05 level). If the correlation is statistically significant, generate the regression equation and associated SEE values. Make sure to write concluding statements from what your found. Make sure to follow the hypothesis testing approach, as outlined in lecture. STEPS: a) Computer all relevant descriptive statistics. b) Write the hypotheses for the relationship (non-directional, 0.05 Type I error rate) c) Calculate the relevant Pearson correlation coefficient......you can calculate the r-value by hand, but must use MS EXCEL for some of the calculations. d) Use the Pearson table to evaluate statistical significance. e) Compute the r values, the regression equation, and the associated SEE. f) In a short paragraph (double-spaced, approximately one-half page), write your conclusions to the study. CITY Per Capita Percentage High Expenditures on School Graduates Education 1,102 82 1,339 90 1,907 88 1,171 84 1,621 86 1,276 88 1,159 81 1,412 86 1,487 86 1,041 80 1,194 90 1,262 88 1,163 79 1,223 86 1,549 90