logo

Marketing Research, Fall 2016.

2 Pages281 Words451 Views
   

Added on  2019-09-16

Marketing Research, Fall 2016.

   Added on 2019-09-16

ShareRelated Documents
Marketing Research, Fall 2016Assignment 3SPSS CaseYou can locate the database on the Blackboard: Assignments-> Assignment 3-> BIOBLANCDue Date is Wednesday, 30 November 2016 (at the beginning of class)Barossa Winery is a major wine producer company in the region of South Australia. The company wouldlike to forecast the sales of one of its products, BIOBLANC (a top quality white wine). Data werecollected during the 30 previous periods (where on period comprises 4 consecutive weeks).The data concern the 4 following variables:Y denotes the total demand for this product ( in 10,000 one-liter bottles)X1 denotes the price of the product (1-liter bottle) during the periodX2 denotes the average price of the competing products during the periodX3 denotes the advertising budget (in 1,000 euros) spent on BIOBLANC during the periodQuestions1. Use simple linear regression to estimate the relationship between the dependent variable Y and eachof the 3 independent variables. Which of these relationships is "best" for predicting the sales in period31?2. Can you improve the model using multiple regression? (Hint: other variables can be considered; X4=X2-X1; X5=((X2-X1)/X1)x100; and X6=X23). Which model do you propose?3. Based on results for question2, estimate the total demand for BIOBLANC if, for period 31, X1=$39,X2=$40, and X3=$50K. The small Database is printed on next page
Marketing Research, Fall 2016._1

End of preview

Want to access all the pages? Upload your documents or become a member.

Related Documents
The Sales Forecast of a Multinational Company BMW
|11
|1054
|146

Regression Analysis Assignment for Fall 2018
|2
|816
|349

QUAN102 - Statistics In Business Assignment
|7
|1209
|67

OLS Regression Model for Estimating Unknown Coefficients
|10
|2238
|406

Business Mathematics Assignment PDF
|10
|1531
|412

Modelling Per Capita GDP - PDF
|16
|2236
|46