S&P 500

TSLA

scatter plot is comparing TSLA to S&P 500

3. Get the beta of Tesla using a scatter plot with Excel Then, go to Z to download relevant information and use Excel to calculate the beta of TSLA. (1) Please use 36 monthly return data to calculate the beta and create a scatter plot, with appropriate labels and titles, similar to the one the professor demonstrated in the instruction video of this assignment (2) Copy and paste the scatter plot, with the equation shown to your Word report. (3) Comment on the beta you found using Excel, and compare it with the beta(s) you found from sources in part 2, item (6). Are they different, and why? Date Price Open High Low Vol. Change % 6.91% Oct 21 4,605.38 4,278.70 4,30754 4,324.71 4,531,04 4.415.90 4,608.70 4,544.58 4,537.80 Sep 21 Aug 21 Jul 21 4,304.90 4.76% 2.90% 4,522.68 4,395.26 4,369 20 4.232.80 4.430.20 4,302.43 2.27% 2.22% Jun 21 4.297.50 4,304.10 4,216.52 4,191.98 3,992.78 4.164.40 4,056.88 4,238.04 May 21 Apr 21 4.204.11 4.181.17 0.55% 5.24% 4,218.78 Mar 21 3.972.89 3,811.15 3,714.24 3,842.51 3,731.17 3,992.78 3,723 34 3,725.62 3,662.71 4.24% 2,61% Feb 21 Jan 21 3,764.61 3,645.87 Dec 20 3,633.40 3,756.07 3,621.63 3,269.96 Nov 20 -1.11% 3.71% 10.75% 3.994 41 3,950.43 3,870.90 3,760.20 3,645.99 3,549.85 3,588.11 3,514.77 3,279.99 3.279.74 Oct 20 -2.77% -3.92% Sep 20 Aug 20 Jul 20 3.296.20 3.385.87 3,507.44 3.288.26 3,105.92 3,038.78 2.869.09 2.498.08 3,363.00 3,500 31 3.233.94 3.209.45 3.284.53 3,101.17 2,965 66 7.01% 5.51% 3.271.12 3,100.29 3,233.13 1.84% 4.53% Jun 20 May 20 Apr 20 Mar 20 3,044.31 2.912.43 12.68% -12.51% Feb 20 2,766.64 2,447 49 2,191.86 2,855 84 3,214.64 3,07033 3,050.72 Jan 20 Dec 19 Nov 19 3,068.67 2.954.86 3.136.72 3,393.52 3,337.77 3,247 93 3,154 26 3,050.10 3.021.99 3.013,59 3,027.98 2,964.15 -8.41% -0.16% 2.86% 3.40% 2.855.94 2.891.85 2,822.12 2.04% 1.72% 2,584.59 2,974 28 2.954.22 3.235.66 3.225.52 3,244,67 3.230.78 3,143.85 3,140.98 3,050.72 3,037.56 2,983.69 2.976.74 2,909.01 2,926.46 2.980.32 2,980.38 2,971.41 2.941.76 2,751.53 2.752.06 2,952 33 2.945.83 2,848.63 2.834.40 2.798.22 2:784.49 2.702.32 2.704,10 2.476.96 2,506.85 2,790.50 2,760.17 2,717.58 Lowest: 2,191.86 Oct 19 Sep 19 Aug 19 Jul 19 Jun 19 May 19 Apr 19 Mar 19 -1.81% 1.31% 6.89% -6.58% 2,954.13 2.949.52 2,860.31 2.813.49 2,952.22 2,728,81 2.750.52 2,848.63 2.722.27 2,681.83 2.443.96 2,346,58 2,631 09 Average: 3,364.94 Feb 19 3.93% 1.79% 2.97% 7.87% -9.18% Jan 19 2.708.95 Dec 18 Nov 18 2,800.18 2,815.15 Difference: 2,416.84 1.79% Highest: 4,608.70 Change %: 69.83 Date Price Open Low Vol. High 1.115.21 Change % 43.65% Oct 21 1,114.00 778.40 763.59 528.93M 775.48 73408 799.00 70885 390.06M 5.40% Sep 21 Aug 21 700.00 648.84 735.72 68720 740.39 700.00 381,59M 448 49M 7.06% 1.10% Jul 21 683.92 620,46 Jun 21 679.70 627.80 697.62 571.22 519.92M 625.22 706.00 546.98 May 21 Apr 21 703.80 688.37 625.18M 678 58M 8.71% - 11.87% 6.21% 780.79 709.44 667.93 659.42 539.49 Mar 21 721.11 94268M -1.12% 690.11 814.29 Feb 21 675.50 619.00 Jan 21 880.50 900.40 522.94M 706.02M -14.87% 12.45% 793.53 717.19 719.46 597.59 Dec 20 718.72 1.20B 705,67 567.60 541.21 392.30 Nov 20 Oct 20 394.00 607.80 782.74M 833.91M 24.33% 46.27% -9.55% 440.76 465.90 379.11 388.04 429.01 502.14 502.49 1.748 Sep 20 Aug 20 329.88 273.00 498.32 -13.91% 74.15% 500.14 1.568 289.84 216.60 Jul 20 286.15 359.00 216.10 1898 Jun 20 32.50% 29.32% 215.96 171.60 217.54 17082 1.286 167.00 151.00 168,66 1.368 6.79% May 20 Apr 20 Mar 20 156.38 136.61 89.28 70.10 1.91B 49.22% 104,80 173.96 161.40 193.80 100.80 142 25 134.74 84.90 -21.56% Feb 20 2.11B 2378 133.60 12230 Jan 20 130.11 2.68% 55.50% 84 34 2048 Dec 19 65.88 65.45 1.048 Nov 19 63 26 26.79% 4.78% 789.46M Oct 19 83.67 65.99 62.98 48.17 45.12 48.30 44.82 130.60 87.06 72.24 68.17 50.70 48.90 53.21 Sep 19 Aug 19 61.85 44.86 43.67 42.20 1.188 68282M 670.52M 30.75% 6.76% 48.53 46.04 Jul 19 44.44 995.86M Jun 19 48.32 44.69 37.03 37.10 46.95 51.67 47.77 May 19 Apr 19 -6.62% 8.12% 20.69% -22.43% -14.70% -12.52% 47.74 56.52 59 23 Mar 10 55.97 61.39 61.43 63.98 64.85 Feb 19 Jan 19 61.08 61.22 35 40 1.078 36.82 1.41B 46.23 1.15B 50.89 1.078 57.75 642.75M 55,86 878.30M 58.82 732.26M 65.00 665.10M Average: 334.67 4.20% 61.40 70.40 -7.75% Dec 18 Nov 18 Highest 1,115.21 66.56 72.00 70.10 67.65 Lowest:35.40 75.90 73,35 Difference: 1,079.81 -5.05% 3.91% Change %: 1,551.35 Stc