A financial modeling tutorial on time-series analysis of regression statistics in Excel including issues like seasonality, autocorrelation, multicollinearity and heteroscedasticity in the Quant 101 data analysis course.
For the video transcript and cell formulas see:
https://factorpad.com/fin/quant-101/t...
Zoom straight to the section you are interested in here:
01:03 - Video Outline
01:33 - Step 1 - Two Types of Regression in Finance
02:42 - Step 2 - Time-Series Details
09:29 - Step 3 - The Case for Visualization
09:59 - Step 4 - Common Estimation Issues
15:05 - Summary
16:00 - Next: Linear Algebra in Excel
For the outline to the Series see:
https://factorpad.com/fin/quant-101/q...
See what else you can learn at:
https://factorpad.com
Happy Learning!
Watch video Time-series analysis of stock return regressions in Excel | Financial Modeling Tutorials online without registration, duration hours minute second in high quality. This video was added by user FactorPad 22 May 2018, don't forget to share it with your friends and acquaintances, it has been viewed on our site 12,936 once and liked it 94 people.