Question: For 12 straight weeks you have observed the sales in

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.


View Solution:


Sale on SolutionInn
Sales3
Views180
Comments
  • CreatedApril 01, 2015
  • Files Included
Post your question
5000