i already put all the data

Management of a soft-drink bottling company wants to develop a method for allocating de livery costs to customers. Although one cost clearly relates to travel time within a particular route, another variable cost reflects the time required to unload the cases of soft drink at the delivery point. A sample of 20 deliveries within a territory was selected. The delivery times and the numbers of cases delivered were recorded Data: Delivery). (a) Construct a scatter plot of delivery time and number of cases delivered. Comment on the graph. (b) Find and interpret the correlation coefficient between delivery time and number of cases delivered (c) Estimate the regression model to predict delivery time, based on the number of cas cases delivered. (d) Interpret the meaning the regression coefficients. (e) Determine the coefficient of determination and explain its meaning in this problem. (f) At the 0.05 level of significance, is there evidence of a linear relationship between delivery time and the number of cases delivered? (g) Predict the delivery time for 150 cases of soft drink. (f) At the 0.05 level of significance, test whether having elevator in the apartment building has an effect on the total number of labor hours. (8) Find and interpret the coefficient of multiple determination in this problem. (h) Predict the labor hours for moving 500 cubic feet with two large pieces of furniture in an apartment building that has an elevator. moving delivery Cases 52 64 73 85 95 103 116 121 143 157 161 184 202 218 243 254 267 275 287 298 Time 32.1 34.8 36.2 37.8 37.8 39.7 38.5 41.9 44.2 47.1 43 49.4 57.2 56.8 60.6 61.2 58.2 63.1 65.6 67.3 moving delivery X3 1 1 0 0 X2 3 2 2 2 1 3 2 1 6 1 1 1 1 1 1 1 4 1 1 4 Y 24.00 13.50 26.25 25.00 9.00 20.00 22.00 11.25 50.00 12.00 38.75 40.00 19.50 18.00 28.00 27.00 21.00 15.00 25.00 45.00 29.00 21.00 22.00 16.50 37.00 32.00 34.00 25.00 31.00 24.00 40.00 27.00 18.00 62.50 53.75 79.50 XI 545 400 562 540 220 344 569 340 900 285 865 831 344 360 750 650 415 275 S57 1028 793 523 564 312 757 600 796 577 500 695 1054 486 442 1249 995 1397 3 2 3 2 2 2 2 5 4 3 3 2 3 3 3 3 4 3 4 3 2 5 6 7 1 1 1 1 0 1 1 1 1 1 1 1 0 0 1 1 1 1 1 1 1 0 1 0