DataDayRILTATASBIInfosysBioconNifty11280.9929.51253.552272.653804007.421284.55938.251264.852311.35374.54024.0531280.5947.112432285.3374.73988.841288.15937.41244.12275.05377.453983.451276.85928.51213.72205.6375.63933.461278.3911.11174.92190.1365.63911.471273.15908.451136.42164.45357.83850.381296.5918.351147.452183364.13942.2591339.5941.21225.452223.4361.554052.45101364.95948.51222.252242.95362.454078.4111346.95957.551209.82222.2362.24080.5121349.85964.751222.552205.45371.44076.45131367.4954.4512292224.15410.454109.05141382.75950.71220.32202.35420.454090.15151373.85963.31224.552254425.054102.45161360.55950.451174.052235.15412.34066.1171369.5916.051172.552234.05409.64089.9181370.6927.651176.452241415.64147.7191382.3899.451156.152244.4409.24124.45201366.45878.31140.452247.3402.054082.7211377.6906.3512032268.954114137.2221375.05909.851181.052265.55419.94183.5231387.35919.051197.052269.3432.24215.35241389.2920.051196.52272.95465.154195.9251394.9902.31195.052357.05469.34224.25261397.05896.81205.252373.7460.954223.4271391.8905.051199.652361.25446.54187.4281358.95875.051183.72351.25422.74058.3291366866.751173.42304.2413.44044.55301377.05850.21102.32284.65414.24047.1311406.95869.31122.62382.95439.054146.2321420.75869.81132.12376.1462.64164.55331414.68561107.752359.95501.14106.95341406.75858.851105.92310.9483.754096.2351412.05834.81078.052287.5455.64040361413.258171058.22237.7462.353938.95371406.55839.551088.42218.15460.53942381405.45823.351069.152187467.33893.9391352.5782.61041.852077.55457.353745.3401367.75789.051055.652159.15445.93811.2411316.2775.41004.92093.5424.13726.75421259.35739.9962.552007.15424.653576.5431297.85726.6988.052114.45417.43655.65441288.65738.6964.42085.35429.553626.85451335.55766.85999.32135.75433.93761.65461318.2757.15982.652120.95447.23718471315.7764.7974.22115.3456.93734.6481326.75773.1980.42105.05460.83770.55491285.35743.659482020465.153641.1501283.4725.95922.12079.4484.453643.6511300.15748.25913.62047.45469.553608.55521313.55771.7926.52087.254723678.9531322.95769.25952.352055.9466.353697.6541340775.8982.952093.95465.453764.55551375.25805.11029.42119.05465.83875.9561376.05789.551026.22092.6473.753861.05571364.55752.551013.652058.15480.153819.95581350719.6973.651992.05466.953761.1591357.2716.45985.651990.7469.053798.1601370.3728.2994.452018.65486.23821.55611313.95670.9930.51922.95464.73633.6621340.75681.4926.751964.65467.83690.65631363.25682.8935.91994.3471.153733.25641358.85686.1948.451992.3470.93752651384.3703.7988.92047.55489.053843.5661384.4721.55991.21998.85480.93848.15671386.6722.8981.41996.25480.83862.65681387.5712.49682045.85489.73829.85691411.95726.3997.952086.9512.83917.35701457.75750.251013.552128.7523.054013.35711475.8730.61010.22082.75512.63984.95721485.35722.51034.052076.3522.654011.6731492.35713.11053.252039.9508.93997.65741541.45722.91073.952055.1504.64083.55751554.3718.151060.32069.25489.054085.1761582.95741.61133.32057.9491.254141.8771598.4759.051139.92018.5484.954167.3781596.85766.61145.32018.85483.754177.85791539.2749.351101.652005.15476.654083.5801561.05751.751101.92050.85480.754087.9811626.15733.11123.452081.65474.154150.85821583.15731.51128.32071.9466.64117.35831606.5728.31119.652041.85469.14111.15841593.15725.11081.652002.25469.74077851598.25723.251122.91980.6466.154079.3861581.4714.851123.31974.2463.14066.8871589.1716.111532000.6460.154076.65881620.25715.21205.752001.9456.74134.3891598.5714.351227.451973.45469.654120.3901634.7734.651284.151951.7472.84170.95911685.25750.61327.151983.5467.154219.55921698.45741.81327.451981.9460.64214.5931760.95725.451348.651960.4472.154260.9941779.25726.9513261946.75470.64278.1951756.157081308.71925.75483.254246.2961727.2712.71286.051937478.64204.9971728.05726.951298.651985.5474.154248.15981723.9732.751308.551971.55479.24256.55991756.9740.851322.551953.7479.454293.251001752.85742.113271906.154804249.651011758.8755.71353.651923.5460.554295.81021751.25747.951378.91938.554644297.051031741.95710.851406.41916.3466.154267.051041745.4710.51436.51943.2467.554284.651051691.36881389.51938.35454.454198.251061669.15677.851360.651957.15437.94179.51071657.05652.21356.61950.85440.141451081666.15653.21339.751979.8441.654145.61091698.9641.21332.31989.5447.854155.21101675.4645.21290.41988.75445.554113.051111696.05642.251313.852019.2458.141701121681.9650.41324.12009.4454.14171.451131671.6644.951318.61989.45460.454147.11141726.55663.51371.91956.64644214.31151732.95686.41423.81954.2461.34248.651161734.35687.51446.551958.45460.14267.41171705.1684.31455.21950.8459.94252.051181709.15678.151449.71936.65454.94259.41191703.25684.61457.31922.15454.654285.71201698.55671.71446.651935.35450.54263.951211692664.41471.11925.05445.254282

