A University admission counselor was examining last year's 1st year retention. She was trying to determine if the student's ACT score impacted their 1st year retention. The data is provided to you in the "Problem 2" tab of the HW 3_1 Data.xlsx file. a) Prepare two scatter plots from this data, one showing ACT as the independent variable and one showing ACT as the dependent variable Properly format (trend line with equation, modify equation with variable names rather than x & y, axes labels, etc.) these scatterplots and paste them into the Word document with Figure numbers. b) Identify which scatterplot correctly represents the relationship between 1st year retention and ACT. Write an interpretation that includes a discussion of model fit, as well as an interpretation of the coefficients in the regression equation. c) Create an ANOVA table for the relationship between 1st year retention and ACT that you selected in (b) (using Excel's Regression procedure), format it to show no more than 3 decimal places and remove duplicate columns. Copy and paste it into the Word document. d) Test the regression model for significance. Be sure that in your answer you state the null and alternative hypothesis; the p-value for the test, and an interpretation of the result of the hypothesis test (what does it mean if you reject the null hypothesis or are unable to reject the null hypothesis. e) Predict the retention rate if a student scored 22 on their ACT. Show how you calculated this value, not just the final value.

1st year retention rate	Avg ACT
82.70%	26.30
80.00%	22.70
78.80%	24.03
89.90%	26.30
67.65%	21.90
67.10%	21.91
73.50%	22.12
91.45%	26.10
79.10%	22.94
59.88%	19.50
88.50%	26.00
67.00%	18.99
72.00%	22.01
59.88%	19.00
63.20%	19.22
84.90%	26.23
70.18%	20.70
65.70%	19.00
66.90%	19.00
76.40%	21.90
87.70%	24.10
68.80%	21.80
67.70%	21.06
86.60%	25.54
67.00%	21.27
85.40%	26.47
66.30%	21.00
72.50%	21.61
73.10%	21.10
76.43%	23.80
75.40%	22.00
76.90%	22.70
52.50%	20.97
72.55%	21.60
76.70%	22.94