8. For 12 straight weeks, you have observed the sales (in the number of cases) of...

Transcribed Image Text:

8. For 12 straight weeks, you have observed the sales (in the number of cases) of canned tomatoes at Mr. D's Supermarket. Each week, you keep track of the following information of your marketing activities: (a) Was an advertisement for canned tomatoes placed in all shopping carts? You use a variable to indicate if your canned tomatoes advertisement was placed in all shopping carts. That is, CartAD =1 if yes, CartAD = 0 if no. (b) Was a coupon for canned tomatoes given to each customer? You also use a variable to indicate if a coupon was issued in the respective week. That is, Coupon =1 if yes, Coupon = 0 if no. (c) Was a price reduction given? You use 1 to indicate 1 cent off, 2 to indicate 2 cents off...... and 0 if there was no price reduction given. To determine how these marketing activities influence sales, you have run a regression analysis using the data you collected and obtained regression analysis results as shown in tables below: Regression Statistics Multiple R 0.940 R Square 0.884 Adjusted R Square 0.840 Standard Error 5.045 Observations 12 df SS MS F Significance F Regression 3 18.953 4.738 4.258 0.00462 Residual 8 58.978 1.113 Total 11 77.931 Coefficients Standard Error t Stat P-value Intercept 24.042 3.089 4.545 0.002 CartAD 20.167 2.913 6.923 0.000 Coupon 30.487 2.566 0.401 0.699 PriceReduction 6.375 1.784 3.574 0.007 All the tests in this question are conducted under a significance level of 0.05. a) Which marketing activity is the most influential strategy on your canned tomatoes' sales? Provide the reason. (3 points) b) When there is no shopping cart in Mr. D's Supermarket available for placing your advertisement, how many cents off do you have to give so that you can achieve the same number of sales as placing a shopping cart advertisement. Please round to the nearest hundredth (two decimals). (3 points) 8. For 12 straight weeks, you have observed the sales (in the number of cases) of canned tomatoes at Mr. D's Supermarket. Each week, you keep track of the following information of your marketing activities: (a) Was an advertisement for canned tomatoes placed in all shopping carts? You use a variable to indicate if your canned tomatoes advertisement was placed in all shopping carts. That is, CartAD =1 if yes, CartAD = 0 if no. (b) Was a coupon for canned tomatoes given to each customer? You also use a variable to indicate if a coupon was issued in the respective week. That is, Coupon =1 if yes, Coupon = 0 if no. (c) Was a price reduction given? You use 1 to indicate 1 cent off, 2 to indicate 2 cents off...... and 0 if there was no price reduction given. To determine how these marketing activities influence sales, you have run a regression analysis using the data you collected and obtained regression analysis results as shown in tables below: Regression Statistics Multiple R 0.940 R Square 0.884 Adjusted R Square 0.840 Standard Error 5.045 Observations 12 df SS MS F Significance F Regression 3 18.953 4.738 4.258 0.00462 Residual 8 58.978 1.113 Total 11 77.931 Coefficients Standard Error t Stat P-value Intercept 24.042 3.089 4.545 0.002 CartAD 20.167 2.913 6.923 0.000 Coupon 30.487 2.566 0.401 0.699 PriceReduction 6.375 1.784 3.574 0.007 All the tests in this question are conducted under a significance level of 0.05. a) Which marketing activity is the most influential strategy on your canned tomatoes' sales? Provide the reason. (3 points) b) When there is no shopping cart in Mr. D's Supermarket available for placing your advertisement, how many cents off do you have to give so that you can achieve the same number of sales as placing a shopping cart advertisement. Please round to the nearest hundredth (two decimals). (3 points)