Customer Number of Cases Delivery Time 32.1 34.8 36.2 37.8 37.8 39.7 38.5 41.9 4

Question

Customer Number of Cases Delivery 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 52 64 73 85 95 103 116 121 143 157 161 184 202 218 243 254 267 275 287 298 10 12 13 14 15 16 17 18 19 20 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 the number of cases delivered were organized in the file here What are the values for (1) the sum of squares Y (2) the sum of squares error (3) the sum of squares predicted (4) the proportion of variation in delivery time that is explained by the number of cases delivered (5) the lower limit of the 95% confidence interval estimate for the population slope (6) the upper limit of the 95% confidence interval estimate for the population slope (7) the intercept A (8) the slope b (9) the standard error of estimate (10) the predicted deliverty time for 100 cases of of soft drink Hint: Use PHStat to obtain all the values and answers should be accurate to 4 decimal places.

Explanation / Answer

1)2514.4975
2) 71.03149
3) 2443.46606
4)0.97175
5) 0.1282039
6)0.1518487
7) 24.83453
8)0.140026
9)1.9865
10) 38.83716135

SUMMARY OUTPUT Regression Statistics Multiple R 0.985774425 R Square 0.971751217 Adjusted R Square 0.97018184 Standard Error 1.986502982 Observations 20 ANOVA df SS MS F Significance F Regression 1 2443.466006 2443.466006 619.1955958 2.15212E-15 Residual 18 71.03149378 3.946194099 Total 19 2514.4975 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Intercept 24.83453095 1.054218648 23.55728671 5.60965E-15 22.61969976 27.04936214 x 0.140026304 0.005627243 24.88364113 2.15212E-15 0.128203904 0.151848704

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.