this is the data for the question above

The following table, , contains annual returns for the stocks of ABC Corp. (ABC) and XYZ Corp (XYZ) The roturns are catculated using end of-year prices (adjusted for dividends and slock splits) Use the informatoon for ABC Corp (ABC) and XYZ Corp. (XYZ) to create an Excel spreadshoet that calculates the average returns over the 10-year period for portfolios comprised of ABC and XYZ using the following, respective, weightings ( 1.0,0.0), (0 9 , 0 1), (0.8,02),(0.7,0.3),(0.6,0.4),(05,0.5),(0.4,0.6),(0.3,0.7),(0.2,0.8),(0.1,0.9), and (0.0,1.0) The average annual returns over the 10-year period for ABC and XYZ aro 17.96% and 13.05% respectively. Also, calculate the portfolio standard deviation over fhe 10 -year period associated with each portiolio composition The standard deviation over the 10 -year period for ABC Corp. and XYZ Corp and their correlation coefficient are 2373%, 2071%, and 083094 respectively (Hint Review Tatle 52 ) places.) question10A question 10