Question
4-18 Thirteen students entered the undergraduate business program at Rollins College 2 years ago. The following table indicates what their grade-point averages (GPAs) were after
4-18 Thirteen students entered the undergraduate business program at Rollins College 2 years ago. The following table indicates what their grade-point averages (GPAs) were after being in the program for 2 years and what each student scored on the SAT exam (maximum 2400) when he or she was in high school.
Student | SAT Score | GPA |
A | 1263 | 2.90 |
B | 1131 | 2.93 |
C | 1755 | 3.00 |
D | 2070 | 3.45 |
E | 1824 | 3.66 |
F | 1170 | 2.88 |
G | 1245 | 2.15 |
H | 1443 | 2.53 |
I | 2187 | 3.22 |
J | 1503 | 1.99 |
K | 1839 | 2.75 |
L | 2127 | 3.90 |
M | 1098 | 1.60 |
(a) Is there a meaningful relationship between grades and SAT scores?
(b) If a student scores a 1200 on the SAT, what do you think his or her GPA will be?
(c) What about a student who scores 2400?
Please provide excel regression solution with intercept and slope
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
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