Using Excel and assuming that yb0b1x create a set of formula

Using Excel, and assuming that y=b0+b1x create a set of formulas on a spreadsheet that will give X, Y, X^2, Y^2, XY, (XY)^2, Yhat, e, and e^2. I need to determine b0, b1, Se, Sb1, the lower and upper for a 70% CI, and the lower and upper for a 70% CI if x=4, the correlation coefficient r and the standard deviation for the intercept Sb0.

I also need this to be set up in a way that if i plug in a new data set, then the calculations will happen automatically.

X: 1.5, 1.5, 1.5. 2.5, 2.5, 2.5, 3.5, 3.5, 3.5, 4.5, 4.5, 4.5, 5.5, 5.5, 5.5

Y: 11.44, 12.67, 12.75, 12.69, 14.75, 17.3, 15.86, 15.83, 12.77, 17.68, 16.08, 18.52, 19.19, 18.57, 18.40

Solution