econ project -- 48 hrs(-)
Marketing Research Project Analysis (due Dec. 7th, midnight)
If your student ID ends in an odd number, you will work with survey 1 (cars); if your student ID ends in
an even number, you will work with survey 2 (Uber) (the authors of the survey can work with the data
for their survey). Both the surveys and the excel files with the data are in the content folder.
First, you need to personalize your data file. Download the data file and modify it in the following way.
You will have to delete the first x observations (rows), where x is the penultimate (second from the end)
digit of your student number. So, if your student number ends with 35, you should delete the first 3
rows. If the penultimate digit of your ID is 0, do not delete any rows.
You will have to follow the same procedure you used for HW2 to merge the survey and the data file in
order to be able to run the clogit command in Stata.
You should produce a 2‐4 page report that contains the econometric analysis of the data, interpretation
of the results, and strategy suggestions. It should start with a description of your task, summary stats,
include the formulas for the regressions you are running, the tables with the estimated coefficients
(make them nice, not just copies of Stata output), the interpretation of these coefficients, and your
recommendations about how the business strategy should be adjusted based on these interpretations.
Try to make use of all data that is available to you and run multiple models.
For all questions related to the marketing project proposal, contact Sarah at [email protected]. Her office hours are on Monday, December 3rd, from 9:30 until 11:30 at ECON126.
Good luck!
Survey 1 (cars):
You are working for Porsche and are responsible for the introduction of a new car, Porsche 666, which is targeted to upper‐middle class consumers and will be priced in the 35,000‐45,000 range. Your task is to use the data from the survey to investigate how this car will perform against major competitors: BMW 3, Infinity Q 50, and Audi A4. You need to estimate consumers’ WTP for different brands and performance (measure by 0‐60mph time). What is the impact of consumer income and valuation of different brands? Finally, you need to issue a recommendation for the optimal strategy for introducing this car.
Survey 2 (Uber):
You have been hired by Uber to lead the project designed to better understand consumers preference with regard to self-driving cars. You need to determine whether it is desirable at this point to roll out a fleet of driverless cars and if so, how they should be priced. Use the data from the survey to estimate the consumer’s WTP for riding in a self-driving vehicle. Examine which consumer characteristics affect consumers’ choice and issue a recommendation to Uber.