The marketing manager at Crystallo Bottling Company is studying the relationship between the number of cases per shipment and transportation costs. An analysis of the data from the previous problem produced the following simple regression output:

R2 = 0.970
Thus, the regression equation is
Y = 0.065X + 87.000
a. Is the evidence consistent with the hypothesis that increasing the number of cases per shipment increases transportation cost?
b. If so, how strong is the relationship between the variables?
c. Based on this analysis, what is the expected additional shipping cost for each extra case per shipment?
Use the AFC member survey (Exhibit 16.2), codebook (Exhibit 16.3), and data ("Avery Fitness Center Data") to perform the following analyses. The data are available in both Excel and SPSS format at www.cengage brain.com. Search for this book and then select the tab "Free Materials" and "Access Now" to view.

Transcribed Image Text:

Coefficients Unstandardized Coefficients Standardized Coefficients Model Std. Error 25.984 004 Beta (Constant) CASES Sig. 3.348 010 985 5.98 000 B7.000 6.545E02 Dependent Variable: TRANCOST