$[$Questions $4-5]$ Use monthly returns for the S&P $500$ index, Amazon

$($AMZN$),$ Microsoft $($MSFT$),$ and Tesla $($TSLA$)$ from $2015$ through $2020.$ You

can find the returns data from the worksheet $$Q$4\_$StockReturns.$$

$4.$ Create an XY $($Scatter$)$ plot to show the relationship between the

returns on each individual stock and the S&P $500.$ I have already

included the chart between S&P $500$ and AMZN in your

Q$4\_$StockReturns worksheet. Once you create the chart, right$-$click the

chart, go to Select Data and the data series, and click Edit. As you can

see from the chart between S&P $500$ and AMZN, you should have the

S&P $500$ column as X and the AMZN return column as Y$.$ Add a linear

trend line to each chart and display the equation and R$2$ on each chart.

$5.$ Run the regression of each individual stock$$s returns $($y$)$ on the S&P

$500$ index returns $($x$).$ Present three regression results in one

worksheet named $$Q$5\_$Regressions.$$ Your regression results should be

the same as the equation and R$2$

reported in Question $4.$