Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The Excel file posted with this assignment contains 53 weekly observations for five major market indices: SP500 = S&P 500 SPSML = S&P Small-cap DOW30

The Excel file posted with this assignment contains 53 weekly observations for five major market indices:

SP500 = S&P 500

SPSML = S&P Small-cap

DOW30 = Dow-Jones Industrial average

NDQFIN = NASDAQ financial sector

DJUTL = Dow-Jones utility sector

For each index, you should compute the weekly log-return as 100*(ln(Y_t) - ln(Y_{t-1})) where Y_t is the index value for week t and Y_{t-1} is the index value for the preceding week (t-1). Due to the differencing operation, you should recover 52 log-returns for weeks 2 to 53.

For this initial portion of the term project, you should use the log-return data for the five indices to describe the observed performance of these assets over the past year.You can use any of the tools including the sample mean return, sample standard deviation, skewness, excess kurtosis, CV, Sharpe ratio, and other measures. Please assemble your analysis in a paper

Week SP500 SPSML DOW30 NDQFIN DJUTL
1 3509.44 925.22 28323.4 4594.46 881.76
2 3585.15 994.29 29479.81 4857.14 910.91
3 3557.54 1020.23 29263.48 4858.09 873.29
4 3638.35 1059.67 29910.37 4930.9 873.18
5 3699.12 1085.44 30218.26 5036.53 856.13
6 3663.46 1086.59 30046.37 4977.51 855.1
7 3709.41 1108.16 30179.05 5087.58 857.26
8 3703.06 1121.51 30199.87 5115.5 845.97
9 3756.07 1118.93 30606.48 5157.92 864.64
10 3824.68 1190.26 31097.97 5380.78 851.28
11 3768.25 1211.91 30814.26 5413.22 861.09
12 3841.47 1231.7 30996.98 5401.15 857.94
13 3714.24 1188.71 29982.62 5232.88 852.4
14 3886.83 1252.75 31148.24 5553.4 872.25
15 3934.83 1297.9 31458.4 5635.21 857.1
16 3906.71 1288.77 31494.32 5708.76 846.51
17 3811.15 1278.56 30932.37 5624.95 795.61
18 3841.94 1302.12 31496.3 5746.42 814.03
19 3943.34 1397.66 32778.64 5991.98 844.88
20 3913.1 1355.09 32627.97 5889.21 847.56
21 3974.54 1331.26 33072.88 5893.12 873.55
22 4019.87 1340.3 33153.21 5877.5 879.51
23 4128.8 1334.56 33800.6 5934.78 891.67
24 4185.47 1347.95 34200.67 6011.02 923.71
25 4180.17 1350.06 34043.49 6058.67 918.26
26 4181.17 1345.54 33874.85 6062.13 919.25
27 4232.6 1374.26 34777.76 6173.72 909.9
28 4173.85 1354.82 34382.13 6193.05 907.73
29 4155.86 1343.46 34207.84 6170.1 908.53
30 4204.11 1371.94 34529.45 6218.58 897.35
31 4229.89 1383.8 34756.39 6253.83 900.82
32 4247.44 1396.25 34479.6 6224.5 912.85
33 4166.45 1330.67 33290.08 5990.32 884.86
34 4280.7 1388.76 34433.84 6293.98 889.07
35 4352.34 1369.68 34786.35 6190.25 885.78
36 4369.55 1359.58 34870.16 6117.64 894.2
37 4327.16 1297.56 34687.85 5980.12 914.61
38 4411.79 1318.56 35061.55 6006.97 904.54
39 4395.26 1341.28 34935.47 6020.85 907.42
40 4436.52 1356.27 35208.51 6217.08 926.74
41 4468 1349.91 35515.38 6285.05 938.29
42 4441.67 1320.96 35120.08 6150.6 950.75
43 4509.37 1375.04 35455.8 6367.25 932.25
44 4535.43 1369.73 35369.09 6319.39 944.93
45 4458.58 1326.93 34607.72 6195.59 929.14
46 4432.99 1331.35 34584.88 6190.99 903.8
47 4455.48 1344.76 34798 6334.1 892.8
48 4357.04 1357.37 34326.46 6376.19 872.82
49 4391.34 1358.65 34746.25 6505.33 884.7
50 4471.37 1363.91 35294.76 6615.46 898.54
51 4544.9 1381.14 35677.02 6781.79 921.43
52 4605.38 1376.46 35819.56 6675.93 915.91
53 4625.96 1407.34 35966.42 6776.37 918.33

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Chaos, Noise And Fractals

Authors: E Roy Pike, L A Lugiato

1st Edition

1000112101, 9781000112108

More Books

Students also viewed these Mathematics questions

Question

=+5. How would you rewrite the copy to make it more effective?

Answered: 1 week ago