Plot your monthly stock returns against the S P returns Add the Excel's regression line, then add the approximate 95 prediction intervals, stating how those were computed Add a vertical cut anywhere you choose and explain how the intersection of that line with the two prediction interval lines is informative HAS Stock Date Open High Low Close Adj Close Volume Monthly Returns Montly Return in 2017 06 01 105 32 113 489998 104 910004 111 510002 96 878815 18823800 4 89127 5 04886 2017 07 01 112 089996 116 199997 103 68 105 879997 91 987541 21853000 6 17018 6 70763 2017 08 01 106 080002 106 800003 93 730003 98 25 85 81736 29495800 0 50659 0 59031 2017 09 01 98 449997 99 089996 91 57 97 669998 85 310768 28113900 4 43717 5 20119 2017 10 01 97 349998 98 93 88 660004 92 589996 80 873596 39225400 0 86359 1 06782 2017 11 01 92 900002 99 169998 87 919998 93 019997 81 737183 28472500 1 87162 2 28980 2017 12 01 92 639999 97 169998 90 029999 90 889999 79 865562 24062900 3 23362 4 04883 2018 01 01 91 559998 97 459999 88 300003 94 57 83 099182 33893000 1 38955 1 67216 2018 02 01 94 339996 103 389999 89 889999 95 57 84 488731 39670900 9 96323 11 79238 2018 03 01 96 059998 97 160004 83 559998 84 300003 74 525497 29977900 3 35055 4 49584 2018 04 01 83 970001 89 059998 79 88 089996 77 876045 40703000 0 62754 0 80582 2018 05 01 88 89 209999 85 309998 86 75 77 248505 20515700 4 95102 6 40921 2018 06 01 87 220001 93 86 279999 92 309998 82 199524 22295500 6 50046 7 90815 2018 07 01 91 75 107 580002 91 699997 99 610001 88 699982 39660300 0 29807 0 33605 2018 08 01 99 379997 102 519997 97 220001 99 309998 88 998055 15977000 5 20670 5 85035 2018 09 01 98 75 109 599998 98 650002 105 120003 94 20475 20561200 12 01756 12 75685 2018 10 01 106 110001 107 57 89 889999 91 709999 82 187195 39613800 0 07298 0 08880 2018 11 01 92 050003 100 849998 90 970001 91 82 114212 24238700 8 79797 10 71430 2018 12 01 91 470001 91 510002 76 839996 81 25 73 316246 27703400 8 40092 11 45848 2019 01 01 79 889999 91 540001 77 339996 90 559998 81 717171 23375400 4 57354 5 59679 2019 02 01 90 540001 93 190002 82 879997 84 900002 77 143631 34300600 0 10902 0 14133 2019 03 01 85 790001 90 040001 82 870003 85 019997 77 252655 19848400 15 30152 19 80711 2019 04 01 85 459999 103 599998 84 610001 101 860001 92 554176 29382000 5 52427 5 96869 2019 05 01 101 900002 105 95 099998 95 139999 87 029907 21764700 9 64153 11 07841 2019 06 01 95 209999 108 860001 94 580002 105 68 96 67144 17327300 14 16041 14 64797 2019 07 01 106 699997 126 870003 104 470001 121 160004 110 831848 24574900 9 22322 8 32181 2019 08 01 121 589996 122 190002 103 040001 110 470001 101 608627 21211200 7 56062 7 44093 2019 09 01 109 82 121 480003 108 089996 118 690002 109 16925 15384600 19 66500 18 01331 2019 10 01 118 949997 123 050003 94 190002 97 309998 89 50425 31959000 4 68292 5 23207 2019 11 01 97 790001 102 699997 92 589996 101 699997 94 187172 35831200 3 62116 3 84464 2019 12 01 102 599998 106 269997 98 07 105 610001 97 808334 20493100 3 46374 3 54135 2020 01 01 106 169998 106 25 100 620003 101 870003 94 344597 20827600 22 33172 23 67037 2020 02 01 102 690002 109 5 75 629997 77 25 72 012878 33799200 5 31356 7 37862 2020 03 01 77 32 80 120003 41 330002 71 550003 66 699318 52967900 0 61526 0 92245 2020 04 01 68 040001 80 489998 66 470001 72 209999 67 314583 32395300 1 85699 2 75868 2020 05 01 70 650002 74 959999 60 200001 73 510002 69 171577 22626300 1 35501 1 95891 2020 06 01 73 559998 83 989998 69 330002 74 949997 70 526588 25540300 2 06074 2 92193 2020 07 01 74 690002 80 800003 70 779999 72 760002 68 465851 23129800 6 51080 9 50956 2020 08 01 72 959999 82 080002 72 279999 78 940002 74 976654 13636800 3 59023 4 78846 2020 09 01 78 57 85 82 75 25 82 720001 78 566879 20357500 0 00000 0 00000 2020 10 01 82 989998 92 949997 80 239998 82 720001 78 566879 23669600 10 51463 13 38303 2020 11 01 83 529999 94 300003 82 010002 93 029999 89 081505 17257100 0 48834 0 54820 2020 12 01 94 339996 97 129997 87 519997 93 540001 89 569847 20843700 0 26813 0 29935 2021 01 01 93 739998 101 239998 90 389999 93 82 89 837975 15161100 0 10533 0 11725 2021 02 01 93 75 99 68 89 160004 93 709999 89 732643 20687900 2 97968 3 32061 2021 03 01 94 139999 99 489998 90 32 96 120003 92 712318 21142300 3 21195 3 46442 2021 04 01 96 25 100 510002 94 360001 99 449997 95 924263 19235300 2 71700 2 83244 2021 05 01 99 709999 101 099998 92 75 95 970001 93 207268 12839200 1 40826 1 51089 2021 06 01 96 5 97 639999 90 550003 94 519997 91 799011 14471400 4 77837 5 20525 2021 07 01 94 900002 104 889999 90 82 99 440002 96 577377 19174500 0 44697 0 46281 2021 08 01 100 07 101 599998 94 290001 98 309998 96 130409 11179500 8 88847 9 24626 2021 09 01 98 540001 100 949997 88 82 89 220001 87 241943 12414600 6 39501 7 33020 2021 10 01 89 279999 96 669998 86 050003 95 760002 93 636948 21783500 1 79636 1 91843 2021 11 01 95 879997 101 199997 92 07 96 910004 95 433311 14018700 4 79578 5 02527 2021 12 01 97 57 102 790001 95 099998 101 779999 100 229095 15703100 9 15828 9 13735 2022 01 01 102 220001 105 730003 85 970001 92 480003 91 070816 23010700 5 22820 5 74080 2022 02 01 92 75 105 129997 89 660004 97 050003 96 299011 27118900 15 01293 15 58991 2022 03 01 96 559998 97 550003 81 160004 81 919998 81 286079 31070000 6 09249 7 49512 2022 04 01 82 339996 92 519997 81 839996 88 059998 87 378571 26525300 0 61857 0 70792 2022 05 01 87 879997 94 220001 86 599998 86 760002 86 760002 14819400 S P 500 Date Open High Low Close Adj Close Volume Monthly Returns Montly Return in 1 Jun 17 2,415 65 2,453 82 2,405 70 2,423 41 2,423 41 81,002,490,000 46 89 1 934876888 1 Jul 17 2,431 39 2,484 04 2,407 70 2,470 30 2,470 30 63,169,400,000 1 35 0 054649233 1 Aug 17 2,477 10 2,490 87 2,417 35 2,471 65 2,471 65 70,616,030,000 47 71 1 930289483 1 Sep 17 2,474 42 2,519 44 2,446 55 2,519 36 2,519 36 66,337,980,000 55 90 2 218817477 1 Oct 17 2,521 20 2,582 98 2,520 40 2,575 26 2,575 26 70,871,570,000 72 32 2 808260137 1 Nov 17 2,583 21 2,657 74 2,557 45 2,647 58 2,647 58 73,173,260,000 26 03 0 983161982 1 Dec 17 2,645 10 2,694 97 2,605 52 2,673 61 2,673 61 65,251,190,000 150 20 5 617872465 1 Jan 18 2,683 73 2,872 87 2,682 36 2,823 81 2,823 81 76,860,120,000 109 98 3 89473796 1 Feb 18 2,816 45 2,835 96 2,532 69 2,713 83 2,713 83 79,579,410,000 72 96 2 688451377 1 Mar 18 2,715 22 2,801 90 2,585 89 2,640 87 2,640 87 76,369,800,000 7 18 0 2718801 1 Apr 18 2,633 45 2,717 49 2,553 80 2,648 05 2,648 05 69,648,590,000 57 22 2 160835332 1 May 18 2,642 96 2,742 24 2,594 62 2,705 27 2,705 27 75,617,280,000 13 10 0 48424002 1 Jun 18 2,718 70 2,791 47 2,691 99 2,718 37 2,718 37 77,439,710,000 97 92 3 602158647 1 Jul 18 2,704 95 2,848 03 2,698 95 2,816 29 2,816 29 64,542,170,000 85 23 3 026321863 1 Aug 18 2,821 17 2,916 50 2,796 34 2,901 52 2,901 52 69,238,220,000 12 46 0 429430092 1 Sep 18 2,896 96 2,940 91 2,864 12 2,913 98 2,913 98 62,492,080,000 202 24 6 940335898 1 Oct 18 2,926 29 2,939 86 2,603 54 2,711 74 2,711 74 91,327,930,000 48 43 1 78593818 1 Nov 18 2,717 58 2,815 15 2,631 09 2,760 17 2,760 17 80,080,110,000 253 32 9 177695577 1 Dec 18 2,790 50 2,800 18 2,346 58 2,506 85 2,506 85 83,522,570,000 197 25 7 868440473 1 Jan 19 2,476 96 2,708 95 2,443 96 2,704 10 2,704 10 80,401,630,000 80 39 2 972893014 1 Feb 19 2,702 32 2,813 49 2,681 83 2,784 49 2,784 49 70,183,430,000 49 91 1 792428775 1 Mar 19 2,798 22 2,860 31 2,722 27 2,834 40 2,834 40 78,596,280,000 111 43 3 931343494 1 Apr 19 2,848 63 2,949 52 2,848 63 2,945 83 2,945 83 69,604,840,000 193 77 6 577772648 1 May 19 2,952 33 2,954 13 2,750 52 2,752 06 2,752 06 76,860,120,000 189 70 6 893018321 1 Jun 19 2,751 53 2,964 15 2,728 81 2,941 76 2,941 76 70,904,280,000 38 62 1 312819537 1 Jul 19 2,971 41 3,027 98 2,952 22 2,980 38 2,980 38 70,349,470,000 53 92 1 809165274 1 Aug 19 2,980 32 3,013 59 2,822 12 2,926 46 2,926 46 79,599,440,000 50 28 1 718116769 1 Sep 19 2,909 01 3,021 99 2,891 85 2,976 74 2,976 74 73,992,330,000 60 82 2 043174748 1 Oct 19 2,983 69 3,050 10 2,855 94 3,037 56 3,037 56 77,564,550,000 103 42 3 404706409 1 Nov 19 3,050 72 3,154 26 3,050 72 3,140 98 3,140 98 72,179,920,000 89 80 2 858980318 1 Dec 19 3,143 85 3,247 93 3,070 33 3,230 78 3,230 78 72,054,000,000 5 26 0 162808981 1 Jan 20 3,244 67 3,337 77 3,214 64 3,225 52 3,225 52 77,104,420,000 271 30 8 411046901 1 Feb 20 3,235 66 3,393 52 2,855 84 2,954 22 2,954 22 84,292,270,000 369 63 12 51193208 1 Mar 20 2,974 28 3,136 72 2,191 86 2,584 59 2,584 59 161,801,100,000 327 84 12 68441029 1 Apr 20 2,498 08 2,954 86 2,447 49 2,912 43 2,912 43 123,163,450,000 131 88 4 528177501 1 May 20 2,869 09 3,068 67 2,766 64 3,044 31 3,044 31 106,799,100,000 55 98 1 838840328 1 Jun 20 3,038 78 3,233 13 2,965 66 3,100 29 3,100 29 131,044,000,000 170 83 5 510129698 1 Jul 20 3,105 92 3,279 99 3,101 17 3,271 12 3,271 12 97,197,020,000 229 19 7 006468732 1 Aug 20 3,288 26 3,514 77 3,284 53 3,500 31 3,500 31 84,402,300,000 137 31 3 92279541 1 Sep 20 3,507 44 3,588 11 3,209 45 3,363 00 3,363 00 92,084,120,000 93 04 2 766577461 1 Oct 20 3,385 87 3,549 85 3,233 94 3,269 96 3,269 96 89,737,600,000 351 67 10 75456581 1 Nov 20 3,296 20 3,645 99 3,279 74 3,621 63 3,621 63 100,977,880,000 134 44 3 712140666 1 Dec 20 3,645 87 3,760 20 3,633 40 3,756 07 3,756 07 96,056,410,000 41 83 1 113664016 1 Jan 21 3,764 61 3,870 90 3,662 71 3,714 24 3,714 24 105,548,790,000 96 91 2 609147497 1 Feb 21 3,731 17 3,950 43 3,725 62 3,811 15 3,811 15 98,596,960,000 161 74 4 243863401 1 Mar 21 3,842 51 3,994 41 3,723 34 3,972 89 3,972 89 120,863,560,000 208 28 5 242531256 1 Apr 21 3,992 78 4,218 78 3,992 78 4,181 17 4,181 17 82,869,290,000 22 94 0 548650258 1 May 21 4,191 98 4,238 04 4,056 88 4,204 11 4,204 11 75,155,370,000 93 39 2 221397632 1 Jun 21 4,216 52 4,302 43 4,164 40 4,297 50 4,297 50 85,705,180,000 97 76 2 274810937 1 Jul 21 4,300 73 4,429 97 4,233 13 4,395 26 4,395 26 66,496,430,000 127 42 2 899032139 1 Aug 21 4,406 86 4,537 36 4,367 73 4,522 68 4,522 68 63,217,960,000 215 14 4 756914042 1 Sep 21 4,528 80 4,545 85 4,305 91 4,307 54 4,307 54 66,268,850,000 297 84 6 91438733 1 Oct 21 4,317 16 4,608 08 4,278 94 4,605 38 4,605 38 61,874,700,000 38 38 0 833373142 1 Nov 21 4,610 62 4,743 83 4,560 00 4,567 00 4,567 00 67,520,800,000 199 18 4 361287497 1 Dec 21 4,602 82 4,808 93 4,495 12 4,766 18 4,766 18 68,699,830,000 250 63 5 258508911 1 Jan 22 4,778 14 4,818 62 4,222 62 4,515 55 4,515 55 73,279,440,000 141 61 3 136052087 1 Feb 22 4,519 57 4,595 31 4,114 65 4,373 94 4,373 94 73,167,790,000 156 47 3 577323877 1 Mar 22 4,363 14 4,637 30 4,157 87 4,530 41 4,530 41 100,978,320,000 398 48 8 795671915 1 Apr 22 4,540 32 4,593 45 4,124 28 4,131 93 4,131 93 74,784,850,000 230 57 5 58020102 1 May 22 4,130 61 4,307 66 3,810 32 3,901 36 3,901 36 64,796,810,000 0 00 0 3,927 76 3,943 42 3,810 32 3,901 36 3,901 36 3,002,384,000 Adj Close Monthly Return in DATE S P 500 HAS S P 500 HAS 1 May 22 3,901 36 86 760002 5 58 0 71 1 Apr 22 4,131 93 87 378571 8 80 7 50 1 Mar 22 4,530 41 81 286079 3 58 15 59 1 Feb 22 4,373 94 96 299011 3 14 5 74 1 Jan 22 4,515 55 91 070816 5 26 9 14 1 Dec 21 4,766 18 4 36 5 03 1 Nov 21 4,567 00 95 433311 0 83 1 92 1 Oct 21 4,605 38 93 636948 6 91 7 33 1 Sep 21 4,307 54 87 241943 4 76 9 25 1 Aug 21 4,522 68 96 130409 2 90 0 46 1 Jul 21 4,395 26 96 577377 2 27 5 21 1 Jun 21 4,297 50 91 799011 2 22 1 51 1 May 21 4,204 11 93 207268 0 55 2 83 1 Apr 21 4,181 17 95 924263 5 24 3 46 1 Mar 21 3,972 89 92 712318 4 24 3 32 1 Feb 21 3,811 15 89 732643 2 61 0 12 1 Jan 21 3,714 24 89 837975 1 11 0 30 1 Dec 20 3,756 07 89 569847 3 71 0 55 1 Nov 20 3,621 63 89 081505 10 75 13 38 1 Oct 20 3,269 96 78 566879 2 77 0 00 1 Sep 20 3,363 00 78 566879 3 92 4 79 1 Aug 20 3,500 31 74 976654 7 01 9 51 1 Jul 20 3,271 12 68 465851 5 51 2 92 1 Jun 20 3,100 29 70 526588 1 84 1 96 1 May 20 3,044 31 69 171577 4 53 2 76 1 Apr 20 2,912 43 67 314583 12 68 0 92 1 Mar 20 2,584 59 66 699318 12 51 7 38 1 Feb 20 2,954 22 72 012878 8 41 23 67 1 Jan 20 3,225 52 94 344597 0 16 3 54 1 Dec 19 3,230 78 97 808334 2 86 3 84 1 Nov 19 3,140 98 94 187172 3 40 5 23 1 Oct 19 3,037 56 89 50425 2 04 18 01 1 Sep 19 2,976 74 109 16925 1 72 7 44 1 Aug 19 2,926 46 1 81 8 32 1 Jul 19 2,980 38 1 31 14 65 1 Jun 19 2,941 76 96 67144 6 89 11 08 1 May 19 2,752 06 87 029907 6 58 5 97 1 Apr 19 2,945 83 92 554176 3 93 19 81 1 Mar 19 2,834 40 77 252655 1 79 0 14 1 Feb 19 2,784 49 77 143631 2 97 5 60 1 Jan 19 2,704 10 81 717171 7 87 11 46 1 Dec 18 2,506 85 73 316246 9 18 10 71 1 Nov 18 2,760 17 82 114212 1 79 0 09 1 Oct 18 2,711 74 82 187195 6 94 12 76 1 Sep 18 2,913 98 94 20475 0 43 5 85 1 Aug 18 2,901 52 88 998055 3 03 0 34 1 Jul 18 2,816 29 88 699982 3 60 7 91 1 Jun 18 2,718 37 82 199524 0 48 6 41 1 May 18 2,705 27 77 248505 2 16 0 81 1 Apr 18 2,648 05 77 876045 0 27 4 50 1 Mar 18 2,640 87 74 525497 2 69 11 79 1 Feb 18 2,713 83 84 488731 3 89 1 67 1 Jan 18 2,823 81 83 099182 5 62 4 05 1 Dec 17 2,673 61 79 865562 0 98 2 29 1 Nov 17 2,647 58 81 737183 2 81 1 07 1 Oct 17 2,575 26 80 873596 2 22 5 20 1 Sep 17 2,519 36 85 310768 1 93 0 59 1 Aug 17 2,471 65 85 81736 0 05 6 71 1 Jul 17 2,470 30 91 987541 1 93 5 05 1 Jun 17 2,423 41 96 878815 SUMMARY OUTPUT Regression Statistics Multiple R 0 49835972 R Square 0 24836241 Adjusted R Square 0 23494031 Standard Error 0 07049137 Observations 58 ANOVA df SS MS F Significance F Regression 1 0 09194695 0 09194695 18 5039908 6 859E 05 Residual 56 0 27826588 0 00496903 Total 57 0 37021283 Coefficients Standard Error t Stat P value Lower 95 Upper 95 Lower 95 0 Upper 95 0 Intercept 0 00715 0 00947276 0 7547956 0 45353435 0 0261262 0 01182622 0 0261262 0 01182622 0 055802 0 83405879 0 19389382 4 30162653 6 859E 05 0 4456428 1 22247478 0 4456428 1 22247478

