Please answer the following question using the mutiple regression model, both ma

Question

Please answer the following question using the mutiple regression model, both manually calculated in typed form (please no hand written work) and verified with Excel, using 95% confidence level:

You manager just stopped by and said that you have a new route and it is 75 miles with 5 stops and 5 left turns. She wants to know how long that driver will be on the road.

Bulter Trucking Company

A major portion of Bulter's business involves deliveries throughout its local area. To develop better work schedules, the managers want to predict the total daily travel time for their drivers. Initially the managers believed that the total daily travel time would be closely related to the number of miles traveled in making the daily deliveries. See the random sample:

12.54975

Driver Miles Deliveries Left Turns Time 1 90 3 9 15.58477 2 92 5 10 15.52988 3 53 4 7 9.035073 4 66 2 7 9.689488 5 97 2 8 15.50004 6 82 5 4 14.02926 7 86 6 9 17.14598 8 75 3 2 9.90187 9 95 5 8 18.84275 10 50 5 8 9.96034 11 59 4 5 9.154097 12 81 3 10 13.63391 13 60 3 6 8.671543 14 67 3 9 10.99296 15 76 4 5 11.71698 16 79 2 8 13.22408 17 77 5 9 13.88051 18 51 6 9 11.07436 19 59 3 10 9.325663 20 100 2 5

12.54975

SUMMARY OUTPUT Regression Statistics Multiple R 0.958843 R Square 0.91938 Adjusted R Square 0.904264 Standard Error 0.924166 Observations 20 ANOVA df SS MS F Significance F Regression 3 155.8381 51.94603 60.82084 5.74E-09 Residual 16 13.66533 0.854083 Total 19 169.5034 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0% Intercept -5.77095 1.400111 -4.12178 0.000799 -8.73906 -2.80285 -8.73906 -2.80285 Miles 0.165687 0.013552 12.22587 1.57E-09 0.136957 0.194416 0.136957 0.194416 Deliveries 0.873754 0.164456 5.312985 7E-05 0.525122 1.222385 0.525122 1.222385 Left Turns 0.348847 0.096548 3.613209 0.002333 0.144175 0.553519 0.144175 0.553519

Explanation / Answer

From the given output the multiple regression line is as follow:

y = -5.77095+ 0.165687*Miles + 0.873754*Deliveries + 0.348847*Left Turns

Plugging Miles = 75 , Deliveries = 5 , Left Turns = 5 in the above equaion, so we get

y = -5.77095+ 0.165687*75 + 0.873754*5 + 0.348847*5 = 12.76858

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

---