REGRESSION SPREADSHEET ANALYSIS FOR THIS AND THE NEXT 4 QUES

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

X² = 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

Solution

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]