The Answer is in the image, click to view ...

Question: Plot your monthly stock returns against the S&P returns. Add the Excel's regression line, then add the approximate 95% prediction intervals, stating how those were

Plot your monthly stock returns against the S&P returns. Add the Excel's regression line, then add the approximate 95% prediction intervals, stating how those were computed. Add a vertical cut anywhere you choose and explain how the intersection of that line with the two prediction interval lines is informative.

HAS Stock

Date	Open	High	Low	Close	Adj Close	Volume	Monthly Returns	Montly Return in %
2017-06-01	105.32	113.489998	104.910004	111.510002	96.878815	18823800	-4.89127	-5.04886
2017-07-01	112.089996	116.199997	103.68	105.879997	91.987541	21853000	-6.17018	-6.70763
2017-08-01	106.080002	106.800003	93.730003	98.25	85.81736	29495800	-0.50659	-0.59031
2017-09-01	98.449997	99.089996	91.57	97.669998	85.310768	28113900	-4.43717	-5.20119
2017-10-01	97.349998	98.93	88.660004	92.589996	80.873596	39225400	0.86359	1.06782
2017-11-01	92.900002	99.169998	87.919998	93.019997	81.737183	28472500	-1.87162	-2.28980
2017-12-01	92.639999	97.169998	90.029999	90.889999	79.865562	24062900	3.23362	4.04883
2018-01-01	91.559998	97.459999	88.300003	94.57	83.099182	33893000	1.38955	1.67216
2018-02-01	94.339996	103.389999	89.889999	95.57	84.488731	39670900	-9.96323	-11.79238
2018-03-01	96.059998	97.160004	83.559998	84.300003	74.525497	29977900	3.35055	4.49584
2018-04-01	83.970001	89.059998	79	88.089996	77.876045	40703000	-0.62754	-0.80582
2018-05-01	88	89.209999	85.309998	86.75	77.248505	20515700	4.95102	6.40921
2018-06-01	87.220001	93	86.279999	92.309998	82.199524	22295500	6.50046	7.90815
2018-07-01	91.75	107.580002	91.699997	99.610001	88.699982	39660300	0.29807	0.33605
2018-08-01	99.379997	102.519997	97.220001	99.309998	88.998055	15977000	5.20670	5.85035
2018-09-01	98.75	109.599998	98.650002	105.120003	94.20475	20561200	-12.01756	-12.75685
2018-10-01	106.110001	107.57	89.889999	91.709999	82.187195	39613800	-0.07298	-0.08880
2018-11-01	92.050003	100.849998	90.970001	91	82.114212	24238700	-8.79797	-10.71430
2018-12-01	91.470001	91.510002	76.839996	81.25	73.316246	27703400	8.40092	11.45848
2019-01-01	79.889999	91.540001	77.339996	90.559998	81.717171	23375400	-4.57354	-5.59679
2019-02-01	90.540001	93.190002	82.879997	84.900002	77.143631	34300600	0.10902	0.14133
2019-03-01	85.790001	90.040001	82.870003	85.019997	77.252655	19848400	15.30152	19.80711
2019-04-01	85.459999	103.599998	84.610001	101.860001	92.554176	29382000	-5.52427	-5.96869
2019-05-01	101.900002	105	95.099998	95.139999	87.029907	21764700	9.64153	11.07841
2019-06-01	95.209999	108.860001	94.580002	105.68	96.67144	17327300	14.16041	14.64797
2019-07-01	106.699997	126.870003	104.470001	121.160004	110.831848	24574900	-9.22322	-8.32181
2019-08-01	121.589996	122.190002	103.040001	110.470001	101.608627	21211200	7.56062	7.44093
2019-09-01	109.82	121.480003	108.089996	118.690002	109.16925	15384600	-19.66500	-18.01331
2019-10-01	118.949997	123.050003	94.190002	97.309998	89.50425	31959000	4.68292	5.23207
2019-11-01	97.790001	102.699997	92.589996	101.699997	94.187172	35831200	3.62116	3.84464
2019-12-01	102.599998	106.269997	98.07	105.610001	97.808334	20493100	-3.46374	-3.54135
2020-01-01	106.169998	106.25	100.620003	101.870003	94.344597	20827600	-22.33172	-23.67037
2020-02-01	102.690002	109.5	75.629997	77.25	72.012878	33799200	-5.31356	-7.37862
2020-03-01	77.32	80.120003	41.330002	71.550003	66.699318	52967900	0.61526	0.92245
2020-04-01	68.040001	80.489998	66.470001	72.209999	67.314583	32395300	1.85699	2.75868
2020-05-01	70.650002	74.959999	60.200001	73.510002	69.171577	22626300	1.35501	1.95891
2020-06-01	73.559998	83.989998	69.330002	74.949997	70.526588	25540300	-2.06074	-2.92193
2020-07-01	74.690002	80.800003	70.779999	72.760002	68.465851	23129800	6.51080	9.50956
2020-08-01	72.959999	82.080002	72.279999	78.940002	74.976654	13636800	3.59023	4.78846
2020-09-01	78.57	85.82	75.25	82.720001	78.566879	20357500	0.00000	0.00000
2020-10-01	82.989998	92.949997	80.239998	82.720001	78.566879	23669600	10.51463	13.38303
2020-11-01	83.529999	94.300003	82.010002	93.029999	89.081505	17257100	0.48834	0.54820
2020-12-01	94.339996	97.129997	87.519997	93.540001	89.569847	20843700	0.26813	0.29935
2021-01-01	93.739998	101.239998	90.389999	93.82	89.837975	15161100	-0.10533	-0.11725
2021-02-01	93.75	99.68	89.160004	93.709999	89.732643	20687900	2.97968	3.32061
2021-03-01	94.139999	99.489998	90.32	96.120003	92.712318	21142300	3.21195	3.46442
2021-04-01	96.25	100.510002	94.360001	99.449997	95.924263	19235300	-2.71700	-2.83244
2021-05-01	99.709999	101.099998	92.75	95.970001	93.207268	12839200	-1.40826	-1.51089
2021-06-01	96.5	97.639999	90.550003	94.519997	91.799011	14471400	4.77837	5.20525
2021-07-01	94.900002	104.889999	90.82	99.440002	96.577377	19174500	-0.44697	-0.46281
2021-08-01	100.07	101.599998	94.290001	98.309998	96.130409	11179500	-8.88847	-9.24626
2021-09-01	98.540001	100.949997	88.82	89.220001	87.241943	12414600	6.39501	7.33020
2021-10-01	89.279999	96.669998	86.050003	95.760002	93.636948	21783500	1.79636	1.91843
2021-11-01	95.879997	101.199997	92.07	96.910004	95.433311	14018700	4.79578	5.02527
2021-12-01	97.57	102.790001	95.099998	101.779999	100.229095	15703100	-9.15828	-9.13735
2022-01-01	102.220001	105.730003	85.970001	92.480003	91.070816	23010700	5.22820	5.74080
2022-02-01	92.75	105.129997	89.660004	97.050003	96.299011	27118900	-15.01293	-15.58991
2022-03-01	96.559998	97.550003	81.160004	81.919998	81.286079	31070000	6.09249	7.49512
2022-04-01	82.339996	92.519997	81.839996	88.059998	87.378571	26525300	-0.61857	-0.70792
2022-05-01	87.879997	94.220001	86.599998	86.760002	86.760002	14819400

