Description of Regression analysis in SPSS

See attached file.

The price of the 'Spirit of the Devil' brand beer fluctuates from month to month due to the change in raw material prices and other factors. The company that sells this beer also advertises several times a month. The company wishes to investigate the impact of price and advertising on beer sales and collects monthly sales data (in thousands of dollars), number of advertisements per month and the average monthly price of beer (in dollars). The company suspects that higher prices lead to lower sales and more advertising leads to greater sales. In addition, the company also expects that the negative impact of prices on sales is affected by the level of advertising such that higher levels of advertising may lower the negative effect of price. Express the regression model that the company must estimate to test their intuition, state the relevant hypothesis, estimate the model and provide interpretation. Given the results of your estimation, predict the beer sales when the company spends on 12 advertisements and prices the beer at $1.25. The data is in spirit.sav

Assume alpha=0.05 for all questions

Spss is needed to open data file.

Attachments

Solution Summary

Step by step method for Regression analysis in SPSS is given in the answer.