Daily ReturnDayRILTATASBIInfosysBioconNiftyEqually Weight Portfolio20.28%0.94%0.90%1.70%-1.45%0.42%0.48%3-0.32%0.94%-1.73%-1.13%0.05%-0.88%-0.43%40.60%-1.02%0.09%-0.45%0.73%-0.14%-0.01%5-0.88%-0.95%-2.44%-3.05%-0.49%-1.26%-1.56%60.11%-1.87%-3.20%-0.70%-2.66%-0.56%-1.66%7-0.40%-0.29%-3.28%-1.17%-2.13%-1.56%-1.46%81.83%1.09%0.97%0.86%1.76%2.39%1.30%93.32%2.49%6.80%1.85%-0.70%2.80%2.75%101.90%0.78%-0.26%0.88%0.25%0.64%0.71%11-1.32%0.95%-1.02%-0.93%-0.07%0.05%-0.48%120.22%0.75%1.05%-0.75%2.54%-0.10%0.76%131.30%-1.07%0.53%0.85%10.51%0.80%2.42%141.12%-0.39%-0.71%-0.98%2.44%-0.46%0.30%15-0.64%1.33%0.35%2.35%1.09%0.30%0.89%16-0.97%-1.33%-4.12%-0.84%-3.00%-0.89%-2.05%170.66%-3.62%-0.13%-0.05%-0.65%0.59%-0.76%180.08%1.27%0.33%0.31%1.46%1.41%0.69%190.85%-3.04%-1.73%0.15%-1.54%-0.56%-1.06%20-1.15%-2.35%-1.36%0.13%-1.75%-1.01%-1.29%210.82%3.19%5.48%0.96%2.23%1.33%2.54%22-0.19%0.39%-1.82%-0.15%2.17%1.12%0.08%230.89%1.01%1.35%0.17%2.93%0.76%1.27%240.13%0.11%-0.05%0.16%7.62%-0.46%1.60%250.41%-1.93%-0.12%3.70%0.89%0.68%0.59%260.15%-0.61%0.85%0.71%-1.78%-0.02%-0.13%27-0.38%0.92%-0.46%-0.52%-3.13%-0.85%-0.72%28-2.36%-3.31%-1.33%-0.42%-5.33%-3.08%-2.55%290.52%-0.95%-0.87%-2.00%-2.20%-0.34%-1.10%300.81%-1.91%-6.06%-0.85%0.19%0.06%-1.56%312.17%2.25%1.84%4.30%6.00%2.45%3.31%320.98%0.06%0.85%-0.29%5.36%0.44%1.39%33-0.43%-1.59%-2.15%-0.68%8.32%-1.38%0.69%34-0.55%0.33%-0.17%-2.08%-3.46%-0.26%-1.19%350.38%-2.80%-2.52%-1.01%-5.82%-1.37%-2.35%360.08%-2.13%-1.84%-2.18%1.48%-2.50%-0.92%37-0.47%2.76%2.85%-0.87%-0.40%0.08%0.77%38-0.08%-1.93%-1.77%-1.40%1.48%-1.22%-0.74%39-3.77%-4.95%-2.55%-5.00%-2.13%-3.82%-3.68%401.13%0.82%1.32%3.93%-2.50%1.76%0.94%41-3.77%-1.73%-4.81%-3.04%-4.89%-2.22%-3.65%42-4.32%-4.58%-4.21%-4.12%0.13%-4.03%-3.42%433.06%-1.80%2.65%5.35%-1.71%2.21%1.51%44-0.71%1.65%-2.39%-1.38%2.91%-0.79%0.02%453.64%3.82%3.62%2.42%1.01%3.72%2.90%46-1.30%-1.26%-1.67%-0.69%3.07%-1.16%-0.37%47-0.19%1.00%-0.86%-0.27%2.17%0.45%0.37%480.84%1.10%0.64%-0.48%0.85%0.96%0.59%49-3.12%-3.81%-3.30%-4.04%0.94%-3.43%-2.67%50-0.15%-2.38%-2.73%2.94%4.15%0.07%0.37%511.31%3.07%-0.92%-1.54%-3.08%-0.96%-0.23%521.03%3.13%1.41%1.94%0.52%1.95%1.61%530.72%-0.32%2.79%-1.50%-1.20%0.51%0.10%541.29%0.85%3.21%1.85%-0.19%1.81%1.40%552.63%3.78%4.73%1.20%0.08%2.96%2.48%560.06%-1.93%-0.31%-1.25%1.71%-0.38%-0.35%57-0.84%-4.69%-1.22%-1.65%1.35%-1.06%-1.41%58-1.07%-4.38%-3.95%-3.21%-2.75%-1.54%-3.07%590.53%-0.44%1.23%-0.07%0.45%0.98%0.34%600.97%1.64%0.89%1.40%3.66%0.62%1.71%61-4.11%-7.87%-6.43%-4.74%-4.42%-4.92%-5.51%622.04%1.57%-0.40%2.17%0.67%1.57%1.21%631.68%0.21%0.99%1.51%0.72%1.15%1.02%64-0.32%0.48%1.34%-0.10%-0.05%0.50%0.27%651.87%2.57%4.26%2.77%3.85%2.44%3.07%660.01%2.54%0.23%-2.38%-1.67%0.12%-0.25%670.16%0.17%-0.99%-0.13%-0.02%0.38%-0.16%680.06%-1.44%-1.37%2.48%1.85%-0.85%0.32%691.76%1.95%3.09%2.01%4.72%2.28%2.71%703.24%3.30%1.56%2.00%2.00%2.45%2.42%711.24%-2.62%-0.33%-2.16%-2.00%-0.71%-1.17%720.65%-1.11%2.36%-0.31%1.96%0.67%0.71%730.47%-1.30%1.86%-1.75%-2.63%-0.35%-0.67%743.29%1.37%1.97%0.75%-0.84%2.15%1.31%750.83%-0.66%-1.27%0.69%-3.08%0.04%-0.70%761.84%3.27%6.88%-0.55%0.45%1.39%2.38%770.98%2.35%0.58%-1.91%-1.28%0.62%0.14%78-0.10%0.99%0.47%0.02%-0.25%0.25%0.23%79-3.61%-2.25%-3.81%-0.68%-1.47%-2.26%-2.36%801.42%0.32%0.02%2.28%0.86%0.11%0.98%814.17%-2.48%1.96%1.50%-1.37%1.54%0.75%82-2.64%-0.22%0.43%-0.47%-1.59%-0.81%-0.90%831.47%-0.44%-0.77%-1.45%0.54%-0.15%-0.13%84-0.83%-0.44%-3.39%-1.94%0.13%-0.83%-1.30%850.32%-0.26%3.81%-1.08%-0.76%0.06%0.41%86-1.05%-1.16%0.04%-0.32%-0.65%-0.31%-0.63%870.49%0.17%2.64%1.34%-0.64%0.24%0.80%881.96%-0.13%4.58%0.06%-0.75%1.41%1.14%89-1.34%-0.12%1.80%-1.42%2.84%-0.34%0.35%902.26%2.84%4.62%-1.10%0.67%1.23%1.86%913.09%2.17%3.35%1.63%-1.20%1.17%1.81%920.78%-1.17%0.02%-0.08%-1.40%-0.12%-0.37%933.68%-2.20%1.60%-1.08%2.51%1.10%0.90%941.04%0.21%-1.68%-0.70%-0.33%0.40%-0.29%95-1.30%-2.61%-1.30%-1.08%2.69%-0.75%-0.72%96-1.65%0.66%-1.73%0.58%-0.96%-0.97%-0.62%970.05%2.00%0.98%2.50%-0.93%1.03%0.92%98-0.24%0.80%0.76%-0.70%1.07%0.20%0.34%991.91%1.11%1.07%-0.91%0.05%0.86%0.65%100-0.23%0.17%0.34%-2.43%0.11%-1.02%-0.41%1010.34%1.83%2.01%0.91%-4.05%1.09%0.21%102-0.43%-1.03%1.87%0.78%0.75%0.03%0.39%103-0.53%-4.96%1.99%-1.15%0.46%-0.70%-0.84%1040.20%-0.05%2.14%1.40%0.30%0.41%0.80%105-3.10%-3.17%-3.27%-0.25%-2.80%-2.02%-2.52%106-1.31%-1.48%-2.08%0.97%-3.64%-0.45%-1.51%107-0.72%-3.78%-0.30%-0.32%0.50%-0.83%-0.93%1080.55%0.15%-1.24%1.48%0.35%0.01%0.26%1091.97%-1.84%-0.56%0.49%1.40%0.23%0.29%110-1.38%0.62%-3.14%-0.04%-0.51%-1.01%-0.89%1111.23%-0.46%1.82%1.53%2.82%1.38%1.39%112-0.83%1.27%0.78%-0.49%-0.87%0.03%-0.03%113-0.61%-0.84%-0.42%-0.99%1.40%-0.58%-0.29%1143.29%2.88%4.04%-1.65%0.77%1.62%1.87%1150.37%3.45%3.78%-0.12%-0.58%0.82%1.38%1160.08%0.16%1.60%0.22%-0.26%0.44%0.36%117-1.69%-0.47%0.60%-0.39%-0.04%-0.36%-0.40%1180.24%-0.90%-0.38%-0.73%-1.09%0.17%-0.57%119-0.35%0.95%0.52%-0.75%-0.05%0.62%0.07%120-0.28%-1.88%-0.73%0.69%-0.91%-0.51%-0.62%121-0.39%-1.09%1.69%-0.53%-1.17%0.42%-0.30%

