For 12 straight 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_43.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.

  • CreatedApril 01, 2015
  • Files Included
Post your question