The price of the “Spirit of the Devil” brand beer fluctuates from month to month due to the change in raw material price

[answerhappygod]

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
(Please post how you ran the data in spss!)
Sales | Price | Ads
159.14 .80 13
33.08 .75 3
156.04 .90 13
93.86 1.00 8
27.02 1.10 3
130.69 1.00 11
104.17 1.20 9
117.84 1.25 10
32.88 .90 3
145.77 1.50 12
91.65 1.00 8
94.03 1.25 8