Basic Marketing Research 8th Edition by Tom Brown,Tracy Suter,Gilbert Churchill

Exercise 16

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:

a Dependent Variable: TRANCOS -
R 2 = 0.970
Thus, the regression equation is
Y = 0.065 X + 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.cengagebrain.com. Search for this book and then select the tab "Free Materials" and "Access Now" to view.