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 .

I am working through this question and having trouble getting the coefficients table to work.

The data is:

Sales in thousands of dollars (1st Column) Price in dollars(2nd Column) Number of Ads Placed (3rd Column)

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

Would love to see it in SPSS or Excel.

This is what it is showing me with Excel, but I am seeing different results from my classmates and I am wondering where I am going wrong:

SUMMARY OUTPUT

Regression Statistics

Multiple R 0.999191

R Square 0.998383

Adjusted R Square 0.998023

Standard Error 2.09591

Coefficients Intercept -4.79687 X Variable 1 -2.87032 X Variable 2 12.67368