Date Apple 20170131 20170228 20170331 20170428 20170531 20170630 20170731 20170831 20170929 20171031 20171130 20171229 Disney 4.77% 13.36% 4.87% -0.01% 6.78% -5.72% 3.27% 10.69% -6.02% 9.68% 2.04% -1.52% 6.17% -0.51% 3.00% 1.95% -6.63% -1.57% 4.20% -7.94% -2.60% -0.77% 7.17% 3.37% The attached text file has the 2017 monthly returns of Apple and Disney. Import it into Excel. Create an additional column that is 50% Apple's return and 50% Disney's return (this would be the monthly return of a portfolio where your wealth is equally split between the two stocks.) Calculate the average monthly return of the portfolio and its standard deviation using the raverage() and =stdev.s() functions. While you are at it, compare these results to the average return and standard deviation of returns for the stocks individually. stock returns.txt portfolio standard deviation = 3.4% per month portfolio standard deviation = 3.7% per month portfolio standard deviation = 4.2% per month portfolio standard deviation = 4.5% per month portfolio standard deviation = 4.9% per month Date Apple 20170131 20170228 20170331 20170428 20170531 20170630 20170731 20170831 20170929 20171031 20171130 20171229 Disney 4.77% 13.36% 4.87% -0.01% 6.78% -5.72% 3.27% 10.69% -6.02% 9.68% 2.04% -1.52% 6.17% -0.51% 3.00% 1.95% -6.63% -1.57% 4.20% -7.94% -2.60% -0.77% 7.17% 3.37% The attached text file has the 2017 monthly returns of Apple and Disney. Import it into Excel. Create an additional column that is 50% Apple's return and 50% Disney's return (this would be the monthly return of a portfolio where your wealth is equally split between the two stocks.) Calculate the average monthly return of the portfolio and its standard deviation using the raverage() and =stdev.s() functions. While you are at it, compare these results to the average return and standard deviation of returns for the stocks individually. stock returns.txt portfolio standard deviation = 3.4% per month portfolio standard deviation = 3.7% per month portfolio standard deviation = 4.2% per month portfolio standard deviation = 4.5% per month portfolio standard deviation = 4.9% per month