REGRESSION. SPREADSHEET ANALYSIS. FOR THIS AND THE NEXT 4 QUESTIONS: The followi
ID: 3438126 • Letter: R
Question
REGRESSION. SPREADSHEET ANALYSIS. FOR THIS AND THE NEXT 4 QUESTIONS: The following are the GMAT scores and GPA's of a random sample of six MBA students. The Graduate School wants to try and predict GPA based on GMAT score.
GMAT
GPA
610
3.6
470
3.25
590
3.5
520
3.2
410
3.0
750
4.0
The following summary data are also provided:
REGRESSION. SPREADSHEET ANALYSIS. FOR THIS AND THE NEXT 4 QUESTIONS: The following are the GMAT scores and GPA's of a random sample of six MBA students. The Graduate School wants to try and predict GPA based on GMAT score.
GMAT
GPA
610
3.6
470
3.25
590
3.5
520
3.2
410
3.0
750
4.0
The following summary data are also provided:
X = 3,350 Y = 20.55
X2 = 1,942,100 XY = 11,682.50 SSE= 0.0208 SST = 0.6288
Calculate the slope of the regression line & the y-intercept
Slope
1.7991
0.0003
0.0029
10.8002
Y-Intercept
1.7991
0.0003
0.0029
10.8002
GMAT
GPA
610
3.6
470
3.25
590
3.5
520
3.2
410
3.0
750
4.0
Explanation / Answer
As
slope = [ n Sum(xy) - Sum(x) Sum(y)]/[ n Sum(x^2) - (Sum(x))^2 ]
Thus, plugging in the given,
slope = 0.002912113 [ANSWER]
********************************
Also,
slope = [ Sum(x^2) Sum(y) - Sum(x) Sum(xy) ] / [n Sum(x^2) - (Sum(x))^2 ]
intercept = [ n Sum(xy) - Sum(x) Sum(y)]/[ n Sum(x^2) - (Sum(x))^2 ]
Thus, plugging in our values,
intercept = 1.7991 [ANSWER]
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.