AnalysisRILTATASBIInfosysBioconNiftyEqually Weight PortfolioMax4.17%3.82%6.88%5.35%10.51%3.72%3.31%Min-4.32%-7.87%-6.43%-5.00%-5.82%-4.92%-5.51%Average0.25%-0.26%0.16%-0.12%0.16%0.07%0.04%Stddev0.8546591153-0.47673561380.5075354104-0.2666984070.51025867470.1787521809VarRSQ69.12%50.04%56.09%49.02%8.39%100.00%78.34%Beta0.9470199731.05306869061.27935750670.85689369910.5148998320.99166666670.9302479403CAPM17.35%18.40%20.63%16.46%13.08%

Kurtosis0.8241125840.56247489040.41720797510.92100199292.71342402081.50824994221.1965199488Coefficient of variation348.24185.73311.33216.79311.63273.820.00ModeERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AGeometric Mean0.2322%-0.2794%0.1334%-0.1382%0.1321%0.0552%0.0272%Return risk ratio0.00287155510.00538414330.00321199440.00461265590.00320891070.0036520829ERROR:#DIV/0!Median0.2067%-0.1223%0.1605%-0.3158%0.0528%0.0730%0.1753%Correlation with RIL10.52389606710.64059926350.5385044310.24922888520.83135526130.7831143507Correlation with TATA0.523896067110.61293506540.41036023930.19036243020.70741708150.7560305966Correlation with SBI0.64059926350.612935065410.44023957690.2016349120.74896512070.8082713104Correlation with Infosys0.5385044310.41036023930.440239576910.2441231070.70011409470.6915460237Correlation with Biocon0.24922888520.19036243020.2016349120.24412310710.28971508990.5685513772Correlation with market0.83135526130.70741708150.74896512070.70011409470.289715089910.8851011946Correlation with equally weighted0.78311435070.75603059660.80827131040.69154602370.56855137720.88510119461Covariance with RILSelf0.00018043350.00025316730.00015248890.00010248040.00019074060.00019042410.0002531673Covariance with TATA0.0001804335Self0.00031655150.00015185280.00010228980.00021210010.00024023960.0003165515Covariance with SBI0.00025316730.0003165515Self0.00018693730.00012432720.00025767720.00029472140.0003165515Covariance with Infosys0.00015248890.00015185280.0001869373Self0.00010785420.00017258820.00018067720.0001869373Covariance with Biocon0.00010248040.00010228980.00012432720.0001078542Self0.00010370670.00021569770.0002156977Covariance with market0.00019074060.00021210010.00025767720.00017258820.0001037067Self0.00018736250.0002576772Covariance with equally weighted0.00019042410.00024023960.00029472140.00018067720.00021569770.0001873625Self0.0002947214

