How to plot risk to return graph in Excel or Mathematica?

Discussion on Quantitative Methods in Finance
Forum rules
DISCLAIMER: We do not warrant or represent that this forum or its content is free of viruses, worms or other code that might be contaminating or destructive. We cannot guarantee that documents or files downloaded from the Site will be free from viruses and we do not accept any responsibility for any damage or loss caused by any virus. Accordingly, for your own protection, you must use virus-checking software when using the forum. You must not post or provide to us via the forum, any document or file which you believe may contain a virus. You must virus check any document or file which you intend to post or provide to us via the forum. You must ensure that any document or file you intend to post to the forum does not contravene any applicable laws or contravene any person's legal rights. We do not accept any responsibility for any damage or loss you may suffer.
niceseb
Posts: 7
Joined: Thu Nov 03, 2011 8:25 pm

How to plot risk to return graph in Excel or Mathematica?

Postby niceseb » Sun Mar 04, 2012 4:39 pm

say I have four assets of return (mu) and risk (sigma):

mu sigma
A 0.04 0.07
B 0.08 0.12
C 0.12 0.18
D 0.15 0.26

How to plot in Excel or Mathematica anyone?



Sebastian

coalexander
Posts: 815
Joined: Sun Sep 28, 2008 10:30 pm

Re: How to plot risk to return graph in Excel or Mathematica

Postby coalexander » Mon Mar 05, 2012 10:40 am

HIghlight the data and click inset - graph scatterplot


Return to “Volume I”

Who is online

Users browsing this forum: No registered users and 1 guest