S&P 500

Date	Open	High	Low	Close*	Adj Close**	Volume	Monthly Returns	Montly Return in %
1-Jun-17	2,415.65	2,453.82	2,405.70	2,423.41	2,423.41	81,002,490,000	46.89	1.934876888
1-Jul-17	2,431.39	2,484.04	2,407.70	2,470.30	2,470.30	63,169,400,000	1.35	0.054649233
1-Aug-17	2,477.10	2,490.87	2,417.35	2,471.65	2,471.65	70,616,030,000	47.71	1.930289483
1-Sep-17	2,474.42	2,519.44	2,446.55	2,519.36	2,519.36	66,337,980,000	55.90	2.218817477
1-Oct-17	2,521.20	2,582.98	2,520.40	2,575.26	2,575.26	70,871,570,000	72.32	2.808260137
1-Nov-17	2,583.21	2,657.74	2,557.45	2,647.58	2,647.58	73,173,260,000	26.03	0.983161982
1-Dec-17	2,645.10	2,694.97	2,605.52	2,673.61	2,673.61	65,251,190,000	150.20	5.617872465
1-Jan-18	2,683.73	2,872.87	2,682.36	2,823.81	2,823.81	76,860,120,000	-109.98	-3.89473796
1-Feb-18	2,816.45	2,835.96	2,532.69	2,713.83	2,713.83	79,579,410,000	-72.96	-2.688451377
1-Mar-18	2,715.22	2,801.90	2,585.89	2,640.87	2,640.87	76,369,800,000	7.18	0.2718801
1-Apr-18	2,633.45	2,717.49	2,553.80	2,648.05	2,648.05	69,648,590,000	57.22	2.160835332
1-May-18	2,642.96	2,742.24	2,594.62	2,705.27	2,705.27	75,617,280,000	13.10	0.48424002
1-Jun-18	2,718.70	2,791.47	2,691.99	2,718.37	2,718.37	77,439,710,000	97.92	3.602158647
1-Jul-18	2,704.95	2,848.03	2,698.95	2,816.29	2,816.29	64,542,170,000	85.23	3.026321863
1-Aug-18	2,821.17	2,916.50	2,796.34	2,901.52	2,901.52	69,238,220,000	12.46	0.429430092
1-Sep-18	2,896.96	2,940.91	2,864.12	2,913.98	2,913.98	62,492,080,000	-202.24	-6.940335898
1-Oct-18	2,926.29	2,939.86	2,603.54	2,711.74	2,711.74	91,327,930,000	48.43	1.78593818
1-Nov-18	2,717.58	2,815.15	2,631.09	2,760.17	2,760.17	80,080,110,000	-253.32	-9.177695577
1-Dec-18	2,790.50	2,800.18	2,346.58	2,506.85	2,506.85	83,522,570,000	197.25	7.868440473
1-Jan-19	2,476.96	2,708.95	2,443.96	2,704.10	2,704.10	80,401,630,000	80.39	2.972893014
1-Feb-19	2,702.32	2,813.49	2,681.83	2,784.49	2,784.49	70,183,430,000	49.91	1.792428775
1-Mar-19	2,798.22	2,860.31	2,722.27	2,834.40	2,834.40	78,596,280,000	111.43	3.931343494
1-Apr-19	2,848.63	2,949.52	2,848.63	2,945.83	2,945.83	69,604,840,000	-193.77	-6.577772648
1-May-19	2,952.33	2,954.13	2,750.52	2,752.06	2,752.06	76,860,120,000	189.70	6.893018321
1-Jun-19	2,751.53	2,964.15	2,728.81	2,941.76	2,941.76	70,904,280,000	38.62	1.312819537
1-Jul-19	2,971.41	3,027.98	2,952.22	2,980.38	2,980.38	70,349,470,000	-53.92	-1.809165274
1-Aug-19	2,980.32	3,013.59	2,822.12	2,926.46	2,926.46	79,599,440,000	50.28	1.718116769
1-Sep-19	2,909.01	3,021.99	2,891.85	2,976.74	2,976.74	73,992,330,000	60.82	2.043174748
1-Oct-19	2,983.69	3,050.10	2,855.94	3,037.56	3,037.56	77,564,550,000	103.42	3.404706409
1-Nov-19	3,050.72	3,154.26	3,050.72	3,140.98	3,140.98	72,179,920,000	89.80	2.858980318
1-Dec-19	3,143.85	3,247.93	3,070.33	3,230.78	3,230.78	72,054,000,000	-5.26	-0.162808981
1-Jan-20	3,244.67	3,337.77	3,214.64	3,225.52	3,225.52	77,104,420,000	-271.30	-8.411046901
1-Feb-20	3,235.66	3,393.52	2,855.84	2,954.22	2,954.22	84,292,270,000	-369.63	-12.51193208
1-Mar-20	2,974.28	3,136.72	2,191.86	2,584.59	2,584.59	161,801,100,000	327.84	12.68441029
1-Apr-20	2,498.08	2,954.86	2,447.49	2,912.43	2,912.43	123,163,450,000	131.88	4.528177501
1-May-20	2,869.09	3,068.67	2,766.64	3,044.31	3,044.31	106,799,100,000	55.98	1.838840328
1-Jun-20	3,038.78	3,233.13	2,965.66	3,100.29	3,100.29	131,044,000,000	170.83	5.510129698
1-Jul-20	3,105.92	3,279.99	3,101.17	3,271.12	3,271.12	97,197,020,000	229.19	7.006468732
1-Aug-20	3,288.26	3,514.77	3,284.53	3,500.31	3,500.31	84,402,300,000	-137.31	-3.92279541
1-Sep-20	3,507.44	3,588.11	3,209.45	3,363.00	3,363.00	92,084,120,000	-93.04	-2.766577461
1-Oct-20	3,385.87	3,549.85	3,233.94	3,269.96	3,269.96	89,737,600,000	351.67	10.75456581
1-Nov-20	3,296.20	3,645.99	3,279.74	3,621.63	3,621.63	100,977,880,000	134.44	3.712140666
1-Dec-20	3,645.87	3,760.20	3,633.40	3,756.07	3,756.07	96,056,410,000	-41.83	-1.113664016
1-Jan-21	3,764.61	3,870.90	3,662.71	3,714.24	3,714.24	105,548,790,000	96.91	2.609147497
1-Feb-21	3,731.17	3,950.43	3,725.62	3,811.15	3,811.15	98,596,960,000	161.74	4.243863401
1-Mar-21	3,842.51	3,994.41	3,723.34	3,972.89	3,972.89	120,863,560,000	208.28	5.242531256
1-Apr-21	3,992.78	4,218.78	3,992.78	4,181.17	4,181.17	82,869,290,000	22.94	0.548650258
1-May-21	4,191.98	4,238.04	4,056.88	4,204.11	4,204.11	75,155,370,000	93.39	2.221397632
1-Jun-21	4,216.52	4,302.43	4,164.40	4,297.50	4,297.50	85,705,180,000	97.76	2.274810937
1-Jul-21	4,300.73	4,429.97	4,233.13	4,395.26	4,395.26	66,496,430,000	127.42	2.899032139
1-Aug-21	4,406.86	4,537.36	4,367.73	4,522.68	4,522.68	63,217,960,000	-215.14	-4.756914042
1-Sep-21	4,528.80	4,545.85	4,305.91	4,307.54	4,307.54	66,268,850,000	297.84	6.91438733
1-Oct-21	4,317.16	4,608.08	4,278.94	4,605.38	4,605.38	61,874,700,000	-38.38	-0.833373142
1-Nov-21	4,610.62	4,743.83	4,560.00	4,567.00	4,567.00	67,520,800,000	199.18	4.361287497
1-Dec-21	4,602.82	4,808.93	4,495.12	4,766.18	4,766.18	68,699,830,000	-250.63	-5.258508911
1-Jan-22	4,778.14	4,818.62	4,222.62	4,515.55	4,515.55	73,279,440,000	-141.61	-3.136052087
1-Feb-22	4,519.57	4,595.31	4,114.65	4,373.94	4,373.94	73,167,790,000	156.47	3.577323877
1-Mar-22	4,363.14	4,637.30	4,157.87	4,530.41	4,530.41	100,978,320,000	-398.48	-8.795671915
1-Apr-22	4,540.32	4,593.45	4,124.28	4,131.93	4,131.93	74,784,850,000	-230.57	-5.58020102
1-May-22	4,130.61	4,307.66	3,810.32	3,901.36	3,901.36	64,796,810,000	0.00	0
########	3,927.76	3,943.42	3,810.32	3,901.36	3,901.36	3,002,384,000

	Adj Close	Monthly Return in %
