Question: A supermarket chain is interested in exploring the relationship between the sales of its store-band canned vegetables (y), the amount spent on promotion of the
A supermarket chain is interested in exploring the relationship between the sales of its store-band canned vegetables (y), the amount spent on promotion of the vegetables in local newspapers (x1) and the amount of shelf space allocated to the brand (x2). One of the chain's supermarkets was randomly selected, and over a 20 week period, x1 and x2 were varied, as reported in the data below.
Present the regression model for the dependent variable and calculate the projection for the next period.
WeekSalesAdExpShelfSpc
1201020175
2185020550
3240035575
4157520830
5355059075
6201539750
7390882075
8187040030
9487799775
10219051530
11500599675
122500 62550
13300586050
143480101250
155500113575
16199563530
17239083730
184390120050
19278599030
202989120530
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
