Given below are seven observations collected in a regression…

Given below are seven observations collected in a regression study on two variables, x (independent variable) and y (dependent variable). Use Excel to:a.Compute a 95% confidence interval for E(y) when x = 5.b.Compute a 95% prediction interval for y when x = 5.     xy  212  39  68  77  86  75  92 ​