top of page
Regression Analysis in Excel
8 videos show you step by step how to get regression results in excel using matrix algebra, standard errors, the F-statistic and R2 (3 parts). In the last three parts we replicate the results using STATA, SAS, Eviews, SPSS as well as by using some of the embedded functions in excel.The necessary data to replicate the results can be found in the excel file that follows.
Once you watch the videos you can replicate the results in the videos by using the excel file on your right. Just click and download.
Part 1. Regression in Excel. Obtaining the beta coefficients
Part 2. Regression in Excel.
Getting the Standard Errors
Part 3. Regression in Excel.
Getting the ANOVA table, R2, F-stat
Part 4. Regression analysis in excel using matrix algebra (part 4/8 STATA)
Part 5. Regression analysis in excel using matrix algebra (part 5/8 estimation in SAS)
Part 6. Regression analysis in excel
(estimation in E-views)
Part 7. Regression analysis in excel
(estimation in SPSS)
Part 8. Regression analysis in excel
(back to excel)
bottom of page