AnswersQuestionAnswersCommentsWhat is mean-variance ratios for Market?0.00How the portfolios can be revised? What are the criteria one could use for revision?What is the Skewnes of daily return for RIL?0.00How would you allocate your wealth between the treasury bill (risk-free rate) and the optimal portfolio you have computed?What is the standard deviation of daily return for Biocon?51.03%What is the Kurtosis of daily return for equally weighted five stocks portfolio?1.20What is the RSQ for Biocon?8.39%What is the maximum daily return for equally weighted five stocks portfolio?3.31%What is the identified optimal portfolio?What is the Variation of daily return for Market?17.88%What is the Systematic risk of SBI?20.634%What are the themes that active equity portfolio managers can use?What are the weights of various stocks in a portfolio optimized for an enhanced beta?What is mean-variance ratios for RIL?0What is the minimum daily return for equally weighted five stocks portfolio?-5.51%What is the standard deviation of daily return for Market?17.88%What is the RSQ for RIL?69.12%What is mean-variance ratios for SBI?0What is the standard deviation of daily return for RIL?85.47%What is the unsystematic risk for RIL?0.00%What is the Non diversifiable risk for equally weighted five stocks portfolio?0.00%What is the Coefficient of variation of daily return for SBI?311.33What is the difference between risk and uncertainty?What is the arithmetic daily average return (in percentage) for SBI?0.16%What is the mode value of daily return for the equally weighted five stocks portfolio?ERROR:#N/AWhat is optimal portfolio (Weights of various stocks) for the objective function - Maximize Portfolio return?What is the geometric daily average return (in percentage) for equally weighted five stocks portfolio?0.0272%What is the RSQ for Infosys?49.02%What is the Variation of daily return for Tata?-47.67%Highest total riskRILHighest returnRILHighest systematic risk0.0688484391Lowest unsystematic riskERROR:#N/ALowest Return Risk RatioERROR:#DIV/0!Highest Return Risk RatioERROR:#DIV/0!Highest unsystematic riskERROR:#N/ALowest returnTATALowest systematic risk0.1051427033Lowest total riskTATAWhat is the Systematic risk of Market?0.00%How did you estimate the daily return for stocks and the market?What is the beta for RIL?0.947019973What is the mode value of daily return for the RIL?ERROR:#N/AWhat is the beta for Market?0.9916666667Explain the shape of the efficient frontierGenerally most attractive stock have higher beta, and less attractive stock have lower beta does beta measures the risk of the stock ?Why diversification works?What is the median value of daily return for equally weighted five stocks portfolio?0.0017529025What happens to the weights and to the overall portfolios Sharpe ratio when the correlation changes? Why?What is the Diversifiable risk for equally weighted five stocks portfolio?0.00%What is the beta for Infosys?0.8568936991What is mean-variance ratios for Biocon?0What is the Variation of daily return for equally weighted five stocks portfolio?0.00%How mean-variance optimization can be made effective?What is the arithmetic daily average return (in percentage) for the Market (Nifty)?0.07%We can use past data to understand and draw inferences but to what extent can these inferences be applied to the future?What is the Skewnes of daily return for Market?0What is the Coefficient of variation of daily return for Infosys?216.79What is mean-variance ratios for Infosys?0What is the standard deviation of daily return for equally weighted five stocks portfolio?0.00%What is the unsystematic risk for Tata?0.00%How does the goal of a passive equity portfolio manager differ from the goal of an active manager?What is the Non diversifiable risk for Biocon?13.08%What is the RSQ for Tata?50.04%Explain why the line from the risk free rate that is tangent to the efficient frontier defines the dominant portfolio possibilitiesWhat is the optimal portfolio (Weights of various stocks) for the objective function - Maximize portfolio mean-variance ratio?Highest correlated with TataEqually weightedHighest correlated with SBIEqually weightedHighest correlated with Equally weighted five stocks portfolioNiftyHighest correlated with InfosysNiftyHighest correlated with BioconEqually weightedHighest correlated with RILNiftyHighest correlated with MarketEqually weightedWhat is the Skewnes of daily return for Tata?0Under what circumstances daily GM return should be prefereed over daily AM return?What is the arithmetic daily average return (in percentage) for RIL?0.25%What is the Variation of daily return for SBI?50.75%What is the minimum daily return for Tata?-7.87%What is the median value of daily return for the SBI?0.16%What are the various methods through which the beta of the portfolio can be diluted?What is the median value of daily return for the Market?0.07%What is the optimal portfolio (Weights of various stocks) for the objective function - Minimize Portfolio Risk?How to explore for the error caused in MV optimization approach? How to correct those errors?What is the Kurtosis of daily return for Market?1.5082499422What is the arithmetic daily average return (in percentage) for Infosys?-0.12%What is the Diversifiable risk for Biocon?0.00%What is the minimum daily return for RIL?-4.32%What is the RSQ for SBI?56.09%What is the beta for equally weighted five stocks portfolio?0.9302479403What is the maximum daily return for SBI?6.88%What is the Coefficient of variation of daily return for equally weighted five stocks portfolio?0.00Estimate and draw the efficient frontier using the 5 stocks in doc file and attach the file link belowWhat is the Non diversifiable risk for Infosys?16.46%What is the Coefficient of variation of daily return for Market?273.82What is mean-variance ratios for equally weighted five stocks portfolio?0What is the beta for Tata?1.0530686906What is the unsystematic risk for SBI?0.00%What is the maximum daily return for Market?3.72%What is the Systematic risk of RIL?17.35%What is the RSQ for Market?100.00%What is the arithmetic daily average return (in percentage) for equally weighted five stocks portfolio?0.04%What is the Diversifiable risk for the Market?0.00%Which stock can result in good diversification in the portfolio?What is the mode value of daily return for the SBI?ERROR:#N/AWhat is the unsystematic risk for Infosys?0.00%What are the techniques for constructing a passive index portfolio?What techniques are used by active managers in an attempt to outperform their benchmark?What is the beta for SBI?1.2793575067What is the RSQ for equally weighted five stocks portfolio?78.34%What happens to the optimal portfolio and the Sharpe ratio when there is a constraint on shorting and weight of individual stock?What is the median value of daily return for RIL?0.21%What is the Kurtosis of daily return for Biocon?2.7134240208List out your interpretation of the summary statistics estimated by you for the daily stock return series of the stocks and the marketExplain various available methods for enhancing the alpha of the portfolioWhat is the Skewnes of daily return for equally weighted five stocks portfolio?0What is the Kurtosis of daily return for SBI?0.4172079751What are the benefits of MV optimizers?What is the Non diversifiable risk for Tata?18.40%What is a portfolios tracking error and how is it useful in the construction of a passive equity investment?What is the geometric daily average return (in percentage) for Tata?-0.28%What is the beta for Biocon?0.514899832How one could measure the benefit of diversification? Measure the benefit of diversification for various portfolios constructed with various objectivesHighest Covariance with MarketSBIHighest Covariance with Equally weighted five stocks portfolioSBIHighest Covariance with SBITATAHighest Covariance with InfosysSBIHighest Covariance with TataSBIHighest Covariance with BioconEqually weightedHighest Covariance with RILSBIExplain on what logic the weights of the stocks are derived in a portfolio?How arithmetic average daily return and geometric average daily return is related?Which stock may not shed more unsystenatic risk in a portfolio?RILList out your interpretation of the summary statistics estimated by you for equally weighted five stocks portfolio?What is the beta for SBI?1.2793575067What are the various methods in which the beta of the portfolio can be enhanced? When such enhancements are used?What is the geometric daily average return (in percentage) for Biocon?0.13%What are the shortcomings of MV optimizers?If you buy a stock with higher unsystematic risk and lower or zero systematic risk, will your return be only risk-free return, if so why to buy that?

