Exercise 14-36 Algo The maintenance manager at a trucking company wants to build a regression model to forecast the time

[answerhappygod]

Exercise 14 36 Algo The Maintenance Manager At A Trucking Company Wants To Build A Regression Model To Forecast The Time 1 (106.9 KiB) Viewed 23 times

Exercise 14 36 Algo The Maintenance Manager At A Trucking Company Wants To Build A Regression Model To Forecast The Time 2 (77.66 KiB) Viewed 23 times

Exercise 14-36 Algo 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. Time 7.9 0.9 Miles 42.7 98.4 Load 18.0 29.0 Speed 43.0 48.0 Oil 14.0 24.0 6.3 61.6 25.0 59.0 20.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 57,000 miles per year with an average load of 20 tons, an average driving speed of 54 mph, and 14,000 miles between oil changes. (Do not round intermediate calculations. Round final answer to 2 decimal places.) Predicted Time years

A B C D E Oil 1 Time 2 7.9 3 0.9 Miles 42.7 98.4 Weight 18 Speed 43 14 29 48 4 8.6 43.3 17 64 24 17 25 21 32 55 5 1.4 6 1.2 110.6 102.3 97.3 26 56 7 1.8 28 64 23 8 2.4 93.1 26 53 19 54.4 65 11 21 18 51.6 56 12 9 7.5 10 8.0 11 4.2 12 0.3 84.8 27 52 31 120.5 27 56 13 5.3 49 49 77.3 69 55.2 67.1 39.4 52.4 20 23 26 23 59 59 25 25 29 25 29 18 30 23 53 21 55 54.3 17 53 12 14 4.9 15 5.4 16 5.7 17 8.8 18 5.3 19 6.1 20 4.5 21 6.2 22 6.9 23 7.3 24 3.9 25 7.3 26 6.3 74.3 26 67 23 58.6 54 16 52 56 20 21 17 18 28 68.9 49 14 94.4 58 20 16 55 19 45.4 61.6 25 59 20