BUS520 Module 4 / Multivariant Estimation and Model Fit: Complete the following tasks in the Module 4 SLP assignment template: 1. Compare the coefficients of determination (r-squared values) from the two linear regressions: simple linear regression from M

Complete the following tasks in the Module 4 SLP assignment template: 1. Compare the coefficients of determination (r-squared values) from the two linear regressions: simple linear regression from Module 3 Case and the multivariate regression from Module 4 Case. Which model had the “best fit”? 2. Calculate the residual for the first observation from the simple linear regression model. Recall, the Residual = Observed value - Predicted value or e = y – ŷ. 3. What happens to the overall distance between the best fit line and the coordinates in the scatterplot when the residuals shrink? 4. What happens to the coefficient of determination when the residuals shrink? 5. Consider the r-squared from the linear regression model and the r-squared from the multivariate regression model. Why did the coefficient of determination change when more variables were added to the model? Module 4 SLP Excel Spreadsheet Attached Module 3 and 4 Case Study Attached