For this question, please download the provided Excel file c…
For this question, please download the provided Excel file containing the raw data. Enter your final answers directly in the answer box below.You do not need to submit the Excel file. However, your step-by-step work in Excel must be clearly visible in your screen recording. I will review the recording to assign partial credit based on your problem-solving process.Q. The City Council of Grand Forks is considering increasing the number of police officers (x) to help reduce crime (y). The Excel file located directly below Question 29, “Q29.xlsx,” reports the number of police officers and the number of crimes last month for eight cities.Using Excel, perform a regression analysis and answer the following questions.a. If Grand Forks increases the number of police officers to 20, what is the estimated number of crimes? Round your answer to the nearest whole number.(8 points)b. Test whether the slope of the regression line is less than zero at a 0.05 significance level. Provide the t-test statistic and the critical value to justify your conclusion.(8 points)c. What is the correlation coefficient, r? (8 points)d. What is the standard error of the estimate? Round your answer to two decimal places. (8 points)
Read Details