Reference no: EM131337005
Assignment:
1. Run a regression of the natural logarithm of sales on all the following: price, print marketing expenditure, outdoor marketing expenditure and previous years' sales.
2. Run a regression of the natural logarithm of change in sales on the natural logarithm of previous period's prices and the natural log of marketing expenditures on print, outdoor and broadcasting.
3. To understand the influence of vodka quality, run a regression by adding the tier 1 and tier 2 dummy variables (that indicate whether a vodka brand belongs to first or second quality tiers) to the set of independent variables in questions 2.
4. To understand the influence of competition and brand power, run a regression by adding the sum of sales of all the competing brands in the previous year ("lagtotalminussales") to the independent variables in question 3.
5. To measure the sales growth of new brands compared to the existent ones, include the variable "firstinto" to the independent variable set in question 4. Firstinto is equal to one in the first three years after a brand is introduced and is zero elsewhere.
6. Why does the co-efficient of price and advertising change in the above regressions?
Credit would be given to interesting insights which may not be obvious. For example, reduction in price results in increase in sales which may not be true for premium vodka brands.
2. The report should contain the following sections:
(a) Problem Objective
(b) Data Exploration
(c) Analysis and Discussion
(d) Regression Results
(e) Analysis and Discussion
The excel file to be included along with the word file.
Attachment:- Assignment.rar
|
Your financial situation and plans
: Reflect on all that you have learned in this course. Summarize your financial situation and plans. Be sure to include plans for budgeting, saving, debt and credit, taxes and insurance, investing, retirement and estate planning. Additionally, descr..
|
|
Estimate the trend component of monthly demand
: A manager of a store that sells and installs spas wants to prepare a forecast for January, February, and March of next year. Her forecasts are a combination of trend and seasonality. She uses the following equation to estimate the trend component ..
|
|
Estimate the heat flux using an appropriate free convection
: Repeat the calculation for a horizontal, 7-m-diameter wire at the same excess temperature. What can you say about the general applicability of Figure 10.4 to all situations involving boiling of water at 1 atm?
|
|
Does the paper meet minimum length requirements
: Does the paper fully address all aspects of the assignment? Is the assignment addressed accurately and precisely using sound logic? Does the paper meet minimum length requirements?
|
|
Run a regression of the natural logarithm of sales
: Run a regression of the natural logarithm of sales on all the following: price, print marketing expenditure, outdoor marketing expenditure and previous years' sales
|
|
According to the interview with clarence page
: How, according to the interview with Clarence Page, did the concept of objectivity come about?How does Richard Campbell explain objectivity of lack of it?Do you expect journalists to be objective? Are you objective?What standard can we use, if we ..
|
|
Determine the firms optimal capital structure
: Suppose that the firm's current capital structure consists of 30 percent debt (and 70 percent equity). How much higher is its weighted cost of capital than at the optimal capital structure?
|
|
Describe the desired behavior you would like rad to achieve
: Determine Appropriate Reinforcers. Define reinforcers, and explain the reinforcers that you have selected for the desired behavioral outcome for Rad. Include the primary reasons why the selected reinforcers are appropriate for Rad, you (the Instru..
|
|
Discuss the frequency of usage and security
: E-COMMERCE (COMP 1008) Discuss the frequency of usage and security can impact successful E-Commerce Transactions with in Oman and Propose recommendations to eliminating the barriers in adapting to e-banking.
|