4. The variable with the strongest correlation is Torque, so let us start with building a model using just this variable. Torque is related to Horsepower {Power} and measures rotational force. a. Construct a scatter chart with AngPG on the vertical axis and Torque on the horizontal. Paste a copy of this chart into your assignment. Average MPG versus Torque ED 50 4D .0 O O . C 0 Average MPG 30 0 . I 0 20 - his - 10 Torque b. Use the Regression function in Excel to fit the model AngPG = intercept + slope*Torque Request Residuals and Residual Plot for this model. Copy the Regression Summary Output into your assignment. Do not copy the Residual Output or the Residual Chart. Regression Statistics Multiple R 0.736629 R Square 0.542622 Adjusted R Square 0.542168 Standard Error 3.366888 Observations 1008 ANDVA (if 55 Regression 1 13529.38028 Residual 1006 11403.95206 Total 1007 24933.33234 Coefficients Standard Error Intercept 3355024 0.296446913 Torque.lbft -0.03057 0.000884988 Although it may be difficult to explain Torque, try to explain the meaning of the coefficient for Torque in as simple a manner as possible. As noted in Chapters 6 and 7', often the intercept does not make sense. Nonetheless, try to explain what the value of the intercept represents in this particular model. The first observation in the data set is for a Honda Accord Hybrid Sport with a Torque of 247' lLJWft. What is the predicted .W? The 2rd observation is also a Honda Accord, but a different model. It has a Torque of 260 Loft. What is the predicted W? Looking at the actual Wfor these 2 cars, what is your opinion of your predictions in 4e? \f