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

70.2K

Verified Solution

Question

Basic Math

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

DateWeekly Return BIT
11/3/133.41913
18/3/1385.71694
25/3/1339.24392
1/4/13-18.7891
8/4/139.60467
15/4/1314.06439
22/4/13-10.5122
29/4/13-4.83004
6/5/134.244539
13/5/1313.56176
20/5/13-3.25568
27/5/13-16.1155
3/6/134.599688
10/6/133.554303
17/6/13-10.6242
24/6/13-12.8874
1/7/1317.84908
8/7/13-16.0505
15/7/13-4.66321
22/7/138.641301
29/7/1325.55278
5/8/13-17.0452
12/8/135.216139
19/8/1344.93746
26/8/13-14.2551
2/9/138.63209
9/9/13-3.23257
16/9/13-0.70585
23/9/13-1.29504
30/9/138.221619
7/10/1327.50873
14/10/1310.52604
21/10/139.168265
28/10/1341.7773
4/11/1365.25601
11/11/1378.13665
18/11/1322.31184
25/11/13-14.7417
2/12/131.136502
9/12/13-23.938
16/12/1313.72892
23/12/1312.35955
30/12/133.8959
6/1/14-5.8598
13/1/142.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/143.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/1419.4821
14/4/14-17.3626
21/4/147.070363
28/4/14-9.19229
5/5/1412.03947
12/5/1426.96418
19/5/1416.04077
26/5/14-0.36004
2/6/14-10.4387
9/6/142.722898
16/6/14-3.62319
23/6/14-0.57143
30/6/144.679371
7/7/14-11.2723
14/7/14-2.16244
21/7/1410.83316
28/7/143.278125
4/8/14-14.9456
11/8/14-7.17472
18/8/14-5.97974
25/8/145.36501
1/9/144.556442
8/9/14-24.5346
15/9/148.413437
22/9/14-23.2077
29/9/1436.30293
6/10/140.811804
13/10/14-7.32571
20/10/14-6.68475
27/10/145.020247
3/11/145.211116
10/11/14-3.42055
17/11/145.224398
24/11/140.954401
1/12/14-11.8592
8/12/143.67537
15/12/141.951856
22/12/14-18.1888
29/12/14-3.50331
5/1/15-17.1584
12/1/1565.68169
19/1/15-39.7557
26/1/156.946934
2/2/154.622242
9/2/15-0.12349
16/2/159.690883
23/2/15-0.98915
2/3/1515.51773
9/3/15-13.8077
16/3/158.627292
23/3/15-15.6421
30/3/1518.52383
6/4/15-3.9322
13/4/15-17.8082
20/4/158.226664
27/4/15-8.86103
4/5/1516.59964
11/5/15-5.1213
18/5/1512.93072
25/5/15-11.0606
1/6/15-2.52433
8/6/15-2.38066
15/6/154.075175
22/6/1511.22781
29/6/1522.47501
6/7/15-7.08553
13/7/15-2.4724
20/7/153.244106
27/7/15-12.7614
3/8/15-9.10397
10/8/158.645318
17/8/15-10.3851
24/8/159.069912
31/8/15-5.33967
7/9/15-2.2763
14/9/157.179764
21/9/151.206417
28/9/15-3.15691
5/10/159.994406
12/10/157.089126
19/10/1519.41951
26/10/1515.42842
2/11/15-14.4362
9/11/151.080991
16/11/158.702216
23/11/154.280561
30/11/1512.00192
7/12/151.780459
14/12/15-5.68447
21/12/150.201301
28/12/1510.27165
4/1/16-13.6904
11/1/163.543327
18/1/16-7.20309
25/1/16-0.59897
1/2/167.113843
8/2/167.505511
15/2/16-0.48063
22/2/16-9.66077
29/2/16-0.79917
7/3/167.520833
14/3/160.922022
21/3/16-0.70342
28/3/16-5.14834
4/4/163.467952
11/4/167.176527
18/4/16-4.52944
25/4/1611.48942
2/5/16-2.0126
9/5/16-4.65557
16/5/1614.44635
23/5/1612.46595
30/5/1614.50507
6/6/1616.60521
13/6/16-13.9974
20/6/16-0.94628
27/6/16-2.84702
4/7/162.692938
11/7/16-0.16648
18/7/16-7.87224
25/7/16-4.28217
1/8/16-4.75042
8/8/161.265823
15/8/161.315789
22/8/165.922075
29/8/16-0.19617
5/9/162.578623
12/9/16-5.84318
19/9/164.225384
26/9/16-0.46984
3/10/164.712041
10/10/160.822016
17/10/167.430719
24/10/160.089732
31/10/160.655629
7/11/167.36345
14/11/160.244868
21/11/162.123698
28/11/164.972315
5/12/162.883185
12/12/1611.72844
19/12/1611.76919
26/12/16-9.91675
2/1/17-11.9936
9/1/1711.69143
16/1/171.237738
23/1/178.83441
30/1/17-0.46448
6/2/172.569548
13/2/1712.90091
20/2/178.806797
27/2/17-2.43571
6/3/17-17.3931
13/3/17-6.21463
20/3/1715.28401
27/3/179.501789
3/4/17-1.49303
10/4/175.961288
17/4/175.836195
24/4/1723.28998
1/5/1718.13655
8/5/1710.24173
15/5/178.177288
22/5/1712.87583
29/5/1711.34152
5/6/17-7.72858
12/6/17-2.38377
19/6/17-4.58281
26/6/172.176345
3/7/17-26.5117
10/7/1741.09562
17/7/17-0.33206
24/7/1715.03765
31/7/1730.97158
7/8/17-0.36442
14/8/176.062555
21/8/177.088966
28/8/17-11.6134
4/9/17-13.6557
11/9/170.703891
18/9/1720.32222
25/9/175.785614
2/10/1722.75064
9/10/176.741201
16/10/173.950253
23/10/1720.87309
30/10/17-18.236
6/11/1734.93625
13/11/1715.00381
20/11/1722.16785
27/11/1741.00506
4/12/1722.66562
11/12/17-27.117
18/12/170.58581
25/12/1720.00694
1/1/18-16.7119
8/1/18-20.4455
15/1/18-4.64241
22/1/18-29.2092
29/1/181.534346
5/2/1828.46779
12/2/18-7.77999
19/2/1820.02501
26/2/18-17.7474
5/3/18-12.3261
12/3/183.684747
19/3/18-19.9581
26/3/183.331936
2/4/1816.69075
9/4/186.597227
16/4/189.470194
23/4/182.009693
30/4/18-8.8514
7/5/18-2.0897
14/5/18-13.8397
21/5/184.933133
28/5/18-12.4771
4/6/18-2.66984
11/6/18-5.32603
18/6/182.861289
25/6/185.472698
2/7/18-4.44636
9/7/1816.2674
16/7/1811.72963
23/7/18-13.9845
30/7/18-8.7872
6/8/182.301333
13/8/182.825531
20/8/189.907119
27/8/18-12.6849
3/9/182.912837
10/9/180.6556
17/9/180.235353
24/9/181.36778
1/10/18-5.70931
8/10/183.087778
15/10/180.156903
22/10/18-1.22667
29/10/18-0.75856
5/11/18-14.2755
12/11/18-28.2834
19/11/182.779471
26/11/18-12.0244
3/12/18-9.65332
10/12/1826.02761
17/12/18-2.50028
24/12/184.221579
31/12/18-13.6894
7/1/191.104282
14/1/19-0.40807
21/1/19-4.2057
28/1/198.408738
4/2/19-0.95726
11/2/192.572986
18/2/192.418486
25/2/194.027091
4/3/191.283677
11/3/19-0.15854
18/3/192.14614
25/3/1926.41332
1/4/19-0.53834
8/4/193.085379
15/4/19-0.4304
22/4/199.657475
29/4/1922.68234
6/5/1919.29905
13/5/196.162498
20/5/19-0.0825
27/5/19-12.8747
3/6/1918.0031
10/6/1920.14936
17/6/19-2.52176
24/6/197.825277
1/7/19-10.4531
8/7/192.733494
15/7/19-7.74446
22/7/1916.13422
29/7/195.607618
5/8/19-9.91204

Answer & Explanation Solved by verified expert
4.2 Ratings (476 Votes)
    See Answer
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students