RoughDayRILTATASBIInfosysBioconNiftyEqually Weight Portfolio21.00284955891.00941366331.00901439911.0170285790.98552631581.00415481361.004766503230.99684714491.0094324540.98272522430.98872953041.00053404540.99124016850.995653679841.00597422880.98975820931.00088495580.99551481211.00733920470.99864620940.999894282150.99122772970.99050565390.97556466520.96947319840.99509868860.98744790880.984373987261.00113560720.98126009690.96803163880.99297243380.97337593180.99440687450.983355141770.99597121180.99709142790.96723125370.9882882060.97866520790.98437899470.985449461581.0183403371.01089768291.00972368881.00857030651.0176076021.0238812561.013027923491.03316621671.02488158111.06797681821.01850664220.99299642961.02795357981.0275055376101.01899962671.00775605610.99738871431.00879283981.00248928231.00640353371.0070853038110.98681270381.00954138110.98981386790.99074879070.99931024971.00051490780.9952453986121.00215301241.00751918961.01053893210.99246242461.02540033130.99900747461.007614778131.01300144460.9893236591.00527585781.00847899521.10514270331.00799715441.024244532141.01122568380.99607103570.9929210740.99019850281.02436350350.99540039671.00295596150.99356355091.01325339221.00348275011.02345222151.01094065881.00300722471.0089385147160.9903191760.98666043810.95876036090.99163708960.9700035290.99113944110.9794761187171.0065782220.96380661790.99872237130.9995078630.99345137041.00585327460.9924132889181.00080321291.01266306421.00332608421.0031109421.01464843751.01413237491.0069103482191.00853640740.96960060370.9827446981.00151717980.98460057750.99439448370.9893998933200.98853360340.97648563010.98642044721.00129210480.98252688170.98987743820.9870517334211.00815983021.03193669591.0548467711.00963378281.02226091281.01334900921.0253675985220.99814895471.00386164290.98175394850.99850150951.02165450121.01119114381.0007841113231.00894512931.01011155691.01354726731.00165522721.02929268871.00761324251.0127103739241.00133347751.00108808010.99954053721.00160842551.07623785280.9953859111.0159616746251.00410308090.98070757020.99878813211.0370003741.00892185321.00675659571.0059042021261.00154132910.99390446641.00853520771.00706391460.98220754310.99979878080.9986504922270.99624208151.00919937560.99535366110.99475502380.96865169760.99147606190.9928403679280.97639747090.96685266010.98670445550.9957649550.94669652860.9691694130.974483214291.00518782880.99051482770.99129847090.97998936740.97799858060.99661188180.9889978151301.00808931190.98090568210.93940685190.99151549341.00193517171.00063047810.9843705022311.02171308231.02246530231.01841603921.04302628411.05999517141.02448666951.0331231759321.00980845091.00057517541.00846249780.99712541181.05363853781.00442573921.0139220147330.99567130040.98413428370.97849129940.9932031481.08322524860.98616897381.006945056340.99445072811.00332943930.99832994810.97921566130.96537617240.99738248580.9881403898351.00376754930.97199743840.97481689120.9898740750.94180878550.98627996680.9764529479361.00084982830.97867752760.98158712490.97822950821.01481562770.97498762380.9908319233370.99525915441.02760097921.02853902850.99126335080.99599870231.0007743181.007732243380.99921794460.98070394850.98231348770.98595676581.01476655810.9877980720.9925917409390.96232523390.95050707480.9744656970.94995427530.97870746840.96183774620.9631919499401.01127541591.00824175821.01324566881.0392770330.97496446921.01759538621.009400869410.96231036370.98270071610.9519253540.96959451640.95111011440.97784162470.9635282129420.95680747610.95421717820.95785650310.9587532841.00129686390.95968337020.9657862611431.03057132650.98202459791.02649213031.05345888450.98292711641.02213057461.0150948111440.99291135341.01651527660.97606396440.98623755591.02910876860.99212178411.0001673838451.03639467661.03824803681.03618830361.02416860481.0101268771.03716723881.0290252998460.98700909740.98735085090.98333833680.993070351.0306522240.98839604960.9962841718470.99810347441.0099716040.99140080390.99733609941.02169051881.0044647661.0037005001481.00839857111.01098469991.00636419630.99515435161.00853578461.00962619831.0058875207490.96879592990.96190660980.96695226440.95959715921.00944010420.96566813860.9733384135500.99848290350.97619848050.97267932491.02940594061.04149199181.00068660571.0036517283511.01305127011.0307183690.99078191090.98463499090.9692434720.9903803930.9976860026521.01030650311.03133979281.0141199651.01943881411.00521776171.01949536521.0160845673531.00715617980.99682519111.02790070160.98498023720.9880296611.00508304111.0009783941541.01288786421.00851478711.03213104431.01850770950.9980701191.01810633921.0140223048551.02630597011.03776746581.04725570991.01198691471.00075196051.02957856851.0248136042561.00058171240.98068562910.9968913930.98751799161.01706741090.99616863180.9965488274570.99164274550.95313786330.98777041510.98353722641.01350923480.98935522720.985919497580.98933714410.95621553390.96053864750.96788377910.97250859110.98459403920.9692967391591.00533333330.99562256811.01232475740.99932230621.00449726951.00983754751.0034200469601.00965222521.01640030711.00892811851.01404028731.03656326621.00617413971.0171168409610.9588776180.92131282610.93569309670.95259207890.95577951460.95081838520.9448510269621.02039651431.01565061860.99596990871.02168543121.00667097051.01570068251.0120746887631.01678165211.00205459351.00987321281.01509174661.007161181.01154268221.010192477640.99677241891.00483304041.01340955230.99899714190.99946938341.00502243351.0026963074651.01872907241.02565223731.04264853181.02773176731.03854321511.02438699361.0306609648661.00007223871.0253659231.00232581660.9762154770.98333503731.00120983480.9974628985671.00158913611.00173238170.99011299440.99869925210.99979205661.00376804440.9983851641681.00064906970.98561151080.98634603631.02484658741.01851081530.99150842041.0031928039691.01762162161.01951151041.03094008261.02006500971.04717173781.02284684781.0270619924701.03243740931.03297535451.01563204571.02002970911.01998829951.02450636271.0242125636711.01238209570.97380873040.99669478570.97841405550.98002103050.99292361740.9882641396721.00647106650.9889132221.02360918630.99690313291.01960593061.00668766231.0071005077731.0047126940.98698961941.01856776750.98246881470.97369176310.99652258450.9932861317741.03290112911.01374281311.01965345361.00745134570.99155040281.0214876241.0130598288751.00833630670.99342924330.98728991111.00688530970.96918351171.00037957170.9930248565761.0184327351.03265334541.06884843910.99451492091.00449851751.01387970921.0237895916771.00976025771.0235302051.00582370070.98085426890.98717557251.00615674341.001428801780.99903028031.00994664381.00473725771.00017339610.99752551811.00253161521.0022826192790.96389767350.97749804330.9618877150.99321395840.98532299740.97741661380.9763640775801.01419568611.00320277571.00022693231.02279131241.00860169941.0010775071.0098036812811.04170270010.97519122051.01955712861.01501816320.98627145091.01539910471.0075481326820.97355717490.99781748741.00431705910.99531621550.9840767690.99192936390.9910169412831.01474907620.99562542720.99233359920.98549640431.00535790830.99849417710.998712483840.99169000930.99560620620.96606082260.98060582321.0012790450.99169332180.9870483813851.00320120520.99744862781.03813618080.98918716440.99244198421.00056414031.0040830325860.98945721880.98838575871.00035622050.9967686560.99345704170.99693574880.9936849791871.00486910331.00174861861.02643995371.01337250530.99362988561.00242205171.0080120133881.01960229060.99874319231.04575021681.00064980510.99250244491.01414151331.0114495899890.98657614570.99881152131.01799709720.98578850091.02835559450.99661369521.0035057719901.02264623081.02841744241.04619332760.98897869211.00670712231.01229279421.0185885631911.03092310521.02171101891.03348518481.01629348770.98804991541.01165202171.0180925424921.00783266580.98827604581.00022604830.99919334510.98597880770.99880318990.9963013825931.03679825720.97795901861.01597046970.9891518241.02507598781.01100960971.0089911115941.01039211791.00206768210.98320542760.99303713530.9967171451.00403670590.9970839016950.98701700150.97393218240.98695324280.98921279051.0268805780.99254341880.9927991591960.98351507561.00663841810.98269274851.00584187980.99037765130.99027365640.9938131547971.0004921261.01999438751.00979744181.02503871970.99070204761.01028561921.0092049445980.99759844911.00797854051.00762330110.99297406191.0106506381.00197733131.0033649981991.01914264171.01105424771.01069886520.99094620981.00052170281.00862200611.00647273341000.99769480331.00168725111.00336471210.97566156521.00114714780.98984452340.99591109591011.00339447191.01832637111.02008289371.00910211680.95947916671.01085971791.0020770041020.99570730040.98974460761.01865327081.00782427871.00749104331.00029098191.00388410021030.99468950750.95039775391.01994343320.98852234921.00463362070.99301846620.99163733291041.00198053910.99950763171.02140216151.0140374681.00300332511.00412462941.00798622511050.96900423970.96833216050.96728158720.99750411690.97198160620.97983499240.97482074211060.98690356530.9852470930.97923713571.00969897080.96358235230.99553385340.98493382341070.99275080130.96215976990.99702348140.99678103361.00502397810.99174542410.99074781291081.0054916871.0015332720.98757924221.01483968531.00352192681.00014475271.00259316271091.01965609340.98162890390.99443926111.00489948481.01403826561.00231570821.00293240171100.98616752021.00623830320.96855062670.99962302090.99486435190.98985608390.99108876461111.01232541480.99542777431.01817265961.01531112511.02816743351.01384617251.01388088151120.99165708561.01268976261.00780149940.99514659270.9912682821.00034772180.99971264451130.99387597360.99162054120.99584623520.99007166321.0139837040.99416270120.99707962341141.03287269681.02876191951.04042165930.98348789871.00770984911.01620409441.01865080471151.00370681421.03451394121.03783074570.99877338240.99418103451.00815081981.01380118361161.0008078711.00160256411.01597836771.0021748030.9973986561.00441316651.00359245241170.9831348920.99534545451.00597974490.99609384970.99956531190.9964029620.99602385061181.00237522730.99101271370.99622045080.99274656550.98912807131.0017285780.99429660571190.99654799171.00951117011.0052424640.99251284430.99945042871.00617457861.00065297981200.99724056950.98115687990.99269196461.006867310.99087209940.99492498310.99376576471210.99614376970.9891320531.01690111640.99467796520.98834628191.00423316410.9970402372