Estimate for BTC, ETH, and LTC You can use regression or create a scatterplot with a trend line I recommend doing both to make sure you get the same results i BT C ii ET H iii LT C Which cryptocurrencys risk premium is best explained by the market risk premium Hint look at the R2 Date SPY return BTC return ETH return LTC return riskfree SPY RP BTC RP ETH RP LTC RP 2017 01 01 2 38943778 0 691059145 34 6136954 5 702507809 0 51 1 87943778 0 181059145 34 1036954 6 212507809 2017 02 01 3 929155246 21 59586819 47 44535073 7 542955495 0 52 3 409155246 21 07586819 46 92535073 8 062955495 2017 03 01 0 308694428 9 168024158 216 347394 76 7986656 0 74 1 048694428 9 908024158 215 607394 76 0586656 2017 04 01 1 431968394 25 76064023 57 92459225 135 5701014 0 8 0 631968394 24 96064023 57 12459225 134 7701014 2017 05 01 1 41129356 69 62881886 191 9077414 61 07375713 0 89 0 52129356 68 73881886 191 0177414 60 18375713 2017 06 01 0 149110484 8 503732204 27 85245409 59 51829818 0 98 0 830889516 7 523732204 26 87245409 58 53829818 2017 07 01 2 553100296 15 90187138 30 8714982 6 612430234 1 07 1 483100296 14 83187138 31 9414982 5 542430234 2017 08 01 0 291771374 63 57682893 87 88448982 65 15722479 1 01 0 718228626 62 56682893 86 87448982 64 14722479 2017 09 01 1 511169665 7 753559993 21 29714175 22 39487415 1 03 0 481169665 8 783559993 22 32714175 23 42487415 2017 10 01 2 864377575 49 08578725 1 464183921 1 109313362 1 07 1 794377575 48 01578725 0 394183921 0 039313362 2017 11 01 3 056595578 58 20913617 46 17349243 58 42907054 1 23 1 826595578 56 97913617 44 94349243 57 19907054 2017 12 01 0 698062132 38 3325607 69 24832309 162 758002 1 32 0 621937868 37 0125607 67 92832309 161 438002 2018 01 01 6 175883529 27 7987389 47 78133131 29 61920803 1 41 4 765883529 29 2087389 46 37133131 31 02920803 2018 02 01 3 636051684 1 729762831 23 52756124 24 2079978 1 57 5 206051684 0 159762831 25 09756124 22 6379978 2018 03 01 3 129038039 32 9332892 53 64154862 42 52840154 1 7 4 829038039 34 6332892 55 34154862 44 22840154 2018 04 01 0 91940807 32 50893149 68 9777225 27 33112288 1 76 0 84059193 30 74893149 67 2177225 25 57112288 2018 05 01 2 430907263 18 89909064 13 77454599 20 47657683 1 86 0 570907263 20 75909064 15 63454599 22 33657683 2018 06 01 0 125491739 14 54690691 21 20074142 31 08220009 1 9 1 774508261 16 44690691 23 10074142 32 98220009 2018 07 01 4 170325895 21 49344068 4 682321132 2 054341656 1 96 2 210325895 19 53344068 6 642321132 4 014341656 2018 08 01 3 191959435 9 547787383 34 77171682 22 30400098 2 03 1 161959435 11 57778738 36 80171682 24 33400098 2018 09 01 0 141270053 5 854569531 17 72271465 1 265391499 2 13 1 988729947 7 984569531 19 85271465 3 395391499 2018 10 01 6 489044861 4 647911924 15 23182889 19 1364632 2 25 8 739044861 6 897911924 17 48182889 21 3864632 2018 11 01 1 854925955 36 41157586 42 66346876 35 14606009 2 33 0 475074045 38 74157586 44 99346876 37 47606009 2018 12 01 9 334303643 6 834696567 17 84623674 4 979104476 2 37 11 70430364 9 204696567 15 47623674 7 349104476 2019 01 01 8 637275946 7 61235687 19 72526656 3 885858263 2 37 6 267275946 9 98235687 22 09526656 1 515858263 2019 02 01 3 24161682 11 481101 27 72739903 46 07923007 2 39 0 85161682 9 091100996 25 33739903 43 68923007 2019 03 01 1 363548766 6 501500628 3 486642697 31 39923207 2 4 1 036451234 4 101500628 1 086642697 28 99923207 2019 04 01 4 543706097 30 33373027 14 59355085 22 26218319 2 38 2 163706097 27 95373027 12 21355085 19 88218319 2019 05 01 6 37713195 60 2493017 65 33274839 54 19440799 2 35 8 72713195 57 8993017 62 98274839 51 84440799 2019 06 01 6 44097041 26 1549106 8 422710264 6 733335861 2 17 4 27097041 23 9849106 6 252710264 4 563335861 2019 07 01 2 005662368 6 76265917 24 78253707 19 4189872 2 1 0 094337632 8 86265917 26 88253707 21 5189872 2019 08 01 1 674339541 4 51101181 21 12210414 34 44693067 1 95 3 624339541 6 46101181 23 07210414 36 39693067 2019 09 01 1 477157244 13 88062018 4 292009682 13 19241731 1 89 0 412842756 15 77062018 2 402009682 15 08241731 2019 10 01 2 682483765 10 92031823 2 276455627 4 858949766 1 65 1 032483765 9 270318229 0 626455627 3 208949766 2019 11 01 3 619831491 17 71770232 17 08308818 19 23294191 1 54 2 079831491 19 25770232 18 62308818 20 77294191 2019 12 01 2 402081088 4 967624148 15 03138842 12 92322576 1 54 0 862081088 6 507624148 16 57138842 14 46322576 2020 01 01 0 451058161 29 98401968 39 000836 64 19780875 1 52 1 068941839 28 46401968 37 480836 62 67780875 2020 02 01 7 916559344 8 031850221 22 02947442 13 75412728 1 52 9 436559344 9 551850221 20 50947442 15 27412728 2020 03 01 12 99873069 25 12776382 39 23380859 32 87168897 0 29 13 28873069 25 41776382 39 52380859 33 16168897 2020 04 01 13 36107826 34 47789623 55 39823935 18 86790393 0 14 13 22107826 34 33789623 55 25823935 18 72790393 2020 05 01 4 764495358 9 268347923 11 25887576 2 402137517 0 13 4 634495358 9 138347923 11 12887576 2 532137517 2020 06 01 1 327563832 3 41468586 2 017833841 9 045671176 0 16 1 167563832 3 57468586 2 177833841 9 205671176 2020 07 01 6 355179786 23 9163413 52 68747275 39 86309327 0 13 6 225179786 23 7863413 52 55747275 39 73309327 2020 08 01 6 979663166 3 155866683 25 90764824 5 371996598 0 1 6 879663166 3 055866683 25 80764824 5 271996598 2020 09 01 4 128119432 7 646741625 17 25140607 24 26580898 0 11 4 238119432 7 756741625 17 36140607 24 37580898 2020 10 01 2 103042852 27 74826572 7 379531187 20 10676078 0 1 2 203042852 27 64826572 7 279531187 20 00676078 2020 11 01 10 87768205 42 41232778 59 04239659 57 53592626 0 09 10 78768205 42 32232778 58 95239659 57 44592626 2020 12 01 3 264655947 47 77317407 19 99875923 42 3817852 0 09 3 174655947 47 68317407 19 90875923 42 2917852 2021 01 01 0 597121956 14 18067126 78 22989096 3 914091232 0 08 0 677121956 14 10067126 78 14989096 3 834091232 2021 02 01 2 780544202 36 30875059 7 68546039 27 28728204 0 04 2 740544202 36 26875059 7 64546039 27 24728204 2021 03 01 4 198658525 30 53111096 35 47286349 19 74928085 0 03 4 168658525 30 50111096 35 44286349 19 71928085 2021 04 01 5 635896169 1 983502065 44 56119037 37 30041504 0 02 5 615896169 2 003502065 44 54119037 37 28041504 2021 05 01 0 656603769 35 35455959 2 100878779 30 65763247 0 02 0 636603769 35 37455959 2 120878779 30 67763247 2021 06 01 1 909342807 6 139416614 16 22123672 23 34573409 0 04 1 869342807 6 179416614 16 26123672 23 38573409 2021 07 01 2 776393237 18 79338549 11 50392954 0 553212881 0 05 2 726393237 18 74338549 11 45392954 0 503212881 2021 08 01 2 975988062 13 31010952 35 38834398 18 4402268 0 05 2 925988062 13 26010952 35 33834398 18 3902268 2021 09 01 4 965006941 7 157155077 12 58262518 10 78370825 0 04 5 005006941 7 197155077 12 62262518 10 82370825 2021 10 01 7 359197238 40 02672859 42 85585778 25 24902856 0 05 7 309197238 39 97672859 42 80585778 25 19902856

