# A supermarket chain is interested in exploring the relationship between the sales of its store-brand

Promotion of Supermarket Vegetables

A supermarket chain is interested in exploring the relationship between the sales of its store-brand canned vegetables (Y variable), the amount spent on promotion of the vegetables in local newspapers (X1 variable), and the amount of shelf space allocated to the brand (X2 variable). One of the chain’s supermarkets was randomly selected, and over a 20-week period X1 and X2 were varied. Develop the multiple regression model for predicting the sales that explains how advertising expenditures and shelf space influence sales. ( data info attached )

Study the problem “Promotion of Supermarket Vegetables” and download the data from PromotionsData.xlsx. (Available on BB9)

Form the following analysis of the data:

1) Construct the correlation matrix for the variables Sales, AdExp, and ShelfSpc

2) Run a multiple regression model with Sales as the dependent variable and AdExp and ShelfSpc as the independent variables (Model 1).

3) Run a multiple regression with Sales as the dependent variable and AdExp, SmallShelf, LargeShelf, SmallAdExp, and LargeAdExp as the independent variables (Model 2).

4) Remove insignificant variables from the model estimated in the previous step (Model 2) and re-run a multiple regression model (Model 3).

5) Compare the three estimated models and answer question

**Answers 1**

Purchase the answer to view it

**Other questions 10**

- Week 5 DQ
- HW
- CIS-505 week5 discussion 1
- Principles of Accounting II Assignment
- MGMT 640 Final Exam
- AMERICAN LITERATURE
- PSY/430 Week 2 Learning Team Assignment / Conflict Resolution
- Plan A is an all-common equity structure in which $2.2 million dollars
- I'm learning C++ here. I have a program I need completed. Here is the prompt:
- .

Promotion of Supermarket Vegetables

A supermarket chain is interested in exploring the relationship between the sales of its store-brand canned vegetables (Y variable), the amount spent on promotion …