QUESTION 2 The table below presents the scores of 15 large Canadian cities on three variables. Compute the r and 1'2 statistics for each combination of the three variables. Assuming that these 15 cities are a random sample of Canada's 50 largest cities, test the correlations for their statistical signicance (0.05 level). For those correlations that are statistically signicant, generate the regression equations 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 each combination of variables (non-directional, 0.05 Type I error rate). . ...Hint, there are 3 combinations. c) Calculate the relevant Pearson correlation coefcients ...... you can calculate the rvalue by hand, but must use MS EXCEL for the preceding calculations. d) Use the Pearson table to evaluate statistical signicance. e) For the signicant correlations, compute the 12 values, the regression equation, and the associated SEE. t) In a short paragraph (doublespaced, approximately one~half page), write your conclusions to the study. CITY Per Capita Percentage High Rank in Per Capita Expenditures on School Graduates Income Education A I 1,102 82 48 B 1,339 90 7 C 1,907 88 1 D 1,171 84 25 E 1,621 86 9 F 1,276 88 24 G 1,159 81 45 H 1,412 86 5 I 1,487 86 18 I 1,041 80 50 K 1,194 90 22 L 1,262 88 6 M 1,163 79 32 N 1,223 86 15 0 1,549 90 20