Question: Estimate for BTC, ETH, and LTC. You can use regression or create a scatterplot with a trend line. I recommend doing both to make

Estimate β for BTC, ETH, and LTC. You can use regression or create a scatterplot with a trend line. I recommend doing both to make sure you get the same results.

i. βBT C =

ii. βET H =

iii. βLT C =

Which cryptocurrency’s risk premium is best explained by the market risk premium? Hint: look at the R2 .

Date	SPY_return	BTC_return	ETH_return	LTC_return	riskfree	SPY RP	BTC RP	ETH RP	LTC RP
2017-01-01	2.38943778	0.691059145	34.6136954	-5.702507809	0.51	1.87943778	0.181059145	34.1036954	-6.212507809
2017-02-01	3.929155246	21.59586819	47.44535073	-7.542955495	0.52	3.409155246	21.07586819	46.92535073	-8.062955495
2017-03-01	-0.308694428	-9.168024158	216.347394	76.7986656	0.74	-1.048694428	-9.908024158	215.607394	76.0586656
2017-04-01	1.431968394	25.76064023	57.92459225	135.5701014	0.8	0.631968394	24.96064023	57.12459225	134.7701014
2017-05-01	1.41129356	69.62881886	191.9077414	61.07375713	0.89	0.52129356	68.73881886	191.0177414	60.18375713
2017-06-01	0.149110484	8.503732204	27.85245409	59.51829818	0.98	-0.830889516	7.523732204	26.87245409	58.53829818
2017-07-01	2.553100296	15.90187138	-30.8714982	6.612430234	1.07	1.483100296	14.83187138	-31.9414982	5.542430234
2017-08-01	0.291771374	63.57682893	87.88448982	65.15722479	1.01	-0.718228626	62.56682893	86.87448982	64.14722479
2017-09-01	1.511169665	-7.753559993	-21.29714175	-22.39487415	1.03	0.481169665	-8.783559993	-22.32714175	-23.42487415
2017-10-01	2.864377575	49.08578725	1.464183921	1.109313362	1.07	1.794377575	48.01578725	0.394183921	0.039313362
2017-11-01	3.056595578	58.20913617	46.17349243	58.42907054	1.23	1.826595578	56.97913617	44.94349243	57.19907054
2017-12-01	0.698062132	38.3325607	69.24832309	162.758002	1.32	-0.621937868	37.0125607	67.92832309	161.438002
2018-01-01	6.175883529	-27.7987389	47.78133131	-29.61920803	1.41	4.765883529	-29.2087389	46.37133131	-31.02920803
2018-02-01	-3.636051684	1.729762831	-23.52756124	24.2079978	1.57	-5.206051684	0.159762831	-25.09756124	22.6379978
2018-03-01	-3.129038039	-32.9332892	-53.64154862	-42.52840154	1.7	-4.829038039	-34.6332892	-55.34154862	-44.22840154
2018-04-01	0.91940807	32.50893149	68.9777225	27.33112288	1.76	-0.84059193	30.74893149	67.2177225	25.57112288
2018-05-01	2.430907263	-18.89909064	-13.77454599	-20.47657683	1.86	0.570907263	-20.75909064	-15.63454599	-22.33657683
2018-06-01	0.125491739	-14.54690691	-21.20074142	-31.08220009	1.9	-1.774508261	-16.44690691	-23.10074142	-32.98220009
2018-07-01	4.170325895	21.49344068	-4.682321132	-2.054341656	1.96	2.210325895	19.53344068	-6.642321132	-4.014341656
2018-08-01	3.191959435	-9.547787383	-34.77171682	-22.30400098	2.03	1.161959435	-11.57778738	-36.80171682	-24.33400098
2018-09-01	0.141270053	-5.854569531	-17.72271465	-1.265391499	2.13	-1.988729947	-7.984569531	-19.85271465	-3.395391499
2018-10-01	-6.489044861	-4.647911924	-15.23182889	-19.1364632	2.25	-8.739044861	-6.897911924	-17.48182889	-21.3864632
2018-11-01	1.854925955	-36.41157586	-42.66346876	-35.14606009	2.33	-0.475074045	-38.74157586	-44.99346876	-37.47606009
2018-12-01	-9.334303643	-6.834696567	17.84623674	-4.979104476	2.37	-11.70430364	-9.204696567	15.47623674	-7.349104476
2019-01-01	8.637275946	-7.61235687	-19.72526656	3.885858263	2.37	6.267275946	-9.98235687	-22.09526656	1.515858263
2019-02-01	3.24161682	11.481101	27.72739903	46.07923007	2.39	0.85161682	9.091100996	25.33739903	43.68923007
2019-03-01	1.363548766	6.501500628	3.486642697	31.39923207	2.4	-1.036451234	4.101500628	1.086642697	28.99923207
2019-04-01	4.543706097	30.33373027	14.59355085	22.26218319	2.38	2.163706097	27.95373027	12.21355085	19.88218319
2019-05-01	-6.37713195	60.2493017	65.33274839	54.19440799	2.35	-8.72713195	57.8993017	62.98274839	51.84440799
2019-06-01	6.44097041	26.1549106	8.422710264	6.733335861	2.17	4.27097041	23.9849106	6.252710264	4.563335861
2019-07-01	2.005662368	-6.76265917	-24.78253707	-19.4189872	2.1	-0.094337632	-8.86265917	-26.88253707	-21.5189872
2019-08-01	-1.674339541	-4.51101181	-21.12210414	-34.44693067	1.95	-3.624339541	-6.46101181	-23.07210414	-36.39693067
2019-09-01	1.477157244	-13.88062018	4.292009682	-13.19241731	1.89	-0.412842756	-15.77062018	2.402009682	-15.08241731
2019-10-01	2.682483765	10.92031823	2.276455627	4.858949766	1.65	1.032483765	9.270318229	0.626455627	3.208949766
2019-11-01	3.619831491	-17.71770232	-17.08308818	-19.23294191	1.54	2.079831491	-19.25770232	-18.62308818	-20.77294191
2019-12-01	2.402081088	-4.967624148	-15.03138842	-12.92322576	1.54	0.862081088	-6.507624148	-16.57138842	-14.46322576
2020-01-01	0.451058161	29.98401968	39.000836	64.19780875	1.52	-1.068941839	28.46401968	37.480836	62.67780875
2020-02-01	-7.916559344	-8.031850221	22.02947442	-13.75412728	1.52	-9.436559344	-9.551850221	20.50947442	-15.27412728
2020-03-01	-12.99873069	-25.12776382	-39.23380859	-32.87168897	0.29	-13.28873069	-25.41776382	-39.52380859	-33.16168897
2020-04-01	13.36107826	34.47789623	55.39823935	18.86790393	0.14	13.22107826	34.33789623	55.25823935	18.72790393
2020-05-01	4.764495358	9.268347923	11.25887576	-2.402137517	0.13	4.634495358	9.138347923	11.12887576	-2.532137517
2020-06-01	1.327563832	-3.41468586	-2.017833841	-9.045671176	0.16	1.167563832	-3.57468586	-2.177833841	-9.205671176
2020-07-01	6.355179786	23.9163413	52.68747275	39.86309327	0.13	6.225179786	23.7863413	52.55747275	39.73309327
2020-08-01	6.979663166	3.155866683	25.90764824	5.371996598	0.1	6.879663166	3.055866683	25.80764824	5.271996598
2020-09-01	-4.128119432	-7.646741625	-17.25140607	-24.26580898	0.11	-4.238119432	-7.756741625	-17.36140607	-24.37580898
2020-10-01	-2.103042852	27.74826572	7.379531187	20.10676078	0.1	-2.203042852	27.64826572	7.279531187	20.00676078
2020-11-01	10.87768205	42.41232778	59.04239659	57.53592626	0.09	10.78768205	42.32232778	58.95239659	57.44592626
2020-12-01	3.264655947	47.77317407	19.99875923	42.3817852	0.09	3.174655947	47.68317407	19.90875923	42.2917852
2021-01-01	-0.597121956	14.18067126	78.22989096	3.914091232	0.08	-0.677121956	14.10067126	78.14989096	3.834091232
2021-02-01	2.780544202	36.30875059	7.68546039	27.28728204	0.04	2.740544202	36.26875059	7.64546039	27.24728204
2021-03-01	4.198658525	30.53111096	35.47286349	19.74928085	0.03	4.168658525	30.50111096	35.44286349	19.71928085
2021-04-01	5.635896169	-1.983502065	44.56119037	37.30041504	0.02	5.615896169	-2.003502065	44.54119037	37.28041504
2021-05-01	0.656603769	-35.35455959	-2.100878779	-30.65763247	0.02	0.636603769	-35.37455959	-2.120878779	-30.67763247
2021-06-01	1.909342807	-6.139416614	-16.22123672	-23.34573409	0.04	1.869342807	-6.179416614	-16.26123672	-23.38573409
2021-07-01	2.776393237	18.79338549	11.50392954	0.553212881	0.05	2.726393237	18.74338549	11.45392954	0.503212881
2021-08-01	2.975988062	13.31010952	35.38834398	18.4402268	0.05	2.925988062	13.26010952	35.33834398	18.3902268
2021-09-01	-4.965006941	-7.157155077	-12.58262518	-10.78370825	0.04	-5.005006941	-7.197155077	-12.62262518	-10.82370825
2021-10-01	7.359197238	40.02672859	42.85585778	25.24902856	0.05	7.309197238	39.97672859	42.80585778	25.19902856

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

