can u answer e,f,g,h,i

5. Copy the residuals from q4b into a new sheet. Copy the columns for the other "predictor" or "explanatory" variables into adjacent columns. That is copy columns Price to Wheelbase, but. excluding Torque. a. Explain what the residuals represent. b. Construct a correlation table (matrix) for the unused explanatory variables and the reciduals. Paste a monv into vour assienment. c. Comment on the correlations of Power, Displacement and Cylinders with the residuals. How have they changed from question 3 ? d. Height has the highest correlation, so construct a model: AxiMPG = intercept + slope1 * Torque + slope2*Height using the Regression tool in Excel. You will need to copy AxgMPG, Torque and Height to a new sheet. Request Residuals and Residual Plots. Copy the 3 tables from the SUMMARY OUTPUT into your assignment. You do not need to show the RESIDUAL OUTPUT. e. Write out the estimated regression formula. f. Fxnlain the meaning of the copffirient for Heikht. Intipdection lu futa Redveitior Muneat Winter ze01 1. What would be year predictions for the taeo leoda Arconds that you looked at in guecties 4? the your pindictiom berere? 5. Copy the residuals from q4b into a new sheet. Copy the columns for the other "predictor" or "explanatory" variables into adjacent columns. That is copy columns Price to Wheelbase, but. excluding Torque. a. Explain what the residuals represent. b. Construct a correlation table (matrix) for the unused explanatory variables and the reciduals. Paste a monv into vour assienment. c. Comment on the correlations of Power, Displacement and Cylinders with the residuals. How have they changed from question 3 ? d. Height has the highest correlation, so construct a model: AxiMPG = intercept + slope1 * Torque + slope2*Height using the Regression tool in Excel. You will need to copy AxgMPG, Torque and Height to a new sheet. Request Residuals and Residual Plots. Copy the 3 tables from the SUMMARY OUTPUT into your assignment. You do not need to show the RESIDUAL OUTPUT. e. Write out the estimated regression formula. f. Fxnlain the meaning of the copffirient for Heikht. Intipdection lu futa Redveitior Muneat Winter ze01 1. What would be year predictions for the taeo leoda Arconds that you looked at in guecties 4? the your pindictiom berere