USE = 0.05

To determine whether the ACT scores can be used to predict college GPAs, scores and GPAs of 20 students surveyed. The data are shown.

ACT Scores	College GPAs
16	1.85
18	2.2
24	2.8
25	3.5
34	4
27	3.18
29	3.9
25	2.9
30	4
21	2.6
17	2.5
21	3.65
28	3.1
31	3.72
35	3.24
18	2.3
17	1.7
26	3.1
28	3.5
23	2.76

USE = 0.05

A) Considering the model where ACT scores are used to predict college GPAs, test the model to determine if the model is valid. Be sure to state your null and alternative hypotheses. What is your p-value? What is your conclusion? As a part of this assignment, submit a copy of your Excel file with this p-value clearly labeled.

B) Using this same model, test the slope to determine if it is significant. Be sure to state your null and alternative hypotheses.What is your p-value? What is your conclusion? As a part of this assignment, submit a copy of your Excel file with this p-value clearly labeled.

C) What is the value of the Coefficient of Determination? As a part of this assignment, submit a copy of your Excel file with this value clearly labeled.

D) What is the value of the standard error of the estimate? As a part of this assignment, submit a copy of your Excel file with this value clearly labeled.