3. Please watch this video How to download/import share prices data into Excel Yahoo Finance 2020 (5:30), then do the following: Download 5 years (60 months) of monthly prices for Home Depot (ticker: HD) from Yahoo finance for the period from the first day in January 2016 through the last day in December 2020 into EXCEL. Then do the same for monthly index values for the S&P 500 Index (ticker: SPX) from Investing.com (register for free) for the same time period into EXCEL. Clean up the data for both time series so that you have only the date and the adjusted closing price for HD and S&P 500. Now, watch the following videos on how to calculate and chart beta (or find a better video on YouTube, and let me know about it for 3 extra points if it is better): How to Calculate Beta (4:17) Beta with slope and chart (8:56) Note: Here are two more videos, this video (4:56) and this video (6:41) that might help you calculate beta using Yahoo data in Excel (but neither video includes the chart part) Calculate beta for Home Depot. a. b. Create a chart for the data exactly as done in the video, place the chart as a separate sheet in your workbook, and label it so that the stock (HD) is on the Y-axis, and the market (S&P500) is on the X-axis. C. Using the snipping tool on your computer, copy your chart and your excel beta output into your homework. (Do not upload the Excel file into CANVAS) [Note: some of you might want to experiment with this video: Pull Stock History into Excel w/ Daily Date Jul 08, 2022 Jul 07, 2022 Jul 06, 2022 Jul 05, 2022 Jul 01, 2022 Jun 30, 2022 Jun 29, 2022 Jun 28, 2022 Jun 27, 2022 Jun 24, 2022 Jun 23, 2022 Jun 22, 2022 Jun 21, 2022 Jun 17, 2022 Jun 16, 2022 Jun 15, 2022 Jun 14, 2022 Jun 13, 2022 Jun 10, 2022 Jun 09, 2022 Highest: 4,119.10 Open = 3.888.26 3.858.85 3,831.98 3,792.61 3,781.00 3,785.99 3.825.09 3,913.00 3,920.76 3.821.75 3,774.71 3,733.89 3,715.31 3,665.90 3,728.18 3,764.05 3,763.52 3.838.15 3,974.39 4,101.65 Download Data Price + High 3,899.38 3,918.50 3,902.62 3,910.63 3,845.08 3,870.91 3,831.39 3,832.19 3,825.33 3,829.82 3,785.38 3,818.99 3,818.83 3,836.50 3,821.55 3,945.86 3,900.11 3,927.72 3,911.74 3,913.65 3,795.73 3,802.58 3,759.89 3,801.79 3,764.79 3,779.65 3,674.84 3,707.71 3,666.77 3,728.18 3,789.99 3,837.56 3,735.48 3,778.18 3,749.63 3,838.15. 3,900.86 3,974.39 4,017.82 4,119.10 Lowest: 3,636.87 Difference: 482.23 Low + 3,869.34 3,858.85 06/09/2022 - 07/09/2022 Vol. + 3,809.37 3,742.06 3,752.10 3,738.67 3,799.02 3,820.14 3,889.66 3,821.75 3,743.52 3,717.69 3,715.31 3,636.87 3,639.77 3,722.30 3,705.68 3,734.30 3,900.16 4,017.17 Average: 3,819.86 Change % + -0.08% 1.50% 0.36% 0.16% 1.06% -0.88% -0.07% -2.01% -0.30% 3.06% 0.95% -0.13% 2.45% 0.22% -3.25% 1.46% -0.38% -3.88% -2.91% -2.38% Change % -5.26 Dollar Ind Recent Name S&P 500 Market Most Ac Name AMD AAPL NVDA AMZN TSLA MSFT GOOGL 3. Please watch this video How to download/import share prices data into Excel Yahoo Finance 2020 (5:30), then do the following: Download 5 years (60 months) of monthly prices for Home Depot (ticker: HD) from Yahoo finance for the period from the first day in January 2016 through the last day in December 2020 into EXCEL. Then do the same for monthly index values for the S&P 500 Index (ticker: SPX) from Investing.com (register for free) for the same time period into EXCEL. Clean up the data for both time series so that you have only the date and the adjusted closing price for HD and S&P 500. Now, watch the following videos on how to calculate and chart beta (or find a better video on YouTube, and let me know about it for 3 extra points if it is better): How to Calculate Beta (4:17) Beta with slope and chart (8:56) Note: Here are two more videos, this video (4:56) and this video (6:41) that might help you calculate beta using Yahoo data in Excel (but neither video includes the chart part) Calculate beta for Home Depot. a. b. Create a chart for the data exactly as done in the video, place the chart as a separate sheet in your workbook, and label it so that the stock (HD) is on the Y-axis, and the market (S&P500) is on the X-axis. C. Using the snipping tool on your computer, copy your chart and your excel beta output into your homework. (Do not upload the Excel file into CANVAS) [Note: some of you might want to experiment with this video: Pull Stock History into Excel w/ Daily Date Jul 08, 2022 Jul 07, 2022 Jul 06, 2022 Jul 05, 2022 Jul 01, 2022 Jun 30, 2022 Jun 29, 2022 Jun 28, 2022 Jun 27, 2022 Jun 24, 2022 Jun 23, 2022 Jun 22, 2022 Jun 21, 2022 Jun 17, 2022 Jun 16, 2022 Jun 15, 2022 Jun 14, 2022 Jun 13, 2022 Jun 10, 2022 Jun 09, 2022 Highest: 4,119.10 Open = 3.888.26 3.858.85 3,831.98 3,792.61 3,781.00 3,785.99 3.825.09 3,913.00 3,920.76 3.821.75 3,774.71 3,733.89 3,715.31 3,665.90 3,728.18 3,764.05 3,763.52 3.838.15 3,974.39 4,101.65 Download Data Price + High 3,899.38 3,918.50 3,902.62 3,910.63 3,845.08 3,870.91 3,831.39 3,832.19 3,825.33 3,829.82 3,785.38 3,818.99 3,818.83 3,836.50 3,821.55 3,945.86 3,900.11 3,927.72 3,911.74 3,913.65 3,795.73 3,802.58 3,759.89 3,801.79 3,764.79 3,779.65 3,674.84 3,707.71 3,666.77 3,728.18 3,789.99 3,837.56 3,735.48 3,778.18 3,749.63 3,838.15. 3,900.86 3,974.39 4,017.82 4,119.10 Lowest: 3,636.87 Difference: 482.23 Low + 3,869.34 3,858.85 06/09/2022 - 07/09/2022 Vol. + 3,809.37 3,742.06 3,752.10 3,738.67 3,799.02 3,820.14 3,889.66 3,821.75 3,743.52 3,717.69 3,715.31 3,636.87 3,639.77 3,722.30 3,705.68 3,734.30 3,900.16 4,017.17 Average: 3,819.86 Change % + -0.08% 1.50% 0.36% 0.16% 1.06% -0.88% -0.07% -2.01% -0.30% 3.06% 0.95% -0.13% 2.45% 0.22% -3.25% 1.46% -0.38% -3.88% -2.91% -2.38% Change % -5.26 Dollar Ind Recent Name S&P 500 Market Most Ac Name AMD AAPL NVDA AMZN TSLA MSFT GOOGL