Customize a regression with LINEST and Excel INDEX Functions
A tutorial on Excel's LINEST function with examples to customize regression constant and stats and Excel's INDEX function syntax to access array output for the Quant 101 data analytics course.
For the video transcript and Excel formulas see:
https://factorpad.com/fin/quant-101/e...
Zoom straight to the section you are interested in here:
00:41 - Video Outline
01:14 - Step 1 - Three Ways to Run Regressions in Excel
03:41 - Step 2 - Standard Excel Regression Functions
06:32 - Step 3 - Regression using LINEST
10:35 - Step 4 - Access Statistics using INDEX
13:38 - Step 5 - Interpret Regression Output
18:38 - Summary
19:16 - Step 6 - Next: Expected Return with LINEST
For the outline to all videos in the series see:
https://factorpad.com/fin/quant-101/q...
See what other professional tutorials we have for you at:
https://factorpad.com
Happy Learning!
Watch video Customize a regression with LINEST and Excel INDEX Functions online without registration, duration hours minute second in high quality. This video was added by user FactorPad 04 June 2018, don't forget to share it with your friends and acquaintances, it has been viewed on our site 5,076 once and liked it 37 people.