supermarket chain interested exploring relationship between sales its store brand

Do you require help with your paper? Use our custom writing service to achieve better grades and meet your deadlines. Trust our team of writing experts with your work today, and enjoy peace of mind.


Order a Similar Paper Order a Different Paper

 

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

 

"Is this question part of your assignment? We can help"

ORDER NOW
Writerbay.net

Do you need help with this or a different assignment? We offer CONFIDENTIAL, ORIGINAL (Turnitin/LopesWrite/SafeAssign checks), and PRIVATE services using latest (within 5 years) peer-reviewed journal articles. Kindly click on ORDER NOW to receive an A++ paper from our masters- and PhD writers.

Get a 15% discount on your order using the following coupon code SAVE15


Order a Similar Paper Order a Different Paper