{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["PLEASE READ","4.A.1.i","4.A.1.j, 3-yr ex post std dev"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"PLEASE READ","index":0,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["The content in this spreadsheet is for informational purposes only. You should not construe any such information or other material as legal, tax, investment, financial, or other advice. You alone assume the sole responsibility of evaluating the merits and risks associated with the use of any information or other Content on the Site before making any decisions based on such information or other Content. You agree not to hold CFA Institute or its subsidiaries liable for any possible claim arising from any decision you make based on information or content made available to you through this spreadsheet."]

{"sheet":"4.A.1.i","index":1,"n_rows":27,"n_cols":10,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
["Portfolio","BMV","Annual Return","Weight (BMV)","Contribution (BMV)","Difference to Equal Weighted Mean","Squared Difference (equal weighted mean)","Difference to Asset Weighted Mean","Squared Difference (asset weighted mean)","Weighted Squared Difference"]
[1,100000,5.1999999999999998E-2,{"$f":"B2/$B$13","v":3.8461538461538464E-2},{"$f":"C2*D2","v":2E-3},{"$f":"(C2-$D$16)","v":6.9999999999999923E-4},{"$f":"F2^2","v":4.8999999999999891E-7},{"$f":"(C2-$E$13)","v":2.1153846153845746E-4},{"$f":"H2^2","v":4.4748520710057441E-8},{"$f":"D2*I2","v":1.7210969503868249E-9}]
[2,300000,4.9000000000000002E-2,{"$f":"B3/$B$13","v":0.11538461538461539},{"$f":"C3*D3","v":5.6538461538461543E-3},{"$f":"(C3-$D$16)","v":-2.2999999999999965E-3},{"$f":"F3^2","v":5.2899999999999841E-6},{"$f":"(C3-$E$13)","v":-2.7884615384615383E-3},{"$f":"H3^2","v":7.7755177514792894E-6},{"$f":"D3*I3","v":8.9717512517068724E-7}]
[3,200000,5.5E-2,7.6923076923076927E-2,4.2307692307692307E-3,3.7000000000000019E-3,1.3690000000000015E-5,3.2115384615384601E-3,1.0313979289940819E-5,7.9338302230313989E-7]
[4,500000,5.6000000000000001E-2,0.19230769230769232,1.0769230769230771E-2,4.7000000000000028E-3,2.2090000000000027E-5,4.211538461538461E-3,1.7737056213017747E-5,3.4109723486572591E-6]
[5,100000,5.0999999999999997E-2,3.8461538461538464E-2,1.9615384615384616E-3,-3.0000000000000165E-4,9.0000000000000991E-8,-7.8846153846154343E-4,6.216715976331439E-7,2.3910446062813227E-8]
[6,250000,4.7E-2,9.6153846153846159E-2,4.5192307692307693E-3,-4.2999999999999983E-3,1.8489999999999984E-5,-4.78846153846154E-3,2.292936390532546E-5,2.2047465293582174E-6]
[7,450000,5.1999999999999998E-2,0.17307692307692307,8.9999999999999993E-3,6.9999999999999923E-4,4.8999999999999891E-7,2.1153846153845746E-4,4.4748520710057441E-8,7.7449362767407106E-9]
[8,200000,4.8000000000000001E-2,7.6923076923076927E-2,3.6923076923076927E-3,-3.2999999999999974E-3,1.0889999999999982E-5,-3.7884615384615392E-3,1.4352440828402372E-5,1.1040339098771056E-6]
[9,300000,5.2999999999999999E-2,0.11538461538461539,6.1153846153846154E-3,1.7000000000000001E-3,2.8900000000000003E-6,1.2115384615384583E-3,1.4678254437869745E-6,1.6936447428311246E-7]
[10,200000,0.05,7.6923076923076927E-2,3.8461538461538464E-3,-1.2999999999999956E-3,1.6899999999999885E-6,-1.7884615384615374E-3,3.198594674556209E-6,2.4604574419663148E-7]
["Sample formulas for portfolio 10",null,null,"=B11/$B$13","=C11*D11","=(C11-$D$16)","=F11^2","=(C11-$E$13)","=H11^2","=D11*I11"]
["Sum (Portfolios 1 -10)",{"$f":"SUM(B2:B11)","v":2600000},null,{"$f":"SUM(D2:D12)","v":1},{"$f":"SUM(E2:E11)","v":5.178846153846154E-2},null,null,null,null,{"$f":"SUM(J2:J11)","v":8.8590976331360926E-6}]
[]
[null,null,"Asset Weighted Mean",{"$f":"E13","v":5.178846153846154E-2},"=E13"]
[null,null,"Equal Weighted Mean",{"$f":"AVERAGE(C2:C11)","v":5.1299999999999998E-2},"=AVERAGE(C2:C11)"]
[null,null,"Count of Portfolios",{"$f":"COUNT(C2:C11)","v":10},"=COUNT(C2:C11)"]
[null,null,"Sum of Squared Differences (to equal weighted mean)",{"$f":"SUM(G2:G11)","v":7.609999999999998E-5},"=SUM(G2:G11)"]
[null,null,"Sum of Squared Differences (to asset weighted mean)",{"$f":"SUM(I2:I11)","v":7.8485946745562133E-5},"=SUM(I2:I11)"]
[null,null,"Equal Weighted Standard Deviation",{"$f":"SQRT(D18/D17)","v":2.7586228448267442E-3},"=SQRT(D18/D17)"]
[null,null,"Asset Weighted Standard Deviation",{"$f":"SQRT(J13)","v":2.9764236313294E-3},"=SQRT(J13)"]
[null,null,"High",{"$f":"MAX(C2:C11)","v":5.6000000000000001E-2},"=MAX(C2:C11)"]
[null,null,"Low",{"$f":"MIN(C2:C11)","v":4.7E-2},"=MIN(C2:C11)"]
[null,null,"Range",{"$f":"D22-D23","v":9.0000000000000011E-3},"=D22-D23"]
[null,null,"First Quartile Return",{"$f":"QUARTILE(C2:C11,3)","v":5.2749999999999998E-2},"=QUARTILE(C2:C11,3)"]
[null,null,"Third Quartile Return",{"$f":"QUARTILE(C2:C11,1)","v":4.9250000000000002E-2},"=QUARTILE(C2:C11,1)"]
[null,null,"Interquartile Range",{"$f":"D25-D26","v":3.4999999999999962E-3},"=D25-D26"]

{"sheet":"4.A.1.j, 3-yr ex post std dev","index":2,"n_rows":38,"n_cols":9,"rows_kept":38,"cut":false,"hidden":false,"merged":[[0,5,0,6]]}
[null,"Monthly","Monthly",null,null,"3-Yr Ex-Post Std Dev"]
[null,"Composite Net Return","Benchmark Return",null,null,"Composite","Index"]
["2018-01-31",1.2999999999999999E-2,1.41E-2,null,null,{"$f":"STDEVP(B3:B38)*SQRT(12)","v":2.6429781182093298E-2},{"$f":"STDEVP(C3:C38)*SQRT(12)","v":2.740328447467566E-2},"<-Using STDEVP Excel function","(Calculate the standard deviation based on the population)"]
["2018-02-28",9.1000000000000004E-3,9.7999999999999997E-3,null,null,{"$f":"STDEV(B3:B38)*SQRT(12)","v":2.6804690421107797E-2},{"$f":"STDEV(C3:C38)*SQRT(12)","v":2.7792002960769644E-2},"<-Using STDEV Excel function","(Calculate the standard deviation based on a sample)"]
["2018-03-31",4.4999999999999997E-3,4.8999999999999998E-3]
["2018-04-30",5.7999999999999996E-3,6.4000000000000003E-3]
["2018-05-31",1.3299999999999999E-2,1.37E-2]
["2018-06-30",4.4999999999999997E-3,5.1000000000000004E-3]
["2018-07-31",1.66E-2,1.66E-2]
["2018-08-31",-3.5000000000000001E-3,-4.5999999999999999E-3]
["2018-09-30",5.0000000000000001E-3,5.1000000000000004E-3]
["2018-10-31",8.0000000000000002E-3,6.8999999999999999E-3]
["2018-11-30",0.01,9.9000000000000008E-3]
["2018-12-31",3.2000000000000002E-3,8.9999999999999998E-4]
["2019-01-31",1.2500000000000001E-2,1.35E-2]
["2019-02-28",3.3999999999999998E-3,5.7999999999999996E-3]
["2019-03-31",1.4500000000000001E-2,1.49E-2]
["2019-04-30",1.4999999999999999E-2,1.44E-2]
["2019-05-31",1.3299999999999999E-2,1.2699999999999999E-2]
["2019-06-30",4.4999999999999997E-3,5.1000000000000004E-3]
["2019-07-31",2.3E-3,3.3999999999999998E-3]
["2019-08-31",-3.5000000000000001E-3,-4.5999999999999999E-3]
["2019-09-30",7.7000000000000002E-3,6.7000000000000002E-3]
["2019-10-31",9.7999999999999997E-3,1.4500000000000001E-2]
["2019-11-30",8.2000000000000007E-3,7.9000000000000008E-3]
["2019-12-31",-5.4000000000000003E-3,-8.0000000000000004E-4]
["2020-01-31",1.15E-2,1.15E-2]
["2020-02-29",-1.34E-2,-1.4800000000000001E-2]
["2020-03-31",-1.35E-2,-1.3899999999999999E-2]
["2020-04-30",1.6199999999999999E-2,1.54E-2]
["2020-05-31",5.0000000000000001E-3,5.4999999999999997E-3]
["2020-06-30",-4.4999999999999997E-3,-5.1000000000000004E-3]
["2020-07-31",1.6999999999999999E-3,2.3999999999999998E-3]
["2020-08-31",-3.5000000000000001E-3,-4.5999999999999999E-3]
["2020-09-30",7.7000000000000002E-3,6.7000000000000002E-3]
["2020-10-31",1.3299999999999999E-2,1.4500000000000001E-2]
["2020-11-30",8.9999999999999993E-3,1.0699999999999999E-2]
["2020-12-31",-2.0999999999999999E-3,-1.8E-3]