For 12 straight weeks you have observed the sales (in number of cases) of canned tomatoes at

Question:

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 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 and a one-cent price reduction.

Coupon
A coupon or coupon payment is the annual interest rate paid on a bond, expressed as a percentage of the face value and paid from issue date until maturity. Coupons are usually referred to in terms of the coupon rate (the sum of coupons paid in a...