What is the marginal impact of advertising on sales

Assignment Help Other Subject
Reference no: EM132234485

Question 1. All fund managers fall into two groups (stars and non-star managers). The probability that a star will beat the market in any given year is 80%. Non-star managers are just as likely to beat the market as they are to underperform it. Of a given pool of managers, only 10% turn out to be stars.

a. What is the probability that a manager beats the market in a given year?

b. What is the probability that the manager is a star if (s)he beats the market?

c. What is the probability that the manager is a star if (s)he beats the market 5 years in a row?

Note: their probability of beating the market in one year is independent of the prior year.

Question 2. You have been provided with data for Sales and Advertising. Assume there are no outliers in the data.

a. Estimate this model using regression analysis...

Sales = β0 + β1*advertising + β2*advertising2

• State the hypothesis that tests if a non-linear relationship exists between Sales and Advertising.
• Based on your regression analysis what is your conclusion? Give reason.

b. What is the marginal impact of advertising on sales if advertising is increased from $1500 to $1600? What is the marginal impact on sales if advertising is increased from $2400 to $2500? Please comment on any differences.

c. Is there a lead/lag relationship between Advertising and Sales? That is, estimate this model ...

Salest = β0 + β1*advertisingt + β2*advertisingt2 + β3*advertisingt-1

What is your conclusion? Give reason.

Question 3. As an investor you are studying the stock returns for Yahoo (YHOO), Google (GOOG) and Adobe Systems (ADBE). You are convinced that daily returns on all these assets are normally distributed.

You have collected one year of historical stock returns for all three companies (see data provided.) You want to build an investment portfolio with your money divided between just these three stocks.

Portfolio P = a*(YHOO) + b*(GOOG) + c*(ADBE)

a) Using historical returns, find the fraction of your investment in each stock (i.e., a, b, c) to maximize your return. You are risk averse, so you do not want the standard deviation of your portfolio to exceed 0.015.

Hints (from your kind and caring Professor): (1) You cannot invest more money than you have. (2) Also, it will be better to use Method 2 (do you know why?).

b) How should your investment in each asset (i.e., a, b, c) change if you do not want the standard deviation of your portfolio to exceed 0.013?

c) Based on above results can you tell which stock is more volatile? Explain.

Question 4. Consider two SPDR ETFs, SPY and GLD. It is known that both assets are normally distributed with an average return for SPY of 10% and an average return for GLD of 7%. It is known that the standard deviation of SPY is 8% and the standard deviation of GLD is 12%. As you would expect, the asset classes represented by SPY and GLD are independent. Create a Monte Carlo simulation that estimates P(SPY < GLD). Write the answer below.

Note: Let the simulation size be 2000 each for both SPY and GLD; for SPY use a random seed of 16 and for GLD use a random seed of 32.

Question 5. Visual Basic For Applications (VBA)

a) Create a function using VBA in Excel called Square that calculates the square of any number. For example, when I open your spreadsheet and type this in any cell: =square(5)

It should give me the result of 25.

b) Write a subroutine using VBA in Excel called SquareIt that calculates the square of numbers from 1 to 20 and writes them in cells A1, A2, ... , A20. (Use a For loop in your VBA code to do this).

Assign this subroutine to a button labeled SquareIt on your spreadsheet so I can simply click it to run your subroutine.

Verified Expert

User-Defined VBA Function & Sub Procedures. In Excel Visual Basic, a set of commands to perform a specific task is placed into a procedure, which can be a Function procedure or a Sub procedure (also known as functions and subroutines)

Reference no: EM132234485

Prostitution and drug charges

Lila D. has just successfully completed her year in the drug court program. She is 28 years old and had been arrested for prostitution and drug charges.

Who do not merit the same treatment by our legal system

Industry knowledge suggests that some terrorists should be classified as enemy combatants who do not merit the same treatment by our legal system as a typical criminal. Defe

Discuss relationship between time and frequency in signals

Discuss the relationship between time and frequency in signals.  What are some differences between the time-domain and the frequency-domain.? Discuss what is meant by the phra

Analyzing a mixture for penicillin

You are analyzing a mixture for penicillin. To the mixture you add 10.0 mg of doped penicillin with a specific activity of 0.405 μCi/mg. From this mixture, you isolated only 0

How would you prevent common barriers to creativity

Imagine you are in a position to influence the level of creativity in a work group for increasing employee morale or a community group working to encourage recycling. How wo

Write a summary of juvenile arrests 2008 article

Write a paper summarizing the key points of the "Juvenile Arrests 2008" article. Address the following in your paper:The overall decrease in juvenile arrests.The increase in

What is descartes second argument for dualism

What is Descartes' first argument for dualism? Explain. (Remember that you are supposed to indicate what the reasoning is for any question that asks what the argument for s

Explain emergency medical treatment

From the patient perspective discusses Emergency Medical Treatment and Labor Act and its advantages and disadvantages. Moreover, from patient perspective, discuss if you bel



2/14/2019 9:09:51 PM

Instructions 1. Please make sure to write your full name on top of the test. 2. This test is to be completed individually as a take-home test and is worth a total of 40 points (40% of final grade.) 3. If you use Excel to solve a problem you still need to record the final answer in the paper copy of the test. 4. Scan your completed test and email it me. To receive credit for your spreadsheet work

Write a Review

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd