Question

"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 within a particular route, another variable cost reflects 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 number of cases delivered were organized in the following table. " Customer Number of Cases Delivery Time 1 52 32.1 2 64 34.8 3 73 36.2 4 85 37.8 5 95 37.8 6 103 39.7 7 116 38.5 SUMMARY OUTPUT Regression Statistics Multiple R 0.983923395 R Square 0.968105247 Adjusted R Square 0.966229085 Standard Error 14.3650584 Observations 19 ANOVA df Regression 1 Residual 17 Total 18 Coefficients Intercept -166.1322496 32.1 6.914624353 b. Run a regression and write the estimated regression equation for determining "Delivery Time" based on "Number of Cases". Equation: c. Predict the mean delivery time for 150 cases of soft drink. delivery time for 150 cases of soft drink: d. Determine the coefficient of determination, and explain its meaning in this problem. coefficient of determination: e. At a 0.05 level of significance, is there evidence of a linear relationship between delivery time and the number of cases delivered? f. Create a graph to examine the relationship between the two variables. Enter the cell cumber of the top left corner of the graph. Cell number:

          "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 within
a particular route, another variable cost reflects 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 number of cases delivered were organized in the
following table. " Customer Number of Cases Delivery Time 1 52 32.1
2 64 34.8 3 73 36.2 4 85 37.8 5 95 37.8 6 103 39.7 7 116 38.5
SUMMARY OUTPUT Regression Statistics Multiple R 0.983923395 R
Square 0.968105247 Adjusted R Square 0.966229085 Standard Error
14.3650584 Observations 19 ANOVA df Regression 1 Residual 17 Total
18 Coefficients Intercept -166.1322496 32.1 6.914624353 b. Run a
regression and write the estimated regression equation for
determining "Delivery Time" based on "Number of Cases". Equation:
c. Predict the mean delivery time for 150 cases of soft drink.
delivery time for 150 cases of soft drink: d. Determine the
coefficient of determination, and explain its meaning in this
problem. coefficient of determination: e. At a 0.05 level of
significance, is there evidence of a linear relationship between
delivery time and the number of cases delivered? f. Create a graph
to examine the relationship between the two variables. Enter the
cell cumber of the top left corner of the graph. Cell number:

Added by Jason M.

Question

Please give Ace some feedback