Answered step by step
Verified Expert Solution
Link Copied!

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!

image text in transcribedimage text in transcribed
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 30

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Public Personnel Administration And Labor Relations

Authors: Norma M Riccucci

1st Edition

1317461754, 9781317461753

More Books

Students also viewed these Economics questions

Question

How flying airoplane?

Answered: 1 week ago