For several consecutive weeks you have observed the sales (in number of cases) of canned tomatoes at Mr. D’s supermarket. Each week you kept track of the following:

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

■ Was a coupon given for canned tomatoes?

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

The file P11_38.xlsx contains these data.

a. Use multiple regression to determine how these factors influence sales.

b. Discuss how you can tell whether autocorrelation, heteroscedasticity, or multicollinearity might be a problem.

c. Predict sales of canned tomatoes during a week in which Mr. D’s uses a shopping cart notice, a coupon, and a one-cent price reduction.

Answer rating: 100% (QA)

Consider the sales data collected at Mr Ds supermarket Specifically sales of canned tomatoes ar... View the full answer