{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["QUIZ 2"],"not_rendered":{"macros":1},"read":"whole","date_system":"1900"}

{"sheet":"QUIZ 2","index":0,"n_rows":26,"n_cols":6,"rows_kept":26,"merged":[[0,0,0,6],[1,0,1,3],[16,5,18,6]]}
["PLEASE SOLVE THIS FOUR-ASSET PORTFOLIO PROBLEM "]
["Variance-covariance, S",{"$nulls":4},"Mean returns E(r)"]
[{"v":0.1,"d":"0.10"},0.01,0.03,0.05,null,{"v":0.06,"d":"6%"}]
[0.01,{"v":0.3,"d":"0.30"},0.06,-0.04,null,{"v":0.08,"d":"8%"}]
[0.03,0.06,{"v":0.4,"d":"0.40"},0.02,null,{"v":0.1,"d":"10%"}]
[0.05,-0.04,0.02,{"v":0.5,"d":"0.50"},null,{"v":0.15,"d":"15%"}]
[]
[]
[]
[]
["Portfolio Mean, variance, covariance, correlation"]
{"$rows_empty":9}
["Mean portfolio return, E(rp)"]
["Portfolio variance sp2"]
["Portfolio standard deviation sp"]
[]
["Table of returns (using Data Table)"]
["Proportion ","Standard deviation","Mean"]