{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Assignment 2

# Assignment 2 - MKT 460 Spring 2010 Individual Assignment 2...

This preview shows pages 1–3. Sign up to view the full content.

MKT 460 Spring 2010 Individual Assignment 2 What Happens When Wal-Mart Comes to Town? (Due Date: 24 nd March, 2011) Please paste all the answers within this word file and upload it Blackboard by the due date. (Maximum possible points: 120) You have been hired as a consultant for a major local grocery store. Store management is worried since Wal-Mart has entered the market by opening a "Wal-Mart Super-center" only 3 miles away from the local store. Management is interested in analyzing the impact on store sales of the Wal-Mart entry and whether or not a new strategy is required. For analysis, management has given you access to one hundred weeks of sales data for the local store covering the period both pre- and post-entry of Wal-Mart. Look at the data in Data Assignment 2.xls. It has the following variables: WEEK  Week number  Sales   weekly sales Promotion Index Index of weekly promotion activity –higher promotion index indicates more  products on promotion in the store Walmart Walmart dummy = 1 in the weeks after the Walmart opens, and 0 in the  weeks before the Walmart opens Feature Advertising  Index Index of feature advertising activity – higher feature advertising index  indicates more feature advertising Holiday  Holiday Dummy = 1 during major holiday weeks, and 0 for non-holiday  weeks

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
Part 1. Estimate the following regression model: Create the appropriate variables. (10 points) log(sales) = α + β 1 log(promotion index) + 2 WalMart Paste results here. StatTools Report Analysis: Regression Performed By: May Date: Thursday, March 24, 2011 Updating: Static Multiple R-Square Adjusted StErr of Summary R R-Square Estimate 0.6434 0.4140 0.4019 0.22978832 9 Degrees of Sum of Mean of F-Ratio p-Value ANOVA Table Freedom Squares Squares Explained 2 3.61783986 4 1.80891993 2 34.2581 < 0.0001 Unexplained 97 5.12185960 8 0.05280267 6 Coefficient Standard t-Value p-Value Confidence Interval 95% Regression Table Error Lower Upper Constant 13.4767686 8 0.03279348 410.9588 < 0.0001 13.4116827 13.5418546 6 Walmart - 0.30255712 0.04637663
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

### Page1 / 6

Assignment 2 - MKT 460 Spring 2010 Individual Assignment 2...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document
Ask a homework question - tutors are online