Please help. I need the following:

(1) Perform the procedural steps in SPSS, indicate the type of test used and a step-by-step guide so I can perform it on my own to understand the process. Please attach the SPSS output so that I have a reference for when I perform it in SPSS as well. (the previous tutor didn't give me the requested SPSS output, I think he/she used excel instead :

(2) Use the least-squares method to compute the regression coefficients b₀ and b₁.

(3) Interpret the meaning of b₀ and b₁ in this problem

(4) Predict the delivery time for 150 cases of soft drink

(5) Should you use the model to predict the delivery time for a customer who is receiving 500 cases of softdrink? Why or why not?

(6) Determine the coefficient of determination, r², and explain its meaning in this problem

(7) Perform a residual analysis. Is there any evidence of a pattern in the residuals? Explain.

(8) At the 0.05 level of significance, is there evidence of a linear relationship between delivery time and the number of cases delivered?

1. Management of a soft-drink bottling company has the business objective of developing a method for allocating delivery costs to customers. Although one cost clearly relates to travel time vvithin a particular route, another variable cost reects the time required to unload the cases of soft drink at the delivery point. To begin, management decided to develop a regression model to predict delivery time based on the number of cases delivered. A sample of 20 deliveries within a territory was selected. The delivery times and the number of cases delivered were organized in the following table [and stored in): I 52 32.1 I I 161 43.0 2 64 34.8 12 184 49.4 3 73 36.2 13 2H2 512 4 8.5 37.8 [4 2 I 8 56.8 5 95 318 15 243 60.6 5 103 39.7 16 254 6 I .2 7 l 16 38.5 I? 261' 58.2 3 12! 4] .9 13 275 63.1 9 143 44.2 19 231' 65.6 10 IS? 41.] 20 298 61.3