Linear Regression: SST, SSR, SSE, R-squared and Standard Error with Excel ANOVA
A tutorial on linear regression for data analysis with Excel ANOVA plus SST, SSR, SSE, R-squared, standard error, correlation, slope and intercept. The 8 most important statistics with Excel functions and the LINEST function with INDEX in a CFA exam prep in Quant 101.
For the video transcript and cell formulas see:
https://factorpad.com/fin/quant-101/l...
Zoom straight to the section you are interested in here:
01:44 - Step 1 - Background and Setup
05:34 - Step 2 - Scatter Plot and Data Analysis Tools
10:23 - Step 3 - The 8 Most Important Linear Regression Measures
31:34 - Step 4 - Linear Regression with Excel Functions
35:03 - Step 5 - Final Comments, Homework and Tips
Find the outline for the Quant 101 series here:
https://factorpad.com/fin/quant-101/q...
See what else you can learn at:
https://factorpad.com
Happy Learning!
Watch video Linear Regression: SST, SSR, SSE, R-squared and Standard Error with Excel ANOVA online, duration hours minute second in high quality that is uploaded to the channel FactorPad 17 September 2018. Share the link to the video on social media so that your subscribers and friends will also watch this video. This video clip has been viewed 12,730 times and liked it 149 visitors.
