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 |