Answer Happy

A consumer packaged goods company puts out several
advertisements every month in the local newspaper and includes a
discount coupon with the advertisements. The company has collected
data on the number of advertisements it ran for the last 12 months
as well as the dollar value of the coupon offered in each of the
last 12 months. The sales (in thousands of dollars) is also
recorded. The company wishes to investigate the impact of
advertising and coupon value on sales. The company suspects that
advertising and coupon value have a positive impact on sales.
Express the regression model that the company must use, state the
null and alternate hypothesis, estimate the model and provide
interpretation. Given the results of your estimation, what are the
expected sales in a month where 8 advertisements were put out using
a $3 coupon.
(Please post how you ran the data in spss!)
Sales | Ads | Coupon Value
58.00 2.50 4.17
87.00 12.50 1.67
145.00 12.50 3.33
58.00 12.50 .83
72.50 7.50 2.50
203.00 12.50 4.17
101.50 15.00 .83
43.50 2.50 2.50
29.00 2.50 1.67
116.00 15.00 2.50
43.50 7.50 .83
87.00 15.00 1.67