Calculate and interpret the three aspects of Descriptive Analysis for weekly return: Location, Shape and Spread....

90.2K

Verified Solution

Question

Basic Math

Calculate and interpret the three aspects of DescriptiveAnalysis for weekly return: Location, Shape and Spread. Hint: makesure you interpret these measures in the context of the data andpay attention to the unit of measurement 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 58.75
26/8/13 36.12
2/9/13 47.87
9/9/13 43.09
16/9/13 42.08
23/9/13 40.24001
30/9/13 51.77
7/10/13 93.52
14/10/13 113.89
21/10/13 133.5
28/10/13 231.05
4/11/13 447.08
11/11/13 874.55
18/11/13 1091.99
25/11/13 916.27
2/12/13 927.8199
9/12/13 681.78
16/12/13 789.11
23/12/13 899
30/12/13 937.92
6/1/14 877.1
13/1/14 900
20/1/14 828.99
27/1/14 750
3/2/14 640
10/2/14 628.37
17/2/14 550
24/2/14 574.73
3/3/14 569.53
10/3/14 546.83
17/3/14 460
24/3/14 418.31
31/3/14 375
7/4/14 467.54
14/4/14 369
21/4/14 402.16
28/4/14 356
5/5/14 410.9
12/5/14 548.66
19/5/14 652.71
26/5/14 650
2/6/14 571.71
9/6/14 590
16/6/14 565
23/6/14 561.2
30/6/14 592.14
7/7/14 514.12
14/7/14 500.84
21/7/14 565.93
28/7/14 587.76
4/8/14 484.97
11/8/14 443
18/8/14 410.53
25/8/14 437.92
1/9/14 462.43
8/9/14 324.44
15/9/14 360.15
22/9/14 253.36
29/9/14 381.64
6/10/14 385.55
13/10/14 349.98
20/10/14 319.9
27/10/14 340.98
3/11/14 363.96
10/11/14 348.09
17/11/14 371.5
24/11/14 376
1/12/14 319.55
8/12/14 334.97
15/12/14 343.46
22/12/14 262.8
29/12/14 250.09
5/1/15 190.02
12/1/15 380.51
19/1/15 189.48
26/1/15 209.59
2/2/15 223.9
9/2/15 223.5
16/2/15 254.85
23/2/15 251.34
2/3/15 305.86
9/3/15 249.82
16/3/15 280
23/3/15 220.56
30/3/15 279.94
6/4/15 265
13/4/15 200
20/4/15 224.68
27/4/15 195.91
4/5/15 245.03
11/5/15 227.36
18/5/15 269.69
25/5/15 228.8
1/6/15 220.5
8/6/15 212.87
15/6/15 225.62
22/6/15 262.18
29/6/15 343.58
6/7/15 312.15
13/7/15 301.96
20/7/15 315
27/7/15 262.04
3/8/15 229.08
10/8/15 257.53
17/8/15 220.4
24/8/15 249.46
31/8/15 230.8
7/9/15 223.27
14/9/15 246.48
21/9/15 250.66
28/9/15 239.59
5/10/15 273.53
12/10/15 300.01
19/10/15 377.69
26/10/15 451.39
2/11/15 371.79
9/11/15 376.89
16/11/15 418.39
23/11/15 440.58
30/11/15 505.46
7/12/15 516.24
14/12/15 481.21
21/12/15 482.38
28/12/15 542.2
4/1/16 454.28
11/1/16 473.92
18/1/16 432.58
25/1/16 429.39
1/2/16 467.05
8/2/16 509.61
15/2/16 506.68
22/2/16 448.07
29/2/16 443.69
7/3/16 484.58
14/3/16 489.97
21/3/16 485.82
28/3/16 455.66
4/4/16 474.93
11/4/16 516.19
18/4/16 488.28
25/4/16 555.87
2/5/16 542.67
9/5/16 512.75
16/5/16 601.27
23/5/16 688.69
30/5/16 803.09
6/6/16 953.05
13/6/16 805.65
20/6/16 797.08
27/6/16 771.54
4/7/16 795.01
11/7/16 793.52
18/7/16 723.18
25/7/16 687.93
1/8/16 650.5
8/8/16 660
15/8/16 670
22/8/16 715.6
29/8/16 714
5/9/16 734.99
12/9/16 686.2
19/9/16 719.42
26/9/16 715.57
3/10/16 754
10/10/16 761.02
17/10/16 825
24/10/16 825.83
31/10/16 831.9
7/11/16 900.52
14/11/16 902.97
21/11/16 924.27
28/11/16 975.2
5/12/16 1006.2
12/12/16 1135.94
19/12/16 1281.4
26/12/16 1144.41
2/1/17 995.16
9/1/17 1123.2
16/1/17 1138.34
23/1/17 1247.74
30/1/17 1241.48
6/2/17 1275.95
13/2/17 1453.46
20/2/17 1590.27
27/2/17 1549.1
6/3/17 1262.27
13/3/17 1177.61
20/3/17 1372.88
27/3/17 1512.83
3/4/17 1488.75
10/4/17 1583.46
17/4/17 1681.71
24/4/17 2096.67
1/5/17 2495.07
8/5/17 2760.85
15/5/17 2994.79
22/5/17 3393.27
29/5/17 3789.46
5/6/17 3488.86
12/6/17 3403.31
19/6/17 3242.76
26/6/17 3315.51
3/7/17 2410
10/7/17 3441.5
17/7/17 3429.74
24/7/17 3960.53
31/7/17 5218.14
7/8/17 5198.76
14/8/17 5520
21/8/17 5918.4
28/8/17 5219.46
4/9/17 4493.05
11/9/17 4525.38
18/9/17 5465.36
25/9/17 5787.35
2/10/17 7126.76
9/10/17 7613.93
16/10/17 7918.65
23/10/17 9592.39
30/10/17 7824.89
6/11/17 10593.55
13/11/17 12197.99
20/11/17 14924.19
27/11/17 21084.87
4/12/17 25886.55
11/12/17 18839.79
18/12/17 18950.74
25/12/17 22762.21
1/1/18 18941.51
8/1/18 15048.37
15/1/18 14345.12
22/1/18 10125.82
29/1/18 10282.72
5/2/18 13238.45
12/2/18 12200.72
19/2/18 14663.94
26/2/18 12043.73
5/3/18 10546.88
12/3/18 10939.19
19/3/18 8735.98
26/3/18 9030.39
2/4/18 10554.32
9/4/18 11257.21
16/4/18 12332.76
23/4/18 12582.62
30/4/18 11460.03
7/5/18 11218.46
14/5/18 9652.02
21/5/18 10133.1
28/5/18 8856.31
4/6/18 8617.19
11/6/18 8152.91
18/6/18 8389.05
25/6/18 8853.63
2/7/18 8455.52
9/7/18 9847.28
16/7/18 11014.06
23/7/18 9459.81
30/7/18 8619.77
6/8/18 8820.44
13/8/18 9072.49
20/8/18 9981.22
27/8/18 8702.43
3/9/18 8958.83
10/9/18 9018.22
17/9/18 9039.68
24/9/18 9164.69
1/10/18 8635.74
8/10/18 8905.48
15/10/18 8919.61
22/10/18 8808.97
29/10/18 8741.39
5/11/18 7479.24
12/11/18 5335.57
19/11/18 5486.65
26/11/18 4814.89
3/12/18 4340.44
10/12/18 5496.18
17/12/18 5356.26
24/12/18 5586.6
31/12/18 4808.14
7/1/19 4862.34
14/1/19 4842.09
21/1/19 4634.24
28/1/19 5032.33
4/2/19 4983.2
11/2/19 5113.99
18/2/19 5240.09
25/2/19 5455.14
4/3/19 5526.45
11/3/19 5517.53
18/3/19 5638.09
25/3/19 7153.71
1/4/19 7114.66
8/4/19 7337.26
15/4/19 7305.25
22/4/19 8020.41
29/4/19 9862.31
6/5/19 11784.94
13/5/19 12517.35
20/5/19 12506.94
27/5/19 10883.83
3/6/19 12861.26
10/6/19 15472.87
17/6/19 15080.16
24/6/19 16268.05
1/7/19 14557.08
8/7/19 14957.73
15/7/19 13791.59
22/7/19 16032.89
29/7/19 16937.56
5/8/19 15248.79
12/8/19

