The Delivery Time Data: 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. This service activity included a) Fit a multiple linear regression model relating the number of cases and distance to the delivery time b) Construct the analysis of variance table and test for the significance of regression c) Calculate R2 and RADJ for this model d) Calculate the t-statistic for testing the hypothe
The Delivery Time Data: 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. This service activity included
a) Fit a multiple linear regression model relating the number of cases and distance to the delivery time b) Construct the analysis of variance table and test for the significance of regression
c) Calculate R2 and RADJ for this model
d) Calculate the t-statistic for testing the hypothesis Ho: β2=0, Ho: β1=0 and Ho: βo=0
Table 2 Delivery Time Data
Delivery time (minutes) |
Number of Cases |
Distance (ft) |
16.68 |
7 |
560 |
11.50 |
3 |
220 |
12.03 |
3 |
340 |
14.88 |
4 |
80 |
13.75 |
6 |
150 |
18.11 |
2 |
330 |
8.00 |
7 |
110 |
17.83 |
2 |
210 |
79.24 |
30 |
1460 |
21.50 |
5 |
605 |
40.33 |
16 |
688 |
21.00 |
10 |
215 |
13.50 |
4 |
255 |
19.75 |
6 |
462 |
24.00 |
9 |
448 |
29.00 |
10 |
776 |
15.35 |
6 |
200 |
19.00 |
7 |
132 |
9.50 |
3 |
36 |
15.35 |
17 |
770 |
35.10 |
10 |
140 |
17.90 |
26 |
810 |
52.32 |
9 |
450 |
18.75 |
8 |
635 |
10.75 |
4 |
150 |
e) Using the partial F test, determine the contribution to the How is this partial F statistic related to the t-test for β calculated in part (d)
f) Write a short report of your findings
Step by step
Solved in 3 steps with 2 images