Murders (X)

2.4

2.7

3.6

2.6

2.1

3.3

7.6

3.7

Robberies(Y)

25.3

34.3

71.6

51.1

30

49

173

55.8

1. Create a scatterplot of the data. (You may use either Excel or take a picture and upload that image file. The file must be a XLSX or JPG format so that I may open it up to view it. Call the help desk if you are not sure how to do this.)
2. Compute the value of the correlation coefficient.
3. Explain the strength, direction and form for this relationship in context.
4. What is the regression equation?
5. Compute thenumber of expected robberies whenyou have 3.5 murders.
6. Compute from the regression equation the number of expected robberies whenyou have 2.6 murders.
7. What is residual for 2.6 murders?
8. What is the Coefficient of Determination?
9. Write the explanation for the coefficient of determination using the value and context for the above scenario.
10. Comment (don't fix) on any influential points. If there are no influential points then comment on that as well.