Discuss your findings. This should include:

• A discussion of the main statistics, such as
  • the expected return for each stock,
  • the standard deviation for each stock, the expected return of the portfolio of the two stocks you selected using the various percentages allocated to each (50%-50%, 75%-25%, 25%-75%) provided in the sheet,
  • the standard deviation for each portfolio of the two stocks you selected using the various percentages allocated to each (50%-50%, 75%-25%, 25%-75%),
  • the beta of each stock,
  • the beta of a portfolio of the two stocks using the percentages allocated to each (50%-50%, 75%-25%, 25%-75%).

Method 1 0.32 Method 2 0.32 Beta GOLD Avg. Daily Ret Daily Std. Deviation Daily Variance SPY 0.00010 0.01934 0.00037 GOLD 0.00249 0.02700 0.00073 APPLE 0.00157 0.02539 0.00064 Beta APPLE 1.18 1.18 SPY-GOLD SPY-APPLE GOLD-APPLE 0.23073 0.89811 0.10107 Correlation Coefficient Annual Return Annual Std. Deviation SPY GOLD APPLE 0.02535201 0.627711 0.39518297 0.3069386 0.428615 0.40305452 Expected return portfolio Std. Deviation portfolio SPY-GOLD SPY-AMAT GOLD-APPLE 0.32653142 0.210267 0.5114469 0.30865954 50%/50% 0.500 75%/25% 0.75 0.25 Expected return portfolio Std. Deviation portfolio SPY-GOLD SPY-APPLE GOLD-APPLE 0.29746544 0.37276 0.28556234 0.34646492 25%/75% 0.25 0.75 Expected return portfolio Std. Deviation portfolio SPY-GOLD SPY-APPLE GOLD-APPLE 0.33511286 0.291514 0.32916132 0.33077038 Method 1 0.32 Method 2 0.32 Beta GOLD Avg. Daily Ret Daily Std. Deviation Daily Variance SPY 0.00010 0.01934 0.00037 GOLD 0.00249 0.02700 0.00073 APPLE 0.00157 0.02539 0.00064 Beta APPLE 1.18 1.18 SPY-GOLD SPY-APPLE GOLD-APPLE 0.23073 0.89811 0.10107 Correlation Coefficient Annual Return Annual Std. Deviation SPY GOLD APPLE 0.02535201 0.627711 0.39518297 0.3069386 0.428615 0.40305452 Expected return portfolio Std. Deviation portfolio SPY-GOLD SPY-AMAT GOLD-APPLE 0.32653142 0.210267 0.5114469 0.30865954 50%/50% 0.500 75%/25% 0.75 0.25 Expected return portfolio Std. Deviation portfolio SPY-GOLD SPY-APPLE GOLD-APPLE 0.29746544 0.37276 0.28556234 0.34646492 25%/75% 0.25 0.75 Expected return portfolio Std. Deviation portfolio SPY-GOLD SPY-APPLE GOLD-APPLE 0.33511286 0.291514 0.32916132 0.33077038