Answers are given in blue and I'm looking for an EXCEL SOLUTION for Part D & E confidence level.
Abusiness statistics professor would like to deveiob a regression model to predict the final exam scores (3:) for students based on their current GPAs (x1 )' the number of hours they studied forthe exam (x2). and the number of times they were absent during the semester (H3). Use the data provided forthese variables to Combiete parts a through f below. E Clickthe icon to View the data set. a) Construct a regression model using all three independent variables. E 50.95 + 8.20 X1 1.92 X + - 0.76 X3 'Round to two decimal places as needed.)b) Interpret the meaning of the regression coefficients. Select the correct choice below and, if necessary, fill in the answer boxes within your choice. (Round to two decimal places as needed.) I Each additional GPA point decreases the final exam SCUl'E py . Each additional hour studied decreases the final exam Score by . Each additional day absent increases the final exam SCUI'E by * Each additional GPA point increases the final exam score by 8.20 . Each additional hour studied increases the final exam score by 1.92 . Each additional day absent decreases the final exam score by ore There is no meaningful interpretation of the regressmn coefficients forthis application. c) Predict the average exam score for a student who studied 4.0 hours for the exam, missed three classes during the semester, and has a current GPA of 2.95. y= 80.56 (Round to two decimal places as needed.)d) Construct a 95% confidence interval for the average exam score for a student described in part c. Interpret the meaning of the interval. The 95% confidence interval is from a lower limit of 74.12 to an upper limit of 87.00. (Round to two decimal places as needed.)Interpret the meaning of the interval. Select the correct choice below and, if necessary, fill in the answer boxes within your choice (Round to two decrmai places as needed.) It can be stated with 95% confidence that the exam score for a particular student who studied 4 9 hours forthe exam. missed three classes during the semester' and has a current GPA of 2 95 is from a lower limit of to an upper limit of * It can he stated With 95% confidence that the average exam score for a student who studied 4 I] hours forthe exam' missed three classes during the semester, and has a current GPA of 2 95 is from a lower limit of r412 to an upper limit of El? DI]. The average exam score for a student who studied 4.9 hours forthe exam, missed three classes during the semester, and has a current GPA of 2.95 is from a lower limit of to an upper limit of 95% of the time e) Construct a 95% prediction interval for the average exam score for a student described in part c, that is, a student who studied 4.0 hours for the exam, missed three classes during the semester, and has a current GPA of 2.95. The 95% prediction interval is from a lower limit of 64.06 to an upper limit of 97.07. 'Round to two decimal places as needed.)Interpret the meaning of the interval Select the correct choice below and, if necessary fill in the answer boxes Within your choice (Round to two decimal places as needed.) The exam score for 8 particular student WhD studied 4 [l hours for the exam, missed three CIEISSES, and has 8 current GPA UT 2 95 IS from 8 lower limit DT tD an upper Ilrhlt DT 95% er the time It can be stated with 95% confidence that the exam score for a particular student who studied 4.0 hours forthe exam. missed three classes during the semester. and has a current GPA of 2.95 is from a lower limit of 64 os' to an upper limit of 97 D7". It can be stated with 95% confidence that the average exam score for a student who studied 4.0 hours forthe exam. missed three classes during the semester. and has a current GPA of 2.95 is from a lower limit of to an upper limit of