The question is incomplete It seems to be describing a task ... View full answer

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 Programming Questions!

In Problems 65-72, summarize all pertinent information obtained by applying the graphing strategy, and sketch the graph of y=f(x). 66. 68. 70. 72. x2x6 f(x) 2x 1x +14 f(x)-_-x2-4 x3-5x2-6x 3x +2...

Hester's Hatchery raises fish. At the end of the current season she has 1,000 fish in the hatchery. She can harvest any number of fish that she wishes, selling them to restaurants for $5 apiece....

Four cylindrical rods with various cross-sectional areas and initial lengths are stretched by an applied force, as in Figure 17-11. The resulting change in length of each rod is given in the...

Let f1, f2 be the probability functions of the random variables X1, X2, which follow the Poisson distribution with parameters ????1, ????2, respectively, that is for i = 1, f(x)=e^ x! x = 0, 1, 2,...,

On January 6, Aaron Co. sells merchandise on account to Foley Inc. for $9,200, terms 1/10, n/30. On January 16, Foley pays the amount due. Instructions Prepare the entries on Aaron Co.s books to...

in c++ Question 1: Implement the following Mall as described below: Each Mall contains a number of shops; Implement class Mall with the following: 1. Three private data member: (6 points) a. int...

During the first month of operations, the Banco Extrusion Inc, located in Ontario Canada, which specializes in auto component manufacturing completed the following transactions. Date 1 George Leblanc...

