How to Estimate the Y Intercept in Excel. When you graph a series of (x,y) coordinates in... How to Calculate Using Excel for the Sum of Squares How to Calculate Using Excel for the Sum of Squares.

Using the SLOPE function in Excel, you can find this value for a set of coordinates automatically. Launch Excel and open a spreadsheet containing coordinate data with the x and y values in ...