Description
In this video I show the steps of calculating multiple linear regression manually and using Excel functions and compared against the result of the data analysis toolpack. I covered the following:
1. Correlation (R)
2. Coefficient of Determination (R2)
3. Adjusted R2
4. Standard Error (SE)
5. Observation (Sample Size)
6. Degree of Freedom (df)
7. Sum of Squares (SS)
8. Mean Sum of Error (MSE)
9. F Statistic
10, Regression Model Significance (P-Value)
11. Intercept
12. Slope
13. Standard Error of Coefficient
14. T Statistic
15. P-Value
16. Confidence of Intervals
17. Residuals
I hope you enjoy watching the video.