Recall from Exercise 14.6 that Enterprise Industries has observed the historical data in Table 14.6 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.6. 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 DC to equal 1 if campaign C is used in a sales period and 0 otherwise. Figures 14.20 and 14.21 present the Excel and Jamovi outputs of a regression analysis of the Fresh demand data by using the model: y = Bot Bix, + Baxz + Byx3 + BADB + BSDc + E a Because this model does not use a dummy variable to represent advertising campaign A, the parameter S, represents the effect on mean demand of advertising campaign 8 compared to advertising campaign A, and the parameter Is represents the effect on mean demand of advertising campaign C compared to advertising campaign A. (1) 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. (2) Find and report a 95 percent confidence interval for each of the above effects. (3) Interpret your results.b The prediction results in Figure 14.21 correspond to a future period when Fresh's price will be x =3.70. the average price of similar detergents will be x- = 3.90, Fresh's advertising expenditure will be x, = 6.50, and advertising campaign C will be used. (1) Show (within rounding) how 8.61621 is calculated. (2) Find, report, and interpret a 95 percent confidence interval for mean demand and a 95 percent prediction interval for an individual demand when x, = 3.70, x, - 3.90. x, = 6.50. and campaign C is used. c Consider the alternative model + But, + B.DA + BD+ s Here D, equals 1 if advertising campaign A is used and equals 0 otherwise. Because this model does not use a dummy variable to represent advertising campaign B. the parameter B, in this model represents the effect on mean demand of advertising campaign C compared to advertising campaign B. Use Excel, MegaStat, or Minitab to perform a regression analysis of the data in Tables 14.6 and 14.12 by using the alternative model. Use the computer output to (1) test the significance of the effect represented by B, and (2) find a 95 percent confidence interval for B. (3) Interpret your results.Price IndPrice PriceDif AdvExp Demand AdCamp DA DB DC X1 X2 X4 X3 Y 3.85 3.80 -0.05 5.50 7.38 B 3.75 4.00 0.25 6.75 8.51 B 3.70 4.30 0.60 7.25 9.52 B 3.70 3.70 0.00 5.50 7.50 3.60 3.85 0.25 7.00 9.33 3.60 3.80 0.20 6.50 8.28 3.60 3.75 0.15 6.75 8.75 3.80 3.85 0.05 5.25 7.87 3.80 3.65 -0.15 5.25 7.10 3.85 4.00 0.15 6.00 8.00 3.90 4.10 0.20 6.50 7.89 3.90 4.00 0.10 6.25 8.15 3.70 4.10 0.40 7.00 9.10 3.75 4.20 0.45 6.90 8.86 3.75 4.10 0.35 6.80 8.90 3.80 06060-464000-000-00-0000-0-000 4.10 0.30 90-0400060-40-4600060-00600-- - 6.80 8.87 3.70 4.20 0.50 7.10 9.26 3.80 4.30 0.50 7.00 9.00 3.70 4.10 0.40 6.80 8.75 3.80 3.75 -0.05 6.50 7.95 3.80 3.75 -0.05 6.25 7.65 3.75 3.65 -0.10 6.00 7.27 3.70 3.90 0.20 6.50 8.00 3.55 3.65 0.10 7.00 8.50 3.60 4.10 0.50 6.80 8.75 3.65 4.25 0.60 6.80 9.21 3.70 3.65 -0.05 6.50 8.27 3.75 3.75 0.00 5.75 7.67 3.80 3.85 0.05 5.80 7.93 3.70 4.25 0.55 6.80 9.26