38. 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.
Students succeed in their courses by connecting and communicating with an expert until they receive help on their questions
Consult our trusted tutors.