Calculate the weekly return for BIT and construct a histogram in Excel. Does the data on...

70.2K

Verified Solution

Question

Basic Math

Calculate the weekly return for BIT and construct a histogramin Excel. Does the data on return rates appear normallydistributed? On the basis of z-scores do you find evidence ofoutliers? Hint: the formula for a return is (Current Price â€“Previous price)/Previous price multiplied by 100.
Date BIT
11/3/13 52.06
18/3/13 53.84
25/3/13 99.99
1/4/13 139.23
8/4/13 113.07
15/4/13 123.93
22/4/13 141.36
29/4/13 126.5
6/5/13 120.39
13/5/13 125.5
20/5/13 142.52
27/5/13 137.88
3/6/13 115.66
10/6/13 120.98
17/6/13 125.28
24/6/13 111.97
1/7/13 97.54
8/7/13 114.95
15/7/13 96.5
22/7/13 92
29/7/13 99.95
5/8/13 125.49
12/8/13 104.1
19/8/13 109.53
26/8/13 158.75
2/9/13 136.12
9/9/13 147.87
16/9/13 143.09
23/9/13 142.08
30/9/13 140.24
7/10/13 151.77
14/10/13 193.52
21/10/13 213.89
28/10/13 233.5
4/11/13 331.05
11/11/13 547.08
18/11/13 974.55
25/11/13 1191.99
2/12/13 1016.27
9/12/13 1027.82
16/12/13 781.78
23/12/13 889.11
30/12/13 999
6/1/14 1037.92
13/1/14 977.1
20/1/14 1000
27/1/14 928.99
3/2/14 850
10/2/14 740
17/2/14 728.37
24/2/14 650
3/3/14 674.73
10/3/14 669.53
17/3/14 646.83
24/3/14 560
31/3/14 518.31
7/4/14 475
14/4/14 567.54
21/4/14 469
28/4/14 502.16
5/5/14 456
12/5/14 510.9
19/5/14 648.66
26/5/14 752.71
2/6/14 750
9/6/14 671.71
16/6/14 690
23/6/14 665
30/6/14 661.2
7/7/14 692.14
14/7/14 614.12
21/7/14 600.84
28/7/14 665.93
4/8/14 687.76
11/8/14 584.97
18/8/14 543
25/8/14 510.53
1/9/14 537.92
8/9/14 562.43
15/9/14 424.44
22/9/14 460.15
29/9/14 353.36
6/10/14 481.64
13/10/14 485.55
20/10/14 449.98
27/10/14 419.9
3/11/14 440.98
10/11/14 463.96
17/11/14 448.09
24/11/14 471.5
1/12/14 476
8/12/14 419.55
15/12/14 434.97
22/12/14 443.46
29/12/14 362.8
5/1/15 350.09
12/1/15 290.02
19/1/15 480.51
26/1/15 289.48
2/2/15 309.59
9/2/15 323.9
16/2/15 323.5
23/2/15 354.85
2/3/15 351.34
9/3/15 405.86
16/3/15 349.82
23/3/15 380
30/3/15 320.56
6/4/15 379.94
13/4/15 365
20/4/15 300
27/4/15 324.68
4/5/15 295.91
11/5/15 345.03
18/5/15 327.36
25/5/15 369.69
1/6/15 328.8
8/6/15 320.5
15/6/15 312.87
22/6/15 325.62
29/6/15 362.18
6/7/15 443.58
13/7/15 412.15
20/7/15 401.96
27/7/15 415
3/8/15 362.04
10/8/15 329.08
17/8/15 357.53
24/8/15 320.4
31/8/15 349.46
7/9/15 330.8
14/9/15 323.27
21/9/15 346.48
28/9/15 350.66
5/10/15 339.59
12/10/15 373.53
19/10/15 400.01
26/10/15 477.69
2/11/15 551.39
9/11/15 471.79
16/11/15 476.89
23/11/15 518.39
30/11/15 540.58
7/12/15 605.46
14/12/15 616.24
21/12/15 581.21
28/12/15 582.38
4/1/16 642.2
11/1/16 554.28
18/1/16 573.92
25/1/16 532.58
1/2/16 529.39
8/2/16 567.05
15/2/16 609.61
22/2/16 606.68
29/2/16 548.07
7/3/16 543.69
14/3/16 584.58
21/3/16 589.97
28/3/16 585.82
4/4/16 555.66
11/4/16 574.93
18/4/16 616.19
25/4/16 588.28
2/5/16 655.87
9/5/16 642.67
16/5/16 612.75
23/5/16 701.27
30/5/16 788.69
6/6/16 903.09
13/6/16 1053.05
20/6/16 905.65
27/6/16 897.08
4/7/16 871.54
11/7/16 895.01
18/7/16 893.52
25/7/16 823.18
1/8/16 787.93
8/8/16 750.5
15/8/16 760
22/8/16 770
29/8/16 815.6
5/9/16 814
12/9/16 834.99
19/9/16 786.2
26/9/16 819.42
3/10/16 815.57
10/10/16 854
17/10/16 861.02
24/10/16 925
31/10/16 925.83
7/11/16 931.9
14/11/16 1000.52
21/11/16 1002.97
28/11/16 1024.27
5/12/16 1075.2
12/12/16 1106.2
19/12/16 1235.94
26/12/16 1381.4
2/1/17 1244.41
9/1/17 1095.16
16/1/17 1223.2
23/1/17 1238.34
30/1/17 1347.74
6/2/17 1341.48
13/2/17 1375.95
20/2/17 1553.46
27/2/17 1690.27
6/3/17 1649.1
13/3/17 1362.27
20/3/17 1277.61
27/3/17 1472.88
3/4/17 1612.83
10/4/17 1588.75
17/4/17 1683.46
24/4/17 1781.71
1/5/17 2196.67
8/5/17 2595.07
15/5/17 2860.85
22/5/17 3094.79
29/5/17 3493.27
5/6/17 3889.46
12/6/17 3588.86
19/6/17 3503.31
26/6/17 3342.76
3/7/17 3415.51
10/7/17 2510
17/7/17 3541.5
24/7/17 3529.74
31/7/17 4060.53
7/8/17 5318.14
14/8/17 5298.76
21/8/17 5620
28/8/17 6018.4
4/9/17 5319.46
11/9/17 4593.05
18/9/17 4625.38
25/9/17 5565.36
2/10/17 5887.35
9/10/17 7226.76
16/10/17 7713.93
23/10/17 8018.65
30/10/17 9692.39
6/11/17 7924.89
13/11/17 10693.55
20/11/17 12297.99
27/11/17 15024.19
4/12/17 21184.87
11/12/17 25986.55
18/12/17 18939.79
25/12/17 19050.74
1/1/18 22862.21
8/1/18 19041.51
15/1/18 15148.37
22/1/18 14445.12
29/1/18 10225.82
5/2/18 10382.72
12/2/18 13338.45
19/2/18 12300.72
26/2/18 14763.94
5/3/18 12143.73
12/3/18 10646.88
19/3/18 11039.19
26/3/18 8835.98
2/4/18 9130.39
9/4/18 10654.32
16/4/18 11357.21
23/4/18 12432.76
30/4/18 12682.62
7/5/18 11560.03
14/5/18 11318.46
21/5/18 9752.02
28/5/18 10233.1
4/6/18 8956.31
11/6/18 8717.19
18/6/18 8252.91
25/6/18 8489.05
2/7/18 8953.63
9/7/18 8555.52
16/7/18 9947.28
23/7/18 11114.06
30/7/18 9559.81
6/8/18 8719.77
13/8/18 8920.44
20/8/18 9172.49
27/8/18 10081.22
3/9/18 8802.43
10/9/18 9058.83
17/9/18 9118.22
24/9/18 9139.68
1/10/18 9264.69
8/10/18 8735.74
15/10/18 9005.48
22/10/18 9019.61
29/10/18 8908.97
5/11/18 8841.39
12/11/18 7579.24
19/11/18 5435.57
26/11/18 5586.65
3/12/18 4914.89
10/12/18 4440.44
17/12/18 5596.18
24/12/18 5456.26
31/12/18 5686.6
7/1/19 4908.14
14/1/19 4962.34
21/1/19 4942.09
28/1/19 4734.24
4/2/19 5132.33
11/2/19 5083.2
18/2/19 5213.99
25/2/19 5340.09
4/3/19 5555.14
11/3/19 5626.45
18/3/19 5617.53
25/3/19 5738.09
1/4/19 7253.71
8/4/19 7214.66
15/4/19 7437.26
22/4/19 7405.25
29/4/19 8120.41
6/5/19 9962.31
13/5/19 11884.94
20/5/19 12617.35
27/5/19 12606.94
3/6/19 10983.83
10/6/19 12961.26
17/6/19 15572.87
24/6/19 15180.16
1/7/19 16368.05
8/7/19 14657.08
15/7/19 15057.73
22/7/19 13891.59
29/7/19 16132.89
5/8/19 17037.56
12/8/19 15348.79

Answer & Explanation Solved by verified expert

3.7 Ratings (412 Votes)

Step 1 Put the data in data in excelStep 2 Find the mean and standard deviation for the weeklyreturnStep 3 Find the zscoreStep 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: Zin AI - Your personal assistant for all your inquiries!

Become a Member

Calculate the weekly return for BIT and construct a histogram in Excel. Does the data on...

70.2K

Verified Solution

Question

Basic Math

Answer & Explanation Solved by verified expert

Get Answers to Unlimited Questions

Membership Benefits:

Other questions asked by students

4 x 1x 4x 17 The coordinates of the vertices for rectangle ABCD are A...

The equilibrium constant, K, for the following reaction is 1.29Ã—10-2 at 600 K. COCl2(g) CO(g) +...

A solution was prepared by weighing out 6.20 grams of sodium benzoate, NaC7H5O2 along with 2.25...

Find the area of the region described The region between the line y x and...

The quadratic regression associated with the benefit of exercising f a compared to number of...

6 6 17 X 30 18 yz 17 X 30 18 vyz View an example...

2) A company had income before interest expense and income taxes of $185,900,...

Polar loc Cream usos amb ng cepartment and a freezing department in producing...

7:057 Module 6 Discussion Fo... OOO INFO DISCUSSION Module 6 Discussion Forum Due: Thursday, Aug...

TTT Company purchased a machine some years ago. At the end of the current year,...

The company does not incur any variable manufacturing overhead costs or variable selling and administrative...

A borrower can obtain an 80% loan with an 8% interest rate and monthly payments....

Date	BIT
11/3/13	52.06
18/3/13	53.84
25/3/13	99.99
1/4/13	139.23
8/4/13	113.07
15/4/13	123.93
22/4/13	141.36
29/4/13	126.5
6/5/13	120.39
13/5/13	125.5
20/5/13	142.52
27/5/13	137.88
3/6/13	115.66
10/6/13	120.98
17/6/13	125.28
24/6/13	111.97
1/7/13	97.54
8/7/13	114.95
15/7/13	96.5
22/7/13	92
29/7/13	99.95
5/8/13	125.49
12/8/13	104.1
19/8/13	109.53
26/8/13	158.75
2/9/13	136.12
9/9/13	147.87
16/9/13	143.09
23/9/13	142.08
30/9/13	140.24
7/10/13	151.77
14/10/13	193.52
21/10/13	213.89
28/10/13	233.5
4/11/13	331.05
11/11/13	547.08
18/11/13	974.55
25/11/13	1191.99
2/12/13	1016.27
9/12/13	1027.82
16/12/13	781.78
23/12/13	889.11
30/12/13	999
6/1/14	1037.92
13/1/14	977.1
20/1/14	1000
27/1/14	928.99
3/2/14	850
10/2/14	740
17/2/14	728.37
24/2/14	650
3/3/14	674.73
10/3/14	669.53
17/3/14	646.83
24/3/14	560
31/3/14	518.31
7/4/14	475
14/4/14	567.54
21/4/14	469
28/4/14	502.16
5/5/14	456
12/5/14	510.9
19/5/14	648.66
26/5/14	752.71
2/6/14	750
9/6/14	671.71
16/6/14	690
23/6/14	665
30/6/14	661.2
7/7/14	692.14
14/7/14	614.12
21/7/14	600.84
28/7/14	665.93
4/8/14	687.76
11/8/14	584.97
18/8/14	543
25/8/14	510.53
1/9/14	537.92
8/9/14	562.43
15/9/14	424.44
22/9/14	460.15
29/9/14	353.36
6/10/14	481.64
13/10/14	485.55
20/10/14	449.98
27/10/14	419.9
3/11/14	440.98
10/11/14	463.96
17/11/14	448.09
24/11/14	471.5
1/12/14	476
8/12/14	419.55
15/12/14	434.97
22/12/14	443.46
29/12/14	362.8
5/1/15	350.09
12/1/15	290.02
19/1/15	480.51
26/1/15	289.48
2/2/15	309.59
9/2/15	323.9
16/2/15	323.5
23/2/15	354.85
2/3/15	351.34
9/3/15	405.86
16/3/15	349.82
23/3/15	380
30/3/15	320.56
6/4/15	379.94
13/4/15	365
20/4/15	300
27/4/15	324.68
4/5/15	295.91
11/5/15	345.03
18/5/15	327.36
25/5/15	369.69
1/6/15	328.8
8/6/15	320.5
15/6/15	312.87
22/6/15	325.62
29/6/15	362.18
6/7/15	443.58
13/7/15	412.15
20/7/15	401.96
27/7/15	415
3/8/15	362.04
10/8/15	329.08
17/8/15	357.53
24/8/15	320.4
31/8/15	349.46
7/9/15	330.8
14/9/15	323.27
21/9/15	346.48
28/9/15	350.66
5/10/15	339.59
12/10/15	373.53
19/10/15	400.01
26/10/15	477.69
2/11/15	551.39
9/11/15	471.79
16/11/15	476.89
23/11/15	518.39
30/11/15	540.58
7/12/15	605.46
14/12/15	616.24
21/12/15	581.21
28/12/15	582.38
4/1/16	642.2
11/1/16	554.28
18/1/16	573.92
25/1/16	532.58
1/2/16	529.39
8/2/16	567.05
15/2/16	609.61
22/2/16	606.68
29/2/16	548.07
7/3/16	543.69
14/3/16	584.58
21/3/16	589.97
28/3/16	585.82
4/4/16	555.66
11/4/16	574.93
18/4/16	616.19
25/4/16	588.28
2/5/16	655.87
9/5/16	642.67
16/5/16	612.75
23/5/16	701.27
30/5/16	788.69
6/6/16	903.09
13/6/16	1053.05
20/6/16	905.65
27/6/16	897.08
4/7/16	871.54
11/7/16	895.01
18/7/16	893.52
25/7/16	823.18
1/8/16	787.93
8/8/16	750.5
15/8/16	760
22/8/16	770
29/8/16	815.6
5/9/16	814
12/9/16	834.99
19/9/16	786.2
26/9/16	819.42
3/10/16	815.57
10/10/16	854
17/10/16	861.02
24/10/16	925
31/10/16	925.83
7/11/16	931.9
14/11/16	1000.52
21/11/16	1002.97
28/11/16	1024.27
5/12/16	1075.2
12/12/16	1106.2
19/12/16	1235.94
26/12/16	1381.4
2/1/17	1244.41
9/1/17	1095.16
16/1/17	1223.2
23/1/17	1238.34
30/1/17	1347.74
6/2/17	1341.48
13/2/17	1375.95
20/2/17	1553.46
27/2/17	1690.27
6/3/17	1649.1
13/3/17	1362.27
20/3/17	1277.61
27/3/17	1472.88
3/4/17	1612.83
10/4/17	1588.75
17/4/17	1683.46
24/4/17	1781.71
1/5/17	2196.67
8/5/17	2595.07
15/5/17	2860.85
22/5/17	3094.79
29/5/17	3493.27
5/6/17	3889.46
12/6/17	3588.86
19/6/17	3503.31
26/6/17	3342.76
3/7/17	3415.51
10/7/17	2510
17/7/17	3541.5
24/7/17	3529.74
31/7/17	4060.53
7/8/17	5318.14
14/8/17	5298.76
21/8/17	5620
28/8/17	6018.4
4/9/17	5319.46
11/9/17	4593.05
18/9/17	4625.38
25/9/17	5565.36
2/10/17	5887.35
9/10/17	7226.76
16/10/17	7713.93
23/10/17	8018.65
30/10/17	9692.39
6/11/17	7924.89
13/11/17	10693.55
20/11/17	12297.99
27/11/17	15024.19
4/12/17	21184.87
11/12/17	25986.55
18/12/17	18939.79
25/12/17	19050.74
1/1/18	22862.21
8/1/18	19041.51
15/1/18	15148.37
22/1/18	14445.12
29/1/18	10225.82
5/2/18	10382.72
12/2/18	13338.45
19/2/18	12300.72
26/2/18	14763.94
5/3/18	12143.73
12/3/18	10646.88
19/3/18	11039.19
26/3/18	8835.98
2/4/18	9130.39
9/4/18	10654.32
16/4/18	11357.21
23/4/18	12432.76
30/4/18	12682.62
7/5/18	11560.03
14/5/18	11318.46
21/5/18	9752.02
28/5/18	10233.1
4/6/18	8956.31
11/6/18	8717.19
18/6/18	8252.91
25/6/18	8489.05
2/7/18	8953.63
9/7/18	8555.52
16/7/18	9947.28
23/7/18	11114.06
30/7/18	9559.81
6/8/18	8719.77
13/8/18	8920.44
20/8/18	9172.49
27/8/18	10081.22
3/9/18	8802.43
10/9/18	9058.83
17/9/18	9118.22
24/9/18	9139.68
1/10/18	9264.69
8/10/18	8735.74
15/10/18	9005.48
22/10/18	9019.61
29/10/18	8908.97
5/11/18	8841.39
12/11/18	7579.24
19/11/18	5435.57
26/11/18	5586.65
3/12/18	4914.89
10/12/18	4440.44
17/12/18	5596.18
24/12/18	5456.26
31/12/18	5686.6
7/1/19	4908.14
14/1/19	4962.34
21/1/19	4942.09
28/1/19	4734.24
4/2/19	5132.33
11/2/19	5083.2
18/2/19	5213.99
25/2/19	5340.09
4/3/19	5555.14
11/3/19	5626.45
18/3/19	5617.53
25/3/19	5738.09
1/4/19	7253.71
8/4/19	7214.66
15/4/19	7437.26
22/4/19	7405.25
29/4/19	8120.41
6/5/19	9962.31
13/5/19	11884.94
20/5/19	12617.35
27/5/19	12606.94
3/6/19	10983.83
10/6/19	12961.26
17/6/19	15572.87
24/6/19	15180.16
1/7/19	16368.05
8/7/19	14657.08
15/7/19	15057.73
22/7/19	13891.59
29/7/19	16132.89
5/8/19	17037.56
12/8/19	15348.79