Task 1:
(1) The daily returns of five different stocks, as well as the daily returns of the S&P 500, are given. Convert the data to an Excel table and rename the table "TableDailyReturns." In the space provided, give the reason for why the source data should be converted to an Excel table.
(2)Create a scatter plot of stock returns (y-axis) and market returns (S&P 500; x-axis) and use option buttons to dynamically select the stock for the plot. (The y-axis should not move as a different stock is selected.)
(3)Add a linear trend line(the characteristic line)that also displays R2 and equation.
(4) Make sure the chart title automatically changes when you select a different stock. The title must include the company name and the beta of the stock selected.(For example, "Amazon Characteristic Line with Beta = 1.62.")