What is the multiple regression formula for the below data s
What is the multiple regression formula for the below data set. Write the regression formula for STAT GRADE in terms of the other two dependent variables.
A) None of the above
 B) STAT GRADE=18.73+9.96*HSGPA+0.147*SAT MATH
 C) STAT GRADE=15.73+8.46*HSGPA+0.147*SAT MATH
 D) STAT GRADE=12.73+6.46*HSGPA+0.047*SAT MATH
 E) STAT GRADE=19.82+7.86*HSGPA+0.067*SAT MATH
| HSGPA | SAT MATH | STAT GRADE | 
| 2 | 800 | 57 | 
| 2.4 | 875 | 70 | 
| 2.6 | 900 | 76 | 
| 3 | 1200 | 90 | 
| 3.2 | 1175 | 92 | 
| 3.5 | 1300 | 94 | 
| 4 | 1325 | 97 | 
Solution
sol) The multiple Regression is y=a+bx1+cx2
where
Using Excel Analysis
Hence from above analysis
Stat grade=12.73+6.46(HSGPA) +0.047(SAT MATH)
| y= HSGPA | X1=SAT MATH | X2=STAT GRADE | 

