Question

Question 1

A soft drink bottler is analyzing the vending machine service routes in his distribution system. He is interested in predicting the amount of time required by the route driver to service the vending machines in an outlet. The industrial engineer responsible for the study has suggested that the two most important variables affecting the delivery time (Y) are the number of cases of product stocked (X₁) and the distance walked by the route driver (X₂). The engineer has collected 24 observations on the delivery times, which are shown on the Excel file.

Observation	Delivery Time, y	Number of Cases, x1	Distance, x2 (ft)
1	16.68	7	560
2	11.5	3	220
3	12.03	3	340
4	14.88	4	80
5	13.75	6	150
6	18.11	7	330
7	8	2	110
8	17.83	7	210
9	21.5	5	605
10	40.33	16	688
11	21	10	215
12	13.5	4	255
13	19.75	6	462
14	24	9	448
15	29	10	776
16	15.35	6	200
17	19	7	132
18	9.5	3	36
19	35.1	17	770
20	17.9	10	140
21	52.32	26	810
22	18.75	9	450
23	19.83	8	635
24	10.75	4	150

Using the chosen model from part g), predict the delivery time when 10 cases need to be stocked, and the distance to be walked is 500 ft. Give a 95% prediction interval for this estimate.

Answer 1