solve without excel

Q#2: (6 Marks). The city council of Oshawa is considering increasing the number of police in an effort to reduce crime. Before making a final decision, the council asked the chief of police to survey other cities of similar size to determine the relationship between the number of police and the number of crimes reported. The chief gathered the following sample information. CITY Pickering Ajax Mississauga Oakville Richmond Hill Orillia Barrie Woodbridge Milton POLICE (X) 15 16 25 20 17 13 11 22 15 #of CRIMES (M 18 13 5 7 11 21 20 6 7 a. Determine the correlation coefficient b. Determine the regression equation to estimate the number of crimes (9) C What is the Standard Error of Estimate? d. Determine the number of crimes () when number of police is 40 At the 0.01 significant level, is it reasonable to conclude that there is a relationship in the population between the number of police and the number of crimes? e