In: Math
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 |