We show how to calculate the predicted dependent variable and residual, along with Sum of Squared Residuals, using a "piece-by-piece" approach in Microsoft Excel, matching the output we see in Stata.

This is a follow up to Part 1, where we show how to calculate the OLS slope and intercept coefficient estimates with the same example data:
   • Building an OLS Regression "By Hand" ...  

Link to the excellent Introduction to Econometrics Textbook by AH Studenmund:
https://www.amazon.com/gp/product/933...

My Twitter is:
  / michaelrjonas  

My Google Scholar Page:
https://scholar.google.com/citations?...

ResearchGate:
https://www.researchgate.net/profile/...