12 Exercise 14-36 Algo 5.75 points Skipped The maintenance manager at a trucking company wants to build a regression model to forecast the time (in years) until the first engine overhaul based on four predictor variables: (1) annual miles driven (in 1,000s of miles), (2) average load weight (in tons), (3) average driving speed (in mph), and (4) oil change interval (in 1,000s of miles). Based on driver logs and onboard computers, data have been obtained for a sample of 25 trucks. A portion of the data is shown in the accompanying table. eBook Print References Time 7.8 0.8 6.2 Miles 42.6 Load 18.0 Speed 47.0 Oil 20.0 98.6 22.0 48.0 34.0 61.1 19.0 55.0 23.0 Click here for the Excel Data File b. Estimate the regression model. (Negative values should be indicated by a minus sign. Round your answers to 4 decimal places.) Predicted Time = Miles + Load Speed + Oil d. What is the predicted time before the first engine overhaul for a particular truck driven 56,000 miles per year with an average load of 23 tons, an average driving speed of 55 mph, and 21,000 miles between oil changes. (Do not round intermediate calculations. Round final answer to 2 decimal places.) Predicted Time years Time Miles Weight Speed Oil 7.8 42.6 18 47 20 0.8 98.6 22 48 34 8.8 43.2 18 67 9 1.1 110.8 32 59 31 1.3 102.2 27 52 13 1.8 96.7 27 59 15 2.8 92.7 26 58 16 7.2 54 16 67 18 8.0 51.4 25 50 15 4.3 84.9 20 59 25 0.3 120.3 27 57 23 5.4 78 27 45 31 5.4 68.4 20 46 25 5.2 55.3 22 57 28 5.6 67.2 23 63 29 8.2 39.6 25 48 19 5.4 52.9 26 53 20 6.2 54.7 22 53 12 4.1 74.9 23 66 20 6.3 58.2 24 49 15 6.5 52.2 24 52 22 6.7 68.1 15 53 20 3.9 94.5 19 58 25 7.2 6.2 2 45.5 15 56 20 61.1 19 55 23