Reference no: EM131726046
A business statistics professor would like to develop a regression model to predict the final exam scores for students based on their current? GPAs, the number of hours they studied for the? exam, the number of times they were absent during the? semester, and their genders. The data for these variables are given in the accompanying table. Complete parts a through d below.
Score GPA Hours Absences Gender
90 3.22 4.5 2 Male
91 3.00 7.0 0 Female
82 3.08 6.0 4 Male
80 3.25 3.0 1 Female
96 3.93 6.0 2 Female
90 3.60 6.5 1 Female
99 4.00 5.0 0 Male
84 3.18 5.5 0 Female
85 2.98 4.0 2 Male
78 2.95 2.0 0 Male
82 3.15 3.0 4 Female
76 2.71 4.0 1 Male
a. Using? technology, construct a regression model using all of the independent variables.? (Let variable Gen be the dummy variable for gender. Assign a 1 to a? male.)
Complete the regression equation for the model? below, where y=Score?, x1=GPA?, x2=Hours?, x3=Absences?, and x4=Gen.
ModifyingAbove y= ___ + ( )x1 + ( ) x2 + ( ) x3 + ( ) x4
?(Round to two decimal places as? needed.)
b. Interpret the meaning of the regression coefficient for the dummy variable.
c. A test for the significance of the overall regression model shows that it is significant using α=0.10. Using the? p-values, identify which independent variables are significant with α=0.10.
d. Construct a regression model using only the significant variables found in part c and predict the average exam score for a student who studied 3.5 hours for the? class, missed three classes during the? semester, has a current GPA of 3.89?, and is female.