6. (15 pts.) Find the x value , where the function has a relative maximum, a relative minimum, and calculate the absolute maximum and minimum of the function f[x)=x3 + x2 x + 1 , where -25 x 51

In the ILSW book, there is an analogous use of the First Law of Thermodynamics, the Law of Energy Conservation, to describe the work environment.How does this concept apply to business and...

Develop a diversity allies program Scenario Achieving a diverse workplace requires more than a business case it requires us both individually and collectively to question our assumptions and the...

(9) A $950,000 perpetuity invested at 7% compounded semi-annually will provide what monthly payments?

Prepare a Life Cycle Assessment of returnable and non-returnable glass bottles used for the production of soda. The bottles have a capacity of 300 mL. A returnable bottle has a mass of 250 g and...

Consider the design of an engineered wetland amended with limestone to treat acidic drainage from a coal mine. For the purposes of this problem, we will focus on the total dissolved solids (TDS) of...

HP and Microsoft have had a 25 years partnership allowing each company to build competitive market advantages. The companies share technology, engineering and marketing resources to create and...

The domain of the variable in the expression x 3/x + 4 is________.

What are some of the things that an organization can do to adopt an inclusive approach to recruiting? LO.1

There is a lot of discussion about the need for diversity in organizations. What are some of the major benefits inclusive organizations experience? LO.1

Your research focuses on social exclusion and inclusion. Can you briefly explain those concepts? LO.1