How should your investment in each asset

Assignment Help Applied Statistics
Reference no: EM131406699

1. 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 thestandard deviation of your portfolio to exceed 0.015.

b. Also, it will be better to use Method 2 (do you know why?).

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

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

Attachment:- Question - Data.xlsx

Verified Expert

This has been solved in excel and reverted back in word. This is based on portfolio optimization model . This is original work and there is no plagiarism . I have attached the excel file for all the formulas which are already present.

Reference no: EM131406699

Questions Cloud

How can you improve your leadership power and influence : Reflecting on what you have read and seen and your self-assessment of leadership ability, how can you improve your leadership power and influence?
What can you do now to integrate the experiences : What can you do now to integrate the experiences and insights you had in this course with your personal and professional development goals?
Complement to represent negative numbers : Add (-8) + (-7) in binary using 2's complement to represent negative numbers. Use a word length of 5 bits (including sign). Indicate if an overflow occurs. Enter your answer in the answer box, attach a Word or PDF file of your work in binary. Full..
What you know about human needs to build a bridge : You are a counselor in a rural area. Your supervisor asks you to visit the home of a child who has become violent. The mother states that the father is a strict disciplinarian. He uses a belt to whip the kids when they do not do what is expected o..
How should your investment in each asset : How should your investment in each asset (i.e., a, b, c) change if you do not wantthe standard deviation of your portfolio to exceed 0.013?
Internet search on the big o of hash functions : Perform and Internet search on the Big O of hash functions and discuss your findings. We have said that the Big O is (1) if there are no collisions, and to account for searching due to collisions
How you have either developed a brand loyalty : How can a salesperson convert new customers into highly committed customers for life? Give specific examples of how you have either developed a brand loyalty.
Describe the function of the mechatronic system : Describe the function of the mechatronic system and its significance to society. How does the mechatronic system improve upon the previous state of the art
Implications of using a smartphone for work : Consider the implications of using a smartphone for work. What are some of the advantages and disadvantages? Is it ethical for employees to be contacted outside of work hours? Defend your answers.

Reviews

inf1406699

3/8/2017 4:05:17 AM

this will include the answers on the word document as well as the excel spreadsheet being completed? Thank you. I need to know how you calculated the data for part a. I have part c. Can you please send? This would be in reference the excel spreadsheet... I need both parts a and c calculated, please. Let me know what the cost would be for the calculated sheets for both answers. 21374940_121374912 1Solution.xlsx in part a we have to maximize the sum of investments or the proportion of investment multiplied by the expected return from the asset , which is mean of the return, so it is just the sum of coefficient time the mean return which is calculated as the average of the returns. Now to we have to put the constraints, so we calculate the standard deviation of the above sum using the simple expansion of variance and individual variance can be easily calculated, i have already put the formulas in excel. So using the solver in data analysis we can put the restrictions on them, and solve for part a . Also for part c you just have to change the restriction.

len1406699

2/27/2017 5:11:05 AM

I need assistance with this stats problem. It is using solver with excel and need may need direction after answering the question so that I can learn.

Write a Review

Applied Statistics Questions & Answers

  Hypothesis testing

What assumptions about the number of pedestrians passing the location in an hour are necessary for your hypothesis test to be valid?

  Calculate the maximum reduction in the standard deviation

Calculate the maximum reduction in the standard deviation

  Calculate the expected value, variance, and standard deviati

Calculate the expected value, variance, and standard deviation of the total income

  Determine the impact of social media use on student learning

Research paper examines determine the impact of social media use on student learning.

  Unemployment survey

Find a statistics study on Unemployment and explain the five-step process of the study.

  Statistical studies

Locate the original poll, summarize the poling procedure (background on how information was gathered), the sample surveyed.

  Evaluate the expected value of the total number of sales

Evaluate the expected value of the total number of sales

  Statistic project

Identify sample, population, sampling frame (if applicable), and response rate (if applicable). Describe sampling technique (if applicable) or experimental design

  Simple data analysis and comparison

Write a report on simple data analysis and comparison.

  Analyze the processed data in statistical survey

Analyze the processed data in Statistical survey.

  What is the probability

Find the probability of given case.

  Frequency distribution

Accepting Manipulation or Manipulating

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