Question

A business statistics professor would like to develop a regression model to predict the final exam scores​ (y) for students based on their current GPAs (x1), the number of hours they studied for the exam (x2​), and the number of times they were absent during the semester (x3​).

Score   GPA   Hours   Absences
68   2.53   3.00   0
70   2.60   2.50   1
74   3.08   6.00   4
77   3.35   1.50   0
78   2.99   2.00   3
79   2.80   4.50   0
83   3.25   3.00   1
84   3.18   5.50   0
84   2.71   4.00   1
85   3.75   2.00   0
86   2.92   6.00   1
86   3.16   5.00   3
87   3.54   4.00   0
89   3.66   5.00   0
90   3.40   6.00   1
91   3.79   7.00   0
92   4.00   5.00   0
93   2.98   4.00   2
98   2.88   3.50   0
100   3.48   6.50   1

a) Construct a regression model using all three independent variables.

y=___+___x1+___x2+___x3 ​(Round to two decimal places as​ needed.)

​b) Interpret the meaning of the regression coefficients. (Round to two decimal places as​ needed.)

Each additional GPA point increases the final exam score by ___ Each additional hour studied increases the final exam score by ___ Each additional day absent decreases the final exam score by ___.

Answer 1

+ using MS-Excel. @ 9= 51.52 + 7.97 nit 1.9722+ (-0.873 Each additivnal GPA point increases the final exam score by 17.97 Each aelditional hour studied increases the final exam score by 11.97 Each additional day absent decrease the final exam scare by 10.87