For several consecutive weeks you have observed the sales
Ask Expert

Be Prepared For The Toughest Questions

Practice Problems

For several consecutive weeks you have observed the sales

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.

Hint
Statistics"regression equation:sales = 14.04 + 20.16*cart_notice_yes - 1.167*coupon_yes + 6.375*price reductionthe adjusted R square value = 0.8402. there is 84% variation in the sales which is explained by all signficant independent variables in the model. "...

Know the process

Students succeed in their courses by connecting and communicating with
an expert until they receive help on their questions

1
img

Submit Question

Post project within your desired price and deadline.

2
img

Tutor Is Assigned

A quality expert with the ability to solve your project will be assigned.

3
img

Receive Help

Check order history for updates. An email as a notification will be sent.

img
Unable to find what you’re looking for?

Consult our trusted tutors.

Developed by Versioning Solutions.