Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please help! The maintenance manager at a trucking company wants to build a regression model to forecast the time (in years) until the first engine
Please help!
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 Milon Load Speed 6.1 42.3 22.0 43.0 18.0 0.9 98.6 2940 51.0 26.0 6.1 60.9 24.0 61.0 17.0 I 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 d. What is the predicted time before the first engine overhaul for a particular truck driven 58,000 miles per year with an average load of 24 tons, an average driving speed of 55 mph, and 14,000 miles between oil changes. (Do not round intermediate calculations. Round final answer to 2 decimal places.) Predicted Time yourHome Insert Draw Page Layout Formulas Data >> 9 Tell me Share % Conditional Formatting O. Format as Table v Paste Font Alignment Number Cells Editing Anal Cell Styles Da F14 X v fx C E H A B D F G 1 Time Miles Weight Speed Oil 12.3 22 43 18 3 0.9 98.6 29 51 126 4 8.4 43.7 26 63 11 5 1.1 110.5 24 63 23 1.5 102.2 26 51 20 7 2.0 96.9 29 GG 24 8 2.5 93.2 20 156 17 9 7.6 53.7 15 67 11 10 8.1 51.6 21 150 15 11 4.3 84. 22 52 25 12 0.7 120.8 29 148 21 13 4.9 77.8 25 53 32 14 4.9 68.4 18 45 28 15 5.3 55 27 61 26 16 5.8 66.7 15 59 26 17 8.3 39 23 53 20 18 5.3 53.2 26 60 25 19 5.9 54.1 22 53 14 20 4.2 75.3 20 61 22 21 6.0 58.3 23 156 14 22 6.9 51.8 22 58 18 23 6.9 68.3 21 47 17 24 4.1 95.1 26 155 28 25 7.1 45.7 12 62 17 26 6.1 60.9 24 61 17 27 28 29 30Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started