supermarket chain interested exploring relationship between sales 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


Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount!
Use Discount Code "Newclient" for a 15% Discount!

NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.