1. Use these data and simple regression analysis (by Data Analysis tab in Excel) to develop linear regression models for predicting the haul cost by speed for each of these two vehicles. Discuss the strength of the models.

2. Based on the models, predict the haul cost for 35 mph and for 45 mph for each of these vehicles.

· Please submit only one Excel file for this case assignment.

  • attachment