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

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

90.2K

Verified Solution

Question

Basic Math

Answer & Explanation Solved by verified expert

Get Answers to Unlimited Questions

Membership Benefits:

Other questions asked by students

Exercise 4-7 Contrast ABC and Conventional Product Costs[LO4-2, LO4-3, LO4-4]Kunkel Company makes two products...Exercise...

Think of a definable action you perform in your daily life that requires more than one...

write a professional memorandum per topic. ( sales and operation planning, inventory control system to determine demand,...

For the following, Use the five-step approach to hypothesis testing found on page 8-16. It states....

Two spherical conductors A and B of radii R and 2R respectively are each given...

Write the standard form of the equation of the hyperbola subject to the given conditions...

Convert the following system of linear equations into matrix form Ax b where x x...

ar Inequalities K The following graph shows the total wid in millions in the United...

E =

Noteworthy, Inc., produces and sells small electronic keyboards. Assume that you have the following information...

Windhoek Mines, Limited, of Namibia, is contemplating the purchase of equipment to exploit a mineral...

Waterway Shutters has the following inventory information. Nov. 1 Inventory 60 units @ $7.008 Purchase...

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