DATE	S&P 500	HAS	S&P 500	HAS
1-May-22	3,901.36	86.760002	-5.58%	-0.71%
1-Apr-22	4,131.93	87.378571	-8.80%	7.50%
1-Mar-22	4,530.41	81.286079	3.58%	-15.59%
1-Feb-22	4,373.94	96.299011	-3.14%	5.74%
1-Jan-22	4,515.55	91.070816	-5.26%	-9.14%
1-Dec-21	4,766.18	########	4.36%	5.03%
1-Nov-21	4,567.00	95.433311	-0.83%	1.92%
1-Oct-21	4,605.38	93.636948	6.91%	7.33%
1-Sep-21	4,307.54	87.241943	-4.76%	-9.25%
1-Aug-21	4,522.68	96.130409	2.90%	-0.46%
1-Jul-21	4,395.26	96.577377	2.27%	5.21%
1-Jun-21	4,297.50	91.799011	2.22%	-1.51%
1-May-21	4,204.11	93.207268	0.55%	-2.83%
1-Apr-21	4,181.17	95.924263	5.24%	3.46%
1-Mar-21	3,972.89	92.712318	4.24%	3.32%
1-Feb-21	3,811.15	89.732643	2.61%	-0.12%
1-Jan-21	3,714.24	89.837975	-1.11%	0.30%
1-Dec-20	3,756.07	89.569847	3.71%	0.55%
1-Nov-20	3,621.63	89.081505	10.75%	13.38%
1-Oct-20	3,269.96	78.566879	-2.77%	0.00%
1-Sep-20	3,363.00	78.566879	-3.92%	4.79%
1-Aug-20	3,500.31	74.976654	7.01%	9.51%
1-Jul-20	3,271.12	68.465851	5.51%	-2.92%
1-Jun-20	3,100.29	70.526588	1.84%	1.96%
1-May-20	3,044.31	69.171577	4.53%	2.76%
1-Apr-20	2,912.43	67.314583	12.68%	0.92%
1-Mar-20	2,584.59	66.699318	-12.51%	-7.38%
1-Feb-20	2,954.22	72.012878	-8.41%	-23.67%
1-Jan-20	3,225.52	94.344597	-0.16%	-3.54%
1-Dec-19	3,230.78	97.808334	2.86%	3.84%
1-Nov-19	3,140.98	94.187172	3.40%	5.23%
1-Oct-19	3,037.56	89.50425	2.04%	-18.01%
1-Sep-19	2,976.74	109.16925	1.72%	7.44%
1-Aug-19	2,926.46	########	-1.81%	-8.32%
1-Jul-19	2,980.38	########	1.31%	14.65%
1-Jun-19	2,941.76	96.67144	6.89%	11.08%
1-May-19	2,752.06	87.029907	-6.58%	-5.97%
1-Apr-19	2,945.83	92.554176	3.93%	19.81%
1-Mar-19	2,834.40	77.252655	1.79%	0.14%
1-Feb-19	2,784.49	77.143631	2.97%	-5.60%
1-Jan-19	2,704.10	81.717171	7.87%	11.46%
1-Dec-18	2,506.85	73.316246	-9.18%	-10.71%
1-Nov-18	2,760.17	82.114212	1.79%	-0.09%
1-Oct-18	2,711.74	82.187195	-6.94%	-12.76%
1-Sep-18	2,913.98	94.20475	0.43%	5.85%
1-Aug-18	2,901.52	88.998055	3.03%	0.34%
1-Jul-18	2,816.29	88.699982	3.60%	7.91%
1-Jun-18	2,718.37	82.199524	0.48%	6.41%
1-May-18	2,705.27	77.248505	2.16%	-0.81%
1-Apr-18	2,648.05	77.876045	0.27%	4.50%
1-Mar-18	2,640.87	74.525497	-2.69%	-11.79%
1-Feb-18	2,713.83	84.488731	-3.89%	1.67%
1-Jan-18	2,823.81	83.099182	5.62%	4.05%
1-Dec-17	2,673.61	79.865562	0.98%	-2.29%
1-Nov-17	2,647.58	81.737183	2.81%	1.07%
1-Oct-17	2,575.26	80.873596	2.22%	-5.20%
1-Sep-17	2,519.36	85.310768	1.93%	-0.59%
1-Aug-17	2,471.65	85.81736	0.05%	-6.71%
1-Jul-17	2,470.30	91.987541	1.93%	-5.05%
1-Jun-17	2,423.41	96.878815

