Use Excel, MegaStat, or Minitab to perform a regression analysis of the Bonner Frozen Foods sales volume data in Table 14.5 on page 599 by using the model y = β₀+ β₁x₁+ β₂x₂+ β₃x₁x₂+ ε.

Table 14.5

a Determine if the interaction term x₁x₂ is important in the model.
b Find (1) a point estimate of and a 95 percent confidence interval for the mean sales volume in all sales regions when $2,000 is spent on radio and television advertising and $5,000 is spent on print advertising and (2) a point prediction of and a 95 percent prediction interval for the sales volume in an individual sales region when $2,000 is spent on radio and television advertising and $5,000 is spent on print advertising.

Transcribed Image Text:

х, y 3.27 8.38 11.28 14.50 1. 19.63 5.84 10.01 12.46 16.67 19.83 8.51 10.14 14.75 17.99 19.85 9.46 12.61 15.50 4 17.68 21.02 12.23 13.58 16.77 4 20.56 21.05