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

  What is the current average rate of unemployment

Topic: A REVIEW OF THE RATE OF UNEMPLOYMENT IN THE UNITED STATES: ARE WE WINNING THE WAR? What is the current average rate of unemployment? At what legally allowed age is the number of unemployed person highest

  The average weekly earnings of the plumbers in a city

The average weekly earnings of the plumbers in a city is [Mu=$750] with a standard deviation of [s=$40]. Assume that we select a random sample of [n=64 plumbers], what is the probability that the sample mean [x] will be greater than $740 or greater t..

  Explain has the fit of the model improved

Construct a scatterplot for the data. Locate the data point for Botulism on the graph. What do you observe?- Repeat part a, but omit the data point for Botulism from the analysis. Has the fit of the model improved? Explain.

  Descriptive statistics and regression equations

Use excel to generate scatterplots, descriptive statistics, and regression equations.An additional observation at the bottom of the data file, needs to be added to the dataset. You should clearly mark on the Excel or Minitab file, which dataset (enti..

  Prepare a critical analysis of a quantitative study

Prepare a critical analysis of a quantitative study focusing on protection of human participants data collection data management and analysis problem statement and interpretation of findings

  The distribution of chi-square values

The distribution of chi-square values is NOT normally distributed. True or False

  Construct a frequency distribution of grouped scores

Construct a frequency distribution of grouped scores with approximately 11 intervals.- Construct a histogram of the frequency distribution constructed in part a.

  Find the probability that the store will meet its goal

Find the probability that the store will meet its goal during a particular week. Find the probability that the store will not meet its goal during a particular week.

  Describe the variables implicit in given items

A survey by an electric company contains questions on the given:- Describe the variables implicit in these 11 items as quantitative or qualitative, and describe the scales of measurement

  Test hypothesis - all five categories have same probability

For a one-way contingency table, the following frequencies are observed: 23, 34, 43, 53, 16. Using α = .01, test the hypothesis that all five categories have the same probability.

  An investor has the following investment portfolio

An investor has the following investment portfolio Z = a1X + a2 Y with a1 + a2 = 1. Where X and Y are random rate of returns of assets X and Y respectively and μx= μy = μ, σx = σy = σ. Assuming that these random variables are not independent find the..

  Working memory capacity and comprehension performance

The scores for each participant's working memory performance and comprehension task performance are shown on the right. Is there a relationship between working memory capacity and comprehension performance?

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