This video demonstrates the long method of calculating the intercept and standard error of estimate -- if you have the data analysis toolpak installed, please refer to the video explaining how to use it for bivariate regression.