Recall from Exercise 14.5 that Enterprise Industries has observed the historical data in Table 14.5 concerning y (demand for Fresh liquid laundry detergent), x1 (the price of Fresh), x2 (the average industry price of competitors' similar detergents), and x3 (Enterprise Industries' advertising expenditure for Fresh). To ultimately increase the demand for Fresh, Enterprise Industries' marketing department is comparing the effectiveness of three different advertising campaigns. These campaigns are denoted as campaigns A. B. and C. Campaign A consists entirely of television commercials, campaign B consists of a balanced mixture of television and radio commercials, and campaign C consists of a balanced mixture of television, radio, newspaper, and magazine ads. To conduct the study. Enterprise Industries has randomly selected one advertising campaign to be used in each of the 30 sales periods in Table 14.5. Although logic would indicate that each of campaigns A, B, and C should be used in 10 of the 30 sales periods. Enterprise Industries has made previous commitments to the advertising media involved in the study. As a result, campaigns A, B, and C were randomly assigned to. respectively, 9, 11, and 10 sales periods. Furthermore, advertising was done in only the first three weeks of each sales period, so that the carryover effect of the campaign used in a sales period to the next sales period would be minimized. Table 14.12 lists the campaigns used in the sales periods.
To compare the effectiveness of advertising campaigns A, B, and C, we define two dummy variables. Specifically, we define the dummy variable DB to equal 1 if campaign B is used in a sales period and 0 otherwise. Furthermore, we define the dummy variable A), to equal l if campaign C is used in a sales period and 0 otherwise. Figure 14.21 presents the Excel add-in (MegaStat) output of a regression analysis of the Fresh demand data by using the model
y = β0 + β1x1 + β2x2 + β3x3 + β4D4 + β5DC + ε
FIGURE 14.21
Excel Output of a Dummy Variable Regression Model Analysis of the Fresh Demand Data
Continue Next Page

a. In this model the parameter β4 represents the effect on mean demand of advertising campaign B compared to advertising campaign A. and the parameter β5 represents the effect on mean demand of advertising campaign C compared to advertising campaign A. Use the regression output to find and report a point estimate of each of the above effects and to test the significance of each of the above effects. Also, find and report a 95 percent confidence interval for each of the above effects. Interpret your results.
b. The prediction results at the bottom of the output correspond to a future period when Fresh's price will be x1 = 3.70, the average price of similar detergents will be x2 = 3.90, Fresh's advertising expenditure will be x3 = 6.50, and advertising campaign C will be used. Show (within rounding) how y = 8.61621 is calculated. Then find, report, and interpret a 95 percent confidence interval for mean demand and a 95 percent prediction interval for an individual demand when x1 = 3.70, x2 = 3.90, x3 = 6.50. and campaign C is used.
c. Consider the alternative model
y = β0 + β1x1 + β2x2 + β3x3 + β4D4 + β5DC + ε
Here DA equals 1 if advertising campaign A is used and equals 0 otherwise. Describe the effect represented by the regression parameter B5.
d. The Excel output of the least squares point estimates of the parameters of the model of part c is as follows.

Transcribed Image Text:

Regression Statistics Multiple R R Square Adjusted R Square Standard Error Observations 0.9797 0.9597 0.9513 0.1503 30 ANOVA Regression Residual Total sS 12.9166 0.5420 13.4586 Coefficients Standard Error df MS F 2.5833 114.3862 Significance F 6.237E-16 24 29 tStat 5.4989 .1821E-05 -6.6790 6.5789E-07 8.7110 6.7695E-09 6.1100 2.6016E-06 3.8804 6.2496 1.8506E-06 P-value Intercept Price (X1) Ind Price (X2) AdvExp (X3) DB DC 8.7154 2.7680 1.6667 0.4927 0.2695 0.4396 1.5849 0.4144 0.1913 0.0806 00695 0.0703 Lower 95% 5.4443 3.6234 1.2718 0.3263 0.1262 0.2944 Upper 95% 11.9866 -1.9127 2.0616 0.6592 0.4128 0.5847 0.0007 Predicted values for: Demand using an Excel add-in (MegaStat) 95% Confidence Interval Predicted 8.61621 lower 8.51380 upper 8.71862 95% Prediction Interval upper 8.94285 Leverage 0.109 lower 8.28958 Intercept Price (X1) Ind Price (K2) AdvExp (X3) DA DC Coefficients 8.9849 2.7680 1.6667 0.4927 0.2695 0.1701 Standard Error 1.5971 0.4144 0.1913 0.0806 0.0695 0.0669 t Stat 5.6259 6.6790 8.7110 6.1100 -3.8804 2.5429 P-value 8.61E-06 6.58E-07 6.77E-09 2.60E-06 0.0007 0.0179 Lower 95% 5.6888 3.6234 1.2718 0.3263 0.4128 0.0320 Upper 95% 12.2811 1.9127 2.0616 0.6592 0.1262 0.3081