SUMMARY OUTPUT

Regression Statistics
Multiple R	0.49835972
R Square	0.24836241
Adjusted R Square	0.23494031
Standard Error	0.07049137
Observations	58

ANOVA
	df	SS	MS	F	Significance F
Regression	1	0.09194695	0.09194695	18.5039908	6.859E-05
Residual	56	0.27826588	0.00496903
Total	57	0.37021283

	Coefficients	Standard Error	t Stat	P-value	Lower 95%	Upper 95%	Lower 95.0%	Upper 95.0%
Intercept	-0.00715	0.00947276	-0.7547956	0.45353435	-0.0261262	0.01182622	-0.0261262	0.01182622
-0.055802	0.83405879	0.19389382	4.30162653	6.859E-05	0.4456428	1.22247478	0.4456428	1.22247478

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

Regression Download monthly prices for the past five years for stock Wynn Resorts Limited (WYNN) and for the S&P. Compute your monthly returns and those of the S&P. Using the Data Analysis option in...

D1. For your assigned stock and for the S&P, download monthly prices for the past five years. Compute your monthly returns and those of the S&P. Using the Data Analysis option in Excel, regress your...

For your assigned stock and for the S&P, download monthly prices for the past five years. Compute your monthly returns and those of the S&P. Using the Data Analysis option in Excel, regress your...

