Build a portfolio optimization system

Assignment Help Basic Statistics
Reference no: EM13138184

The exercise is to build a portfolio optimization system that can display efficient frontiers to a decision maker.  As this includes many repetitive tasks, one should try to automate them with macros as much as possible.

Content-wise, the project involves

  • Retrieval of price data
  • Calculation of covariance matrix and historical mean return
  • Minimum of 20well distributed points used to characterize efficient frontier
  • Display efficient frontier
  • Table describing each portfolio option, the associated expected return and the portfolio standard deviation
  • Bonus:
    • Allow re-runs with different numbers of points, different forecasted returns, and maybe even different constraint right hand sides
    • option to override historical mean returns with forecasted returns that may be different

For good results, you probably need to work with 20 or more securities.  Try to include in your model realistic-type sector, industry, and upper bound constraints, but don't make them too tight.

Reference no: EM13138184

Questions Cloud

Is homosexuality biologically-psychology : Describe and evaluate the reasoning used in the positions to address this issue and describe how this topic impacts our society, and what citizens can do to resolve it.
Make it sound better : I am writing to petition for reinstatement at XXX University. I have been placed on academic suspension since fall 2012 quarter due to my failure in maintaining above a 2.0 cumulative GPA.
Paraphrase in a couple of sentences : The New Jim Crow by Michelle Alexander that all people make mistakes. All of us violate the law at some point in our lives. In fact, if the worst thing you have ever done is speed ten miles over the speed limit on the freeway
Use excel to find the right-tail p value : Faced with rising fax costs, a firm issued a guideline that transmissions of ten pages or more should be sent by two-day mail instead. Exceptions are allowed, but they want the average to be ten or below. Use Excel to find the right-tail  p  value
Build a portfolio optimization system : For good results, you probably need to work with 20 or more securities.  Try to include in your model realistic-type sector, industry, and upper bound constraints, but don't make them too tight.
Quackity quack company''s ad states that its product is : Quackity Quack Company's ad states that its product is "the best on the market today." Because of this ad, the Federal Trade Commission is most likely to
Adjustment to reconcile net income : When preparing a statement of cash flows (indirect method), which of the following is not an adjustment to reconcile net income to net cash provided by operating activities?
Basics of managerial purposes and decisions : The CEO of your company has asked you to prepare a written presentation to be given at the next board of directors meeting on why different types of cost information need to be reported to support different managerial purposes and decisions. In a ..
Administrative expenses and operating income : No additional fixed manufacturing overhead will be incurred because of this order. The only additional selling expense on this order will be a $0.50 per unit shipping cost. There will be no additional administrative expenses because of this order...

Reviews

Write a Review

 

Basic Statistics Questions & Answers

  Width of confidence interval and hypothesis testing

The width of a confidence interval is equal to twice the value of the margin of error. Explain your answer. What is the first step in hypothesis testing?

  Z-cutoff values for the rejection region

A company is filling bags of rock salt to a level of 50 pounds. It believes that all bags are filled correctly, but would like to use a hypothesis test with an alpha of 0.05 to check this belief.

  Information about upper and lower control limits

A particular magazine typically has 65% subscription renewals. A new advertising campaign is introduced to see if this can be increased. To monitor renewals, a sample of 300 subscribers is taken each month to see what percentage renew their subscr..

  Formulate and test appropriate set of hypotheses

Formulate and test an appropriate set of hypotheses to determine if the machine can be qualified. Use a = 0.05. Find the P-value.

  Filling an aquarium tank

An aquarium tank can hold 7700 liters of water. There are two pipes that can be used to fill the tank. The first pipe alone can fill the tank in 77 minutes.

  Estimate the population mean with ninety percent confidence

Determine the sample size necessary to estimate a population mean to within 1 with a 90% confidence given that the population standard deviation is 10, Suppose that the sample was calculated at 150. Estimate the population mean with 90% confidence..

  Give z statistic and p-value for value obtained by census

Probability of selecting a household with no children that is equal to the value obtained by the census. Give the z statistic (rounded to two decimal places) and the P-value. What do you conclude?

  Relative frequency distribution

Construct a relative frequency distribution for the weights of regular Coke by starting the first class at 0.7900 lb. and use a class width of 0.0050 lb.

  Confidence interval and hypothesis testing in statistics

A sample of 25 MBA students taking OTM course in the Spring of 2013 shows an average income of $85,000 with the sample standard deviation of $5,000. Find the 95% confidence interval of the population mean income of MBA students.

  Find probability that consumer uses a plastic card

Given the consumer is 18 to 24 years old, what is the probability that the consumer uses a plastic card? Given the consumer is over 24 years old, what is the probability that the consumer uses a plastic card?

  Estimate the protection of retired voters

The country clerk wants to estimate the protection of retired voters who will need special election facilities. suppose a sample of 400 retired voters was taken. If 150 special election facilities, calculate an 80% confidence for the population pr..

  Using original data and estimate population standard

Using the original data, estimate the population standard deviation with 90% probability.

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