Question: For 12 straight weeks, you have observed sales (in the number of cases) of canned tomatoes at Mr. Ds Supermarket. Each week, you keep track

For 12 straight weeks, you have observed sales (in the number of cases) of canned tomatoes at Mr. D’s Supermarket. Each week, you keep track of the following:

Was a promotional notice for canned tomatoes placed in all the shopping carts?

Was a coupon for canned tomatoes given to each customer?

Was a price reduction (none, 1, or 2 cents off) given?

Use this data to determine how the preceding factors influence sales. Predict the sales of canned tomatoes during a week in which you use a shopping cart notice, a coupon, and reduce the price by 1 cent.

Cart Week Notice? Coupon? 1 Yes 2 Yes 3 Yes 4 Yes

Cart Week Notice? Coupon? 1 Yes 2 Yes 3 Yes 4 Yes 5 Yes 6 Yes 7 No 8 No 9 No 10 No 11 No 12 No Yes Yes Yes No No No Yes Yes Yes No No No Price Reduction? 0 1 2 0 1 - NOTNOT2 0 1 0 1 Sales 36 38 40 40 42 44 12 20 30 8 16 33

Step by Step Solution

3.34 Rating (169 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

To analyze the data and determine how the factors of promotional notice coupon and price reduction i... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Microsoft Excel Data Analysis 7th Questions!