Within Excel:

Problem 1 (10 points) In this problem, we will analyze stock market data. Go to Yahoo Finance to download quotes. (https://finance.yahoo.com/lookup) Download daily data on the S&P500 (^GSPC), Amazon (AMZN), and Tesla. (TSLA) for the last calendar year . Cut and paste the Adjusted Closing Price into a single worksheet. Make sure to label all your graphs appropriately. Do the following: Generate a time series plot of the data showing closing prices over time on a single graph. (Plot all 3 series on the same graph) Paste this chart into your template. . Create a new column for each series showing the normalized price, i.e., the percentage gain relative to the first day. (Hint: calculate the change in price and then divide each series by the price Day 1, use absolute referencing). Generate a plot of this data. (Plot all 3 series on the same graph) Paste this chart into your template. . Calculate the % daily change for each asset from for the series. (Hint: %Chg (Today's Price -Yesterday's Price)/Yesterday's Price.) Note: you will not have a % change for the first day. Generate a scatter plot of Tesla vs S&P 500 using Excel. (Hint: points only, no lines) with the % change of Tesla on the vertical axis and the % change of the S&P 500 on the horizontal. Add a linear trendline and display the equation and R on your chart. Paste this chart into your template. . Generate the corresponding graph for Amazon vs S&P 500. Paste this chart into your template. . Generate a scatterplot matrix using Data Mining for the % change of all 3 securities. Paste this chart into your template