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
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.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started