Tutorial 2: Estimating an OLS Regression Model in Excel
This tutorial describes how to estimate an ordinary least squares (OLS) regression model in Microsoft Excel. The estimation of regression coefficients is discussed as is the importance of t-tests. It discusses how the error term is derived in a regression and how to obtain the Sum of the Squared Error (Residual).