Answer c,d,e,f.

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 AvgMPG on the vertical axis and Torque on the horizontal. Paste a copy of this chart into your assignment. b. Use the Regression function in Excel to fit the model AvgMPG = 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. c. 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. d. 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. e. The first observation in the data set is for a Honda Accord Hybrid Sport with a Torque of 247lbft. What is the predicted AvgMPG? The 2nd observation is also a Honda Accord, but a different model. It has a Torque of 260lbft. What is the predicted AvgMPG? f. Looking at the actual AvgMPG for these 2 cars, what is your opinion of your predictions in 4e