A business statistics professor at State College 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 can be found in the Excel file final exam scores 2.xlsx.

a. Using PH_Stat, construct a regression model using all of the independent variables.

b. Test the significance of the overall regression model using α = 0.10.

c. Interpret the meaning of the regression coefficient for the dummy variable.

d. Using the p values, identify which independent variables are significant with α = 0.10.

e. Construct a regression model using only the significant variables found in part d and predict the average exam score for a student who studied 4.0 hours for the exam, missed two classes during the semester, has a current GPA of 3.45, and is male