Hello, you assisted one of my classmates previously with 3 answers to this question

Hello, you assisted one of my classmates previously with 3 answers to this question.  I already have the first parts correct and am just missing the last, part 4.   Can you help me in learning and understanding?  I'm not only interested in the answer, but also the steps to figure it out (as I have other similar questions I need to answer).  Please assist if you can:

The Federal Graduation Rate (FGR) for a college/university is the percentage of the school's admitted freshmen that graduate from that school within 6 years. A school's FGR is calculated for all students, for all athletes, and for athletes in individual sports. The FGR is especially useful in the athletic context because it enables comparison of the academic success of athletes with the academic success of other students on campus.

Evaluation of the academic success of a school's football players frequently focuses on the difference, or gap between the FGR of the student body and the FGR of the football players, calculated as gap = student body FGR−football player FGR. A large positive value for a school's gap means that the FGR of the football players is much less than the FGR of the student body.

This Excel file Federal Graduation Rates shows the FGRs for 12 ACC schools and 14 SEC schools. Shown are the FGRs for football players at each school for the years 2009, 2010, 2011, and 2012, in addition to each school's football mean FGR and overall student body mean FGR over these 4 years.

The mean of the 2009, 2010, 2011, and 2012 end-of-season Sagarin Ratings of each team is included in the above file as a measure of each school's football success. The Sagarin Ratings, developed by Jeff Sagarin, apply a proprietary statistical technique to evaluate each team by taking into account several factors such as strength of schedule, strength of opponent schedules, win/loss records, wins on the road and other variables. The Sagarin ratings were obtained from USA Today, which has been publishing them since 1985.

Question 1. Answer is University of Alabama

slope b_{1 =  .2987}

intercept b_{0 =  -4.2797}

predicted gap = 25.45

residual =  -19.95

Question 4. Construct a 95% prediction interval for the gap at the school in Question 1.

lower bound of prediction interval (use 3 decimal places).

upper bound of prediction interval (use 3 decimal places).