One of the requirements is to pick a high beta stock, run a regression and estimate its beta. S&P created a high beta index and you can pick one of the component stocks from this index. The list of...

Please use the excel doc (i couldnt attach a file so i added screenshots) attached and the information to solve the last 10 questions. thank you! locate information on the population density and...

This question is based to the stock data that can be obtained from the following link: http://biz.yahoo.com/r/ "Choose Research Tools" and then "Historical Quotes". Obtain monthly stock data for 5...

Hi Erylee88, I would like to utilize your service again. Same format different questions. Please find attached document for your review. Let me know. Thank you, Sam...

i will rate if done correctly Part I. Summary Statistics of Monthly Data ( 40 Points) Please obtain the monthly return data during the period Jan 2012 - Dec 2021 for the following: S\&P500 ETF (SPY),...

I need question one answered. Attached are documents from the chapter to help add in the question. A 1 D E F Final Examination FINC 5880 3 5 6 7 8 9 10 11 C Question 6. (15 points) Your portfolio is...

Consider the diprotic acid H2A with K1 = 1.00 10-4 and K2 = 1.00 10-8. Find the pH and concentrations of H2A, HA-, and A2- in (a) 0.100 M H2A; (b) 0.100 M NaHA; (c) 0.100 M Na2A.

This question is based on the section The Long-Run Industry Supply Curve found on this book's MyEconLab (www.myeconlab.com). A major theme of this chapter is the role that free entry and exit play in...

5. Modern technology has influenced how businesses collect and disburse cash. ISG (isg3d.com), a Canadian 3D printing start-up, has accepted cryptocurrency, such as Bitcoin, as payment currency....

Elmdale Enterprises is deciding whether to expand its production facilities. Although long-term cash flows are difficult to estimate, management has projected the following cash flows for the first...