Question

Kohl’s wishes to investigate the relationship between level of advertising, coupon value and sales. Kohl’s advertises several times a month and includes a coupon (in dollars) with each advertisement. The value of the coupon remains the same in a month but varies from month to month. Kohl’s expects that the number advertisements and coupon value have a positive impact on sales. In addition, Kohl’s expects that the impact of advertisements increases as the coupon value increases. Kohl’s collects the sales (in thousands of dollars), number of ads and coupon value for the last one year. The data is in Kohls.sav. Express the model that the company must use, state the null and alternate hypothesis, estimate the model and provide interpretation. When the manufacturer advertises 5 times in a month and includes a $3 coupon, what is the expected sales? Please show me you SPSS Data.

Sales   Ads   CouponValue
110.54   3   4
209.83   13   2
256.74   13   3
157.86   13   1
174.32   8   3
208.69   13   4
178.57   15   1
89.34   3   3
71.58   3   2
295.77   15   3
100.65   8   1
239.03   15   2

Answer 1

The hypothesis is

H0: The model is not significant
H1: The model is signficant

FROM REGRESSION OUTPUT

predicted sales=-36.513+13.992(number of Ads)+28.416(Dollar value of coupon)

y intercept=-36.513

slope for number of Ads=13.992

slope for dollar value of coupon=28.416

Here number of Ads=5

dolalr value of coupon=3

Expected sales=-36.513+13.992(5)+28.416(3)

=118.695