Go Back   TechArena Community > Technical Support > Computer Help > Office Help > MS Office Support
Become a Member!
Forgot your username/password?
Register Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



I need help with plotting efficient frontier in Microsoft Excel

MS Office Support


Reply
 
Thread Tools Search this Thread
  #1  
Old 07-02-2012
Member
 
Join Date: Jan 2012
Posts: 66
I need help with plotting efficient frontier in Microsoft Excel

How to plot efficient frontier from sets of data containing expected return, average return, variance, standard deviation, covariance and correlation.

Reply With Quote
  #2  
Old 07-02-2012
Member
 
Join Date: Jul 2011
Posts: 632
Re: I need help with plotting efficient frontier in Microsoft Excel

The fundamental idea of the efficient frontier of investment, is that, given a series of expected returns and risk, combining them properly, you can find the minimum risk portfolio, and from this, all possible combinations of efficient investment . This is because an appropriate diversification of our portfolio, we can help reduce risk and enhance expected returns. It is very complicated in Excel.
Reply With Quote
  #3  
Old 07-02-2012
Member
 
Join Date: Jun 2011
Posts: 632
Re: I need help with plotting efficient frontier in Microsoft Excel

The efficient frontier of investment shows the infinite combinations of risk and return we can achieve with this group of eleven actions. The yellow dot up and to the right, any portfolio that is on the curve is efficient. This is due, if we take a point that is below, there will be a portfolio on the curve have the same return but lower risk.
Reply With Quote
Reply

  TechArena Community > Technical Support > Computer Help > Office Help > MS Office Support
Tags: , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "I need help with plotting efficient frontier in Microsoft Excel"
Thread Thread Starter Forum Replies Last Post
A software for Vinyl Cutting/Plotting except Corel Upendra Windows Software 8 05-04-2012 07:48 AM
Getting Error while opening Microsoft Excel 2000 file in Excel 2003 AbiaA MS Office Support 6 17-02-2012 01:18 PM
Configuring Internet Explorer 8 to open Excel file in to Microsoft Excel Aaghaz Technology & Internet 4 13-02-2011 10:37 AM
Efficient Macro Recorder Excel Lite cannot function with Windows 7 Mariah-Simpson Windows Software 4 21-04-2010 05:15 AM


All times are GMT +5.5. The time now is 07:07 AM.