Ask a question to Desklib · AI bot
Marketing Research, Fall 2016.
Added on -2019-09-16
| 2 pages
| 281 words
| 451 views
Trusted by 2+ million users,
1000+ happy students everyday
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
Found this document preview useful?
You are reading a preview
Upload your documents to download
or
Become a Desklib member to get accesss
Paid Plans
Free Plan
Single Unlock
Monthly Plan
Yearly Plan