Answer & Explanation Solved by verified expert

4.5 Ratings (795 Votes)

I am assuming the unit of return is The following output is obtained using the Descriptive Statistics tools in Excel Steps Input the data in Excel click the data whose summary has to be obtained In our case Weekly Return Click on Data on the toolbar and then select Data Analysis on the top right corner Select Descriptive Statistics from the options Fill the required information and the output will be obtained Weekly Return Mean 3556180 Standard Error 269817 Median 734990 Mode NA Standard Deviation 4938460 Sample Variance 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

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	58.75
26/8/13	36.12
2/9/13	47.87
9/9/13	43.09
16/9/13	42.08
23/9/13	40.24001
30/9/13	51.77
7/10/13	93.52
14/10/13	113.89
21/10/13	133.5
28/10/13	231.05
4/11/13	447.08
11/11/13	874.55
18/11/13	1091.99
25/11/13	916.27
2/12/13	927.8199
9/12/13	681.78
16/12/13	789.11
23/12/13	899
30/12/13	937.92
6/1/14	877.1
13/1/14	900
20/1/14	828.99
27/1/14	750
3/2/14	640
10/2/14	628.37
17/2/14	550
24/2/14	574.73
3/3/14	569.53
10/3/14	546.83
17/3/14	460
24/3/14	418.31
31/3/14	375
7/4/14	467.54
14/4/14	369
21/4/14	402.16
28/4/14	356
5/5/14	410.9
12/5/14	548.66
19/5/14	652.71
26/5/14	650
2/6/14	571.71
9/6/14	590
16/6/14	565
23/6/14	561.2
30/6/14	592.14
7/7/14	514.12
14/7/14	500.84
21/7/14	565.93
28/7/14	587.76
4/8/14	484.97
11/8/14	443
18/8/14	410.53
25/8/14	437.92
1/9/14	462.43
8/9/14	324.44
15/9/14	360.15
22/9/14	253.36
29/9/14	381.64
6/10/14	385.55
13/10/14	349.98
20/10/14	319.9
27/10/14	340.98
3/11/14	363.96
10/11/14	348.09
17/11/14	371.5
24/11/14	376
1/12/14	319.55
8/12/14	334.97
15/12/14	343.46
22/12/14	262.8
29/12/14	250.09
5/1/15	190.02
12/1/15	380.51
19/1/15	189.48
26/1/15	209.59
2/2/15	223.9
9/2/15	223.5
16/2/15	254.85
23/2/15	251.34
2/3/15	305.86
9/3/15	249.82
16/3/15	280
23/3/15	220.56
30/3/15	279.94
6/4/15	265
13/4/15	200
20/4/15	224.68
27/4/15	195.91
4/5/15	245.03
11/5/15	227.36
18/5/15	269.69
25/5/15	228.8
1/6/15	220.5
8/6/15	212.87
15/6/15	225.62
22/6/15	262.18
29/6/15	343.58
6/7/15	312.15
13/7/15	301.96
20/7/15	315
27/7/15	262.04
3/8/15	229.08
10/8/15	257.53
17/8/15	220.4
24/8/15	249.46
31/8/15	230.8
7/9/15	223.27
14/9/15	246.48
21/9/15	250.66
28/9/15	239.59
5/10/15	273.53
12/10/15	300.01
19/10/15	377.69
26/10/15	451.39
2/11/15	371.79
9/11/15	376.89
16/11/15	418.39
23/11/15	440.58
30/11/15	505.46
7/12/15	516.24
14/12/15	481.21
21/12/15	482.38
28/12/15	542.2
4/1/16	454.28
11/1/16	473.92
18/1/16	432.58
25/1/16	429.39
1/2/16	467.05
8/2/16	509.61
15/2/16	506.68
22/2/16	448.07
29/2/16	443.69
7/3/16	484.58
14/3/16	489.97
21/3/16	485.82
28/3/16	455.66
4/4/16	474.93
11/4/16	516.19
18/4/16	488.28
25/4/16	555.87
2/5/16	542.67
9/5/16	512.75
16/5/16	601.27
23/5/16	688.69
30/5/16	803.09
6/6/16	953.05
13/6/16	805.65
20/6/16	797.08
27/6/16	771.54
4/7/16	795.01
11/7/16	793.52
18/7/16	723.18
25/7/16	687.93
1/8/16	650.5
8/8/16	660
15/8/16	670
22/8/16	715.6
29/8/16	714
5/9/16	734.99
12/9/16	686.2
19/9/16	719.42
26/9/16	715.57
3/10/16	754
10/10/16	761.02
17/10/16	825
24/10/16	825.83
31/10/16	831.9
7/11/16	900.52
14/11/16	902.97
21/11/16	924.27
28/11/16	975.2
5/12/16	1006.2
12/12/16	1135.94
19/12/16	1281.4
26/12/16	1144.41
2/1/17	995.16
9/1/17	1123.2
16/1/17	1138.34
23/1/17	1247.74
30/1/17	1241.48
6/2/17	1275.95
13/2/17	1453.46
20/2/17	1590.27
27/2/17	1549.1
6/3/17	1262.27
13/3/17	1177.61
20/3/17	1372.88
27/3/17	1512.83
3/4/17	1488.75
10/4/17	1583.46
17/4/17	1681.71
24/4/17	2096.67
1/5/17	2495.07
8/5/17	2760.85
15/5/17	2994.79
22/5/17	3393.27
29/5/17	3789.46
5/6/17	3488.86
12/6/17	3403.31
19/6/17	3242.76
26/6/17	3315.51
3/7/17	2410
10/7/17	3441.5
17/7/17	3429.74
24/7/17	3960.53
31/7/17	5218.14
7/8/17	5198.76
14/8/17	5520
21/8/17	5918.4
28/8/17	5219.46
4/9/17	4493.05
11/9/17	4525.38
18/9/17	5465.36
25/9/17	5787.35
2/10/17	7126.76
9/10/17	7613.93
16/10/17	7918.65
23/10/17	9592.39
30/10/17	7824.89
6/11/17	10593.55
13/11/17	12197.99
20/11/17	14924.19
27/11/17	21084.87
4/12/17	25886.55
11/12/17	18839.79
18/12/17	18950.74
25/12/17	22762.21
1/1/18	18941.51
8/1/18	15048.37
15/1/18	14345.12
22/1/18	10125.82
29/1/18	10282.72
5/2/18	13238.45
12/2/18	12200.72
19/2/18	14663.94
26/2/18	12043.73
5/3/18	10546.88
12/3/18	10939.19
19/3/18	8735.98
26/3/18	9030.39
2/4/18	10554.32
9/4/18	11257.21
16/4/18	12332.76
23/4/18	12582.62
30/4/18	11460.03
7/5/18	11218.46
14/5/18	9652.02
21/5/18	10133.1
28/5/18	8856.31
4/6/18	8617.19
11/6/18	8152.91
18/6/18	8389.05
25/6/18	8853.63
2/7/18	8455.52
9/7/18	9847.28
16/7/18	11014.06
23/7/18	9459.81
30/7/18	8619.77
6/8/18	8820.44
13/8/18	9072.49
20/8/18	9981.22
27/8/18	8702.43
3/9/18	8958.83
10/9/18	9018.22
17/9/18	9039.68
24/9/18	9164.69
1/10/18	8635.74
8/10/18	8905.48
15/10/18	8919.61
22/10/18	8808.97
29/10/18	8741.39
5/11/18	7479.24
12/11/18	5335.57
19/11/18	5486.65
26/11/18	4814.89
3/12/18	4340.44
10/12/18	5496.18
17/12/18	5356.26
24/12/18	5586.6
31/12/18	4808.14
7/1/19	4862.34
14/1/19	4842.09
21/1/19	4634.24
28/1/19	5032.33
4/2/19	4983.2
11/2/19	5113.99
18/2/19	5240.09
25/2/19	5455.14
4/3/19	5526.45
11/3/19	5517.53
18/3/19	5638.09
25/3/19	7153.71
1/4/19	7114.66
8/4/19	7337.26
15/4/19	7305.25
22/4/19	8020.41
29/4/19	9862.31
6/5/19	11784.94
13/5/19	12517.35
20/5/19	12506.94
27/5/19	10883.83
3/6/19	12861.26
10/6/19	15472.87
17/6/19	15080.16
24/6/19	16268.05
1/7/19	14557.08
8/7/19	14957.73
15/7/19	13791.59
22/7/19	16032.89
29/7/19	16937.56
5/8/19	15248.79
12/8/19