A B C D E F G H K M N Date RET SPY Samsung RET Sony RET Change Stock 1 and Stock 2 with your ticker symbols 2 9/30/20 SPY Samsung 1 ret Sony 2 ret Method 1 Method 2 3 0.0041 Aug. Daily Ret 0.00070 0.00074 0.00129 -0.06 0.06 10/1/19 0.012 0.020 Beta Stock 1 10/2/19 -0.018 -0.0256 0.019 Daily Std. Deviation 0.02071 0.02014 0.02030 10/3/19 0.008 0.0084 0.019 Daily Variance 0.00043 0.00041 0.00041 Beta Stock 2 0.78 0.78 10/4/19 0.014 0.0052 0.014 10/7/19 -0.004 0.0241 0.012 SPY-Stock 1 SPY-AMAT ABC-AMAT 10/8/19 -0.016 -0.0072 -0.015 Correlation Coefficient -0.06521 0.79897 -0.00916 10/9/19 0.009 0.0124 0.012 10 10/10/19 0.007 0.0173 0.009 SPY ABC AMAT 11 10/11/19 0.010 0.0020 0.014 Annual Return 0.176808519 0.186509611 0.325447796 12 10/14/19 -0.001 0.0120 0.005 Annual Std. Deviation 0.328793724 0.319720845 0.322204353 13 10/15/19 0.010 0.0039 0.011 14 10/16/19 -0.002 0.0119 0.007 SPY-Stock 1 SPY-Stock 2 Stock 1 - Stock 2 15 10/17/19 0.003 0.0080 0.015 Expected return portfolio 0.181659065 0.251128158 0.255978703 16 10/18/19 -0.004 0.0179 0.014 50%/50% Std. Deviation portfolio 0.22591437 17 10/21/19 0.007 0.0000 0.001 0.500 18 10/22/19 -0.003 0.0098 -0.004 SPY-Stock 1 SPY-Stock 2 Stock 1 - Stock 2 19 10/23/19 0.003 0.0039 0.007 75%%/25%% Expected return portfolio 0.199026338 0.200238974 0.252340794 20 10/24/19 0.002 0.0079 0.001 0.75 Std. Deviation portfolio 0.25225791 21 10/25/19 0.004 0.0039 0.002 D.25 22 10/28/19 0.006 0.0137 0.009 SPY-Stock 1 SPY-Stock 2 Stock 1 - Stock 2 23 10/29/19 0.000 0.0000 0.003 25%%/75%% Expected return portfolio 0.199632656 0.225683566 0.226289884 24 10/30/19 0.003 0.0159 0.031 0.25 Std. Deviation portfolio 0.25383295 25 10/31/19 -0.003 0.0215 0.004 0.75 26 11/1/19 0.009 0.0076 0.010 27 11/4/19 0.004 0.0114 0.002 28 11/5/19 -0.001 -0.0075 0.002 Part 3 Findings 29 11/6/19 0.000 0.0151 0.012 30 11/7/19 0.004 0.0096 0.005 Expected return for Samsung 0.0007 Variance for Samsung 0.00040 SO Samsung 0.02006 31 11/8/19 0.002 0.0194 0.000 32 11/11/19 0.002 0.0019 D.022 Expected Return for Sony 0.0013 Variance for Sony 0.00041 SD Sony 0.02022 33 11/12/19 0.002 0.0017 0.007 34 11/13/19 0.000 -0.0119 0.003 1. Higher return the higher the risk in this case Sony has a higher expectec return which means it has more risk for investors. 35 11/14/19 0.001 0.0037 0.007 36 11/15/19 0.007 0.0000 0.003 37 11/18/19 0.001 0.0280 0.006 38 11/19/19 0.000 0.0192 0.009 39 11/20/19 -0.004 0.0118 -0.007 40 11/21/19 -0.002 0.0039 0.001 41 11/22/19 0.002 0.0000 -0.005\f\f\f\f\f\f