Question

In: Math

An investment advisor claimed that BIT return is 2%. Do you agree? Justify your reasoning using...

An investment advisor claimed that BIT return is 2%. Do you agree? Justify your reasoning using a two-tailed hypothesis test approach at the significance level of 5% in Excel.

Date Weekly Return BIT
11/3/13 3.41913
18/3/13 85.71694
25/3/13 39.24392
1/4/13 -18.7891
8/4/13 9.60467
15/4/13 14.06439
22/4/13 -10.5122
29/4/13 -4.83004
6/5/13 4.244539
13/5/13 13.56176
20/5/13 -3.25568
27/5/13 -16.1155
3/6/13 4.599688
10/6/13 3.554303
17/6/13 -10.6242
24/6/13 -12.8874
1/7/13 17.84908
8/7/13 -16.0505
15/7/13 -4.66321
22/7/13 8.641301
29/7/13 25.55278
5/8/13 -17.0452
12/8/13 5.216139
19/8/13 44.93746
26/8/13 -14.2551
2/9/13 8.63209
9/9/13 -3.23257
16/9/13 -0.70585
23/9/13 -1.29504
30/9/13 8.221619
7/10/13 27.50873
14/10/13 10.52604
21/10/13 9.168265
28/10/13 41.7773
4/11/13 65.25601
11/11/13 78.13665
18/11/13 22.31184
25/11/13 -14.7417
2/12/13 1.136502
9/12/13 -23.938
16/12/13 13.72892
23/12/13 12.35955
30/12/13 3.8959
6/1/14 -5.8598
13/1/14 2.343673
20/1/14 -7.101
27/1/14 -8.50278
3/2/14 -12.9412
10/2/14 -1.57162
17/2/14 -10.7596
24/2/14 3.804612
3/3/14 -0.77067
10/3/14 -3.39044
17/3/14 -13.4239
24/3/14 -7.44464
31/3/14 -8.356
7/4/14 19.4821
14/4/14 -17.3626
21/4/14 7.070363
28/4/14 -9.19229
5/5/14 12.03947
12/5/14 26.96418
19/5/14 16.04077
26/5/14 -0.36004
2/6/14 -10.4387
9/6/14 2.722898
16/6/14 -3.62319
23/6/14 -0.57143
30/6/14 4.679371
7/7/14 -11.2723
14/7/14 -2.16244
21/7/14 10.83316
28/7/14 3.278125
4/8/14 -14.9456
11/8/14 -7.17472
18/8/14 -5.97974
25/8/14 5.36501
1/9/14 4.556442
8/9/14 -24.5346
15/9/14 8.413437
22/9/14 -23.2077
29/9/14 36.30293
6/10/14 0.811804
13/10/14 -7.32571
20/10/14 -6.68475
27/10/14 5.020247
3/11/14 5.211116
10/11/14 -3.42055
17/11/14 5.224398
24/11/14 0.954401
1/12/14 -11.8592
8/12/14 3.67537
15/12/14 1.951856
22/12/14 -18.1888
29/12/14 -3.50331
5/1/15 -17.1584
12/1/15 65.68169
19/1/15 -39.7557
26/1/15 6.946934
2/2/15 4.622242
9/2/15 -0.12349
16/2/15 9.690883
23/2/15 -0.98915
2/3/15 15.51773
9/3/15 -13.8077
16/3/15 8.627292
23/3/15 -15.6421
30/3/15 18.52383
6/4/15 -3.9322
13/4/15 -17.8082
20/4/15 8.226664
27/4/15 -8.86103
4/5/15 16.59964
11/5/15 -5.1213
18/5/15 12.93072
25/5/15 -11.0606
1/6/15 -2.52433
8/6/15 -2.38066
15/6/15 4.075175
22/6/15 11.22781
29/6/15 22.47501
6/7/15 -7.08553
13/7/15 -2.4724
20/7/15 3.244106
27/7/15 -12.7614
3/8/15 -9.10397
10/8/15 8.645318
17/8/15 -10.3851
24/8/15 9.069912
31/8/15 -5.33967
7/9/15 -2.2763
14/9/15 7.179764
21/9/15 1.206417
28/9/15 -3.15691
5/10/15 9.994406
12/10/15 7.089126
19/10/15 19.41951
26/10/15 15.42842
2/11/15 -14.4362
9/11/15 1.080991
16/11/15 8.702216
23/11/15 4.280561
30/11/15 12.00192
7/12/15 1.780459
14/12/15 -5.68447
21/12/15 0.201301
28/12/15 10.27165
4/1/16 -13.6904
11/1/16 3.543327
18/1/16 -7.20309
25/1/16 -0.59897
1/2/16 7.113843
8/2/16 7.505511
15/2/16 -0.48063
22/2/16 -9.66077
29/2/16 -0.79917
7/3/16 7.520833
14/3/16 0.922022
21/3/16 -0.70342
28/3/16 -5.14834
4/4/16 3.467952
11/4/16 7.176527
18/4/16 -4.52944
25/4/16 11.48942
2/5/16 -2.0126
9/5/16 -4.65557
16/5/16 14.44635
23/5/16 12.46595
30/5/16 14.50507
6/6/16 16.60521
13/6/16 -13.9974
20/6/16 -0.94628
27/6/16 -2.84702
4/7/16 2.692938
11/7/16 -0.16648
18/7/16 -7.87224
25/7/16 -4.28217
1/8/16 -4.75042
8/8/16 1.265823
15/8/16 1.315789
22/8/16 5.922075
29/8/16 -0.19617
5/9/16 2.578623
12/9/16 -5.84318
19/9/16 4.225384
26/9/16 -0.46984
3/10/16 4.712041
10/10/16 0.822016
17/10/16 7.430719
24/10/16 0.089732
31/10/16 0.655629
7/11/16 7.36345
14/11/16 0.244868
21/11/16 2.123698
28/11/16 4.972315
5/12/16 2.883185
12/12/16 11.72844
19/12/16 11.76919
26/12/16 -9.91675
2/1/17 -11.9936
9/1/17 11.69143
16/1/17 1.237738
23/1/17 8.83441
30/1/17 -0.46448
6/2/17 2.569548
13/2/17 12.90091
20/2/17 8.806797
27/2/17 -2.43571
6/3/17 -17.3931
13/3/17 -6.21463
20/3/17 15.28401
27/3/17 9.501789
3/4/17 -1.49303
10/4/17 5.961288
17/4/17 5.836195
24/4/17 23.28998
1/5/17 18.13655
8/5/17 10.24173
15/5/17 8.177288
22/5/17 12.87583
29/5/17 11.34152
5/6/17 -7.72858
12/6/17 -2.38377
19/6/17 -4.58281
26/6/17 2.176345
3/7/17 -26.5117
10/7/17 41.09562
17/7/17 -0.33206
24/7/17 15.03765
31/7/17 30.97158
7/8/17 -0.36442
14/8/17 6.062555
21/8/17 7.088966
28/8/17 -11.6134
4/9/17 -13.6557
11/9/17 0.703891
18/9/17 20.32222
25/9/17 5.785614
2/10/17 22.75064
9/10/17 6.741201
16/10/17 3.950253
23/10/17 20.87309
30/10/17 -18.236
6/11/17 34.93625
13/11/17 15.00381
20/11/17 22.16785
27/11/17 41.00506
4/12/17 22.66562
11/12/17 -27.117
18/12/17 0.58581
25/12/17 20.00694
1/1/18 -16.7119
8/1/18 -20.4455
15/1/18 -4.64241
22/1/18 -29.2092
29/1/18 1.534346
5/2/18 28.46779
12/2/18 -7.77999
19/2/18 20.02501
26/2/18 -17.7474
5/3/18 -12.3261
12/3/18 3.684747
19/3/18 -19.9581
26/3/18 3.331936
2/4/18 16.69075
9/4/18 6.597227
16/4/18 9.470194
23/4/18 2.009693
30/4/18 -8.8514
7/5/18 -2.0897
14/5/18 -13.8397
21/5/18 4.933133
28/5/18 -12.4771
4/6/18 -2.66984
11/6/18 -5.32603
18/6/18 2.861289
25/6/18 5.472698
2/7/18 -4.44636
9/7/18 16.2674
16/7/18 11.72963
23/7/18 -13.9845
30/7/18 -8.7872
6/8/18 2.301333
13/8/18 2.825531
20/8/18 9.907119
27/8/18 -12.6849
3/9/18 2.912837
10/9/18 0.6556
17/9/18 0.235353
24/9/18 1.36778
1/10/18 -5.70931
8/10/18 3.087778
15/10/18 0.156903
22/10/18 -1.22667
29/10/18 -0.75856
5/11/18 -14.2755
12/11/18 -28.2834
19/11/18 2.779471
26/11/18 -12.0244
3/12/18 -9.65332
10/12/18 26.02761
17/12/18 -2.50028
24/12/18 4.221579
31/12/18 -13.6894
7/1/19 1.104282
14/1/19 -0.40807
21/1/19 -4.2057
28/1/19 8.408738
4/2/19 -0.95726
11/2/19 2.572986
18/2/19 2.418486
25/2/19 4.027091
4/3/19 1.283677
11/3/19 -0.15854
18/3/19 2.14614
25/3/19 26.41332
1/4/19 -0.53834
8/4/19 3.085379
15/4/19 -0.4304
22/4/19 9.657475
29/4/19 22.68234
6/5/19 19.29905
13/5/19 6.162498
20/5/19 -0.0825
27/5/19 -12.8747
3/6/19 18.0031
10/6/19 20.14936
17/6/19 -2.52176
24/6/19 7.825277
1/7/19 -10.4531
8/7/19 2.733494
15/7/19 -7.74446
22/7/19 16.13422
29/7/19 5.607618
5/8/19 -9.91204

Solutions

Expert Solution



Related Solutions

An investment advisor claimed that BIT return is 2%. Do you agree? Justify your reasoning using...
An investment advisor claimed that BIT return is 2%. Do you agree? Justify your reasoning using a two-tailed hypothesis test approach at the significance level of 5% in Excel. Date Weekly Return BIT 11/3/13 -46.16 18/3/13 -0.01 25/3/13 39.23 1/4/13 13.07 8/4/13 23.93 15/4/13 41.36 22/4/13 26.5 29/4/13 20.39 6/5/13 25.5 13/5/13 42.52 20/5/13 37.88001 27/5/13 15.66 3/6/13 20.98 10/6/13 25.28 17/6/13 11.97 24/6/13 -2.46 1/7/13 14.95 8/7/13 -3.5 15/7/13 -8 22/7/13 -0.05 29/7/13 25.49 5/8/13 4.099998 12/8/13 9.529999 19/8/13...
An investment advisor claimed that the return to Bitcoin is 4% while the returns to other...
An investment advisor claimed that the return to Bitcoin is 4% while the returns to other three shares are no different from zero. Do you agree? Justify your reasoning using a two-tailed hypothesis test approach at the significance level of 5%. Bitcoin Mean 1.566281492 Standard Error 1.019391171 Median 1.425067488 Mode #N/A Standard Deviation 14.7723815 Sample Variance 218.2232553 Kurtosis 11.72022419 Skewness -1.075057651 Range 165.6816869 Minimum -100 Maximum 65.68168686 Sum 328.9191133 Count 210 TLS Mean -0.7385425 Standard Error 0.50800517 Median -0.17398 Mode...
Do you agree with the following statement? Justify your answer. *Although the industry is moving toward...
Do you agree with the following statement? Justify your answer. *Although the industry is moving toward component-based construction, most software continues to be custom-built.
Do you agree with the following statement? Justify your answer. Although the industry is moving toward...
Do you agree with the following statement? Justify your answer. Although the industry is moving toward component-based construction, most software continues to be custom-built. # please short answer in your words
Auditing 2 Indicate whether you agree or disagree with the following statements and explain your reasoning....
Auditing 2 Indicate whether you agree or disagree with the following statements and explain your reasoning. a) Svetlana Petrova was reviewing the risk profile of Gaz Prom Industries in order to determine detection risk. She concluded: “Both my inherent and control risks are low. I guess I should be willing to accept high detection risk.” b) Boris Ivanov had performed an assessment of the accounts payable system at Magnitogirsk Iron and Steel Works Operations in the Urals. His focus was...
Using a diagram, outline the ‘Malthusian Trap’ theory. Explain your reasoning why you agree or disagree...
Using a diagram, outline the ‘Malthusian Trap’ theory. Explain your reasoning why you agree or disagree with Malthus’s theory.
Are you a staunch proponent of whistleblowing? Why or why not. Justify your reasoning with examples
Are you a staunch proponent of whistleblowing? Why or why not. Justify your reasoning with examples
Bogleheads believe in market timing provided an advisor is carefully chosen. a) Do you agree with...
Bogleheads believe in market timing provided an advisor is carefully chosen. a) Do you agree with the above statement? b) What strategy works best for investing? c) If your portfolio's value decreases by more than the market what is one explanation? d) Are you a boglehead? Why or why not?
Bogelheads believe in market timing provided an advisor is carefully chosen. a) Do you agree with...
Bogelheads believe in market timing provided an advisor is carefully chosen. a) Do you agree with the above statement? b) What strategy works best for investing? c) If your portfolio's value decreases by more than the market what is one explanation? d) Are you a bogelhead? Why or why not?
How do you evaluate an operating segment or project using return on investment? How do you...
How do you evaluate an operating segment or project using return on investment? How do you evaluate an operating segment or project using residual income and economic value added?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT