The questions in the document

profileharsh.vijan
f312_E2_data_f202.xlsx
Home>Business & Finance homework help>The questions in the document

Question 5

SHAK Mkt-RF SMB HML RF
2017-01-13 00:00:00 -0.0317 0.0009 0.0045 -0.0106 0.0001
2017-01-20 00:00:00 -0.0189 -0.0031 -0.0114 -0.0018 0.0001
2017-01-27 00:00:00 0.0083 0.0116 0.0021 0.0056 0.0001
2017-02-03 00:00:00 0.0100 0.0015 0.0040 -0.0064 0.0001
2017-02-10 00:00:00 0.0331 0.0088 0.0013 -0.0123 0.0001
2017-02-17 00:00:00 0.0175 0.0152 -0.0055 -0.0039 0.0001
2017-02-24 00:00:00 -0.0347 0.0048 -0.0108 -0.0045 0.0001
2017-03-03 00:00:00 -0.0821 0.0065 -0.0093 -0.0009 0.0001
2017-03-10 00:00:00 -0.0470 -0.0055 -0.0113 -0.0163 0.0001
2017-03-17 00:00:00 0.0328 0.0048 0.0185 -0.0027 0.0001
2017-03-24 00:00:00 -0.0034 -0.0165 -0.0089 -0.0183 0.0001
2017-03-31 00:00:00 0.0328 0.0105 0.0165 0.0083 0.0001
2017-04-07 00:00:00 -0.0254 -0.0044 -0.0134 0.0015 0.0001
2017-04-21 00:00:00 0.0173 0.0111 0.0182 -0.0018 0.0001
2017-04-28 00:00:00 0.0134 0.0164 0.0031 -0.0097 0.0001
2017-05-05 00:00:00 0.0657 0.0053 -0.0077 -0.0047 0.0002
2017-05-12 00:00:00 -0.0019 -0.0032 -0.0025 -0.0125 0.0002
2017-05-19 00:00:00 0.0471 -0.0040 -0.0079 -0.0046 0.0002
2017-05-26 00:00:00 -0.0063 0.0146 -0.0029 -0.0086 0.0002
2017-06-02 00:00:00 0.0056 0.0109 0.0105 -0.0166 0.0002
2017-06-09 00:00:00 0.0392 -0.0024 0.0060 0.0335 0.0002
2017-06-16 00:00:00 -0.0344 -0.0008 -0.0106 -0.0071 0.0002
2017-06-23 00:00:00 -0.0237 0.0031 0.0108 -0.0385 0.0002
2017-06-30 00:00:00 -0.0573 -0.0049 0.0004 0.0343 0.0002
2017-07-07 00:00:00 -0.0006 0.0008 -0.0045 0.0034 0.0002
2017-07-14 00:00:00 0.0063 0.0136 -0.0012 -0.0129 0.0002
2017-07-21 00:00:00 -0.0040 0.0055 0.0006 -0.0047 0.0002
2017-07-28 00:00:00 -0.0315 -0.0003 -0.0055 0.0069 0.0002
2017-08-04 00:00:00 -0.0736 0.0009 -0.0179 0.0084 0.0002
2017-08-11 00:00:00 0.0313 -0.0152 -0.0099 -0.0109 0.0002
2017-08-18 00:00:00 -0.0328 -0.0067 -0.0073 -0.0036 0.0002
2017-08-25 00:00:00 -0.0106 0.0082 0.0056 0.0070 0.0002
2017-09-01 00:00:00 0.0006 0.0161 0.0143 -0.0144 0.0002
2017-09-08 00:00:00 -0.0023 -0.0077 0.0027 -0.0139 0.0002
2017-09-15 00:00:00 0.0379 0.0170 0.0068 0.0178 0.0002
2017-09-22 00:00:00 0.0377 0.0039 0.0088 0.0158 0.0002
2017-09-29 00:00:00 -0.0012 0.0091 0.0215 0.0059 0.0002
2017-10-06 00:00:00 0.0163 0.0129 0.0012 -0.0019 0.0002
2017-10-13 00:00:00 -0.0068 0.0003 -0.0067 -0.0025 0.0002
2017-10-20 00:00:00 0.0349 0.0090 -0.0077 0.0076 0.0002
2017-10-27 00:00:00 0.0389 0.0025 -0.0059 -0.0008 0.0002
2017-11-03 00:00:00 0.0255 0.0019 -0.0124 -0.0034 0.0002
2017-11-10 00:00:00 0.0370 -0.0041 -0.0106 -0.0095 0.0002
2017-11-17 00:00:00 -0.0266 0.0021 0.0111 0.0003 0.0002
2017-11-24 00:00:00 -0.0019 0.0104 0.0110 -0.0085 0.0002
2017-12-01 00:00:00 0.0947 0.0161 -0.0091 0.0221 0.0002
2017-12-08 00:00:00 0.1351 0.0030 -0.0143 0.0017 0.0002
2017-12-15 00:00:00 -0.0149 0.0081 -0.0027 -0.0069 0.0002
2017-12-22 00:00:00 -0.0180 0.0054 0.0079 0.0047 0.0002
2017-12-29 00:00:00 -0.0355 -0.0037 0.0002 -0.0018 0.0002
2018-01-05 00:00:00 0.0225 0.0254 -0.0064 -0.0046 0.0003
2018-01-12 00:00:00 -0.0231 0.0181 0.0040 0.0111 0.0003
2018-01-19 00:00:00 0.0081 0.0084 -0.0063 -0.0050 0.0003
2018-01-26 00:00:00 0.0076 0.0205 -0.0145 -0.0109 0.0003
2018-02-02 00:00:00 -0.0438 -0.0381 -0.0050 -0.0014 0.0003
2018-02-09 00:00:00 -0.0556 -0.0509 0.0100 0.0006 0.0003
2018-02-16 00:00:00 -0.0392 0.0451 0.0011 -0.0061 0.0003
2018-02-23 00:00:00 -0.0037 0.0048 0.0011 -0.0059 0.0003
2018-03-02 00:00:00 0.0438 -0.0174 0.0105 -0.0090 0.0003
2018-03-09 00:00:00 0.0703 0.0360 0.0034 -0.0016 0.0003
2018-03-16 00:00:00 -0.0309 -0.0121 0.0082 -0.0010 0.0003
2018-03-23 00:00:00 -0.0202 -0.0582 0.0166 -0.0019 0.0003
2018-04-06 00:00:00 0.0365 -0.0138 0.0056 0.0068 0.0004
2018-04-13 00:00:00 0.0067 0.0205 0.0099 -0.0102 0.0004
2018-04-20 00:00:00 -0.0002 0.0073 0.0008 0.0051 0.0004
2018-04-27 00:00:00 0.0882 -0.0029 -0.0055 0.0042 0.0004
2018-05-04 00:00:00 0.1839 -0.0016 0.0104 -0.0128 0.0004
2018-05-11 00:00:00 0.0488 0.0243 0.0039 -0.0028 0.0004
2018-05-18 00:00:00 -0.0037 -0.0022 0.0252 -0.0005 0.0004
2018-05-25 00:00:00 -0.0019 0.0022 -0.0036 -0.0040 0.0004
2018-06-01 00:00:00 0.0310 0.0061 0.0127 -0.0123 0.0003
2018-06-08 00:00:00 0.0834 0.0168 0.0044 -0.0019 0.0003
2018-06-15 00:00:00 0.0023 0.0021 0.0089 -0.0223 0.0003
2018-06-22 00:00:00 0.0539 -0.0085 0.0140 0.0015 0.0003
2018-06-29 00:00:00 -0.0388 -0.0160 -0.0131 0.0001 0.0003
2018-07-06 00:00:00 -0.0290 0.0165 0.0174 -0.0105 0.0004
2018-07-13 00:00:00 0.0012 0.0139 -0.0163 -0.0121 0.0004
2018-07-20 00:00:00 0.0564 0.0014 0.0005 0.0047 0.0004
2018-07-27 00:00:00 -0.0522 0.0017 -0.0276 0.0145 0.0004
2018-08-03 00:00:00 -0.1254 0.0065 -0.0010 0.0026 0.0004
2018-08-10 00:00:00 0.0043 0.0005 0.0090 -0.0080 0.0004
2018-08-17 00:00:00 0.0299 0.0046 -0.0043 0.0011 0.0004
2018-08-24 00:00:00 0.0048 0.0106 0.0132 -0.0097 0.0004
2018-08-31 00:00:00 0.0325 0.0096 -0.0005 -0.0187 0.0004
2018-09-07 00:00:00 -0.0422 -0.0114 -0.0082 0.0029 0.0004
2018-09-14 00:00:00 -0.0121 0.0120 -0.0048 -0.0071 0.0004
2018-09-21 00:00:00 0.0173 0.0054 -0.0118 0.0179 0.0004
2018-09-28 00:00:00 0.0828 -0.0052 0.0007 -0.0265 0.0004
2018-10-05 00:00:00 -0.0290 -0.0142 -0.0316 0.0336 0.0005
2018-10-12 00:00:00 -0.0665 -0.0426 -0.0076 -0.0003 0.0005
2018-10-19 00:00:00 -0.0436 -0.0015 -0.0098 0.0057 0.0005
2018-10-26 00:00:00 -0.0434 -0.0406 0.0036 -0.0115 0.0005
2018-11-02 00:00:00 -0.0968 0.0287 0.0155 0.0062 0.0004
2018-11-09 00:00:00 0.0795 0.0175 -0.0259 0.0121 0.0004
2018-11-16 00:00:00 -0.0075 -0.0165 0.0021 0.0031 0.0004
2018-11-23 00:00:00 0.0156 -0.0374 0.0117 0.0085 0.0004
2018-11-30 00:00:00 0.0818 0.0478 -0.0183 -0.0177 0.0004
2018-12-07 00:00:00 -0.1372 -0.0483 -0.0074 -0.0046 0.0005
2018-12-14 00:00:00 -0.0453 -0.0145 -0.0135 -0.0157 0.0005
2018-12-21 00:00:00 -0.0717 -0.0732 -0.0163 0.0210 0.0005
2018-12-28 00:00:00 0.0242 0.0314 0.0110 -0.0137 0.0005
2019-01-04 00:00:00 0.0637 0.0214 0.0135 0.0125 0.0005
2019-01-11 00:00:00 0.0975 0.0295 0.0209 -0.0142 0.0005
2019-01-18 00:00:00 -0.0276 0.0280 -0.0074 0.0078 0.0005
2019-01-25 00:00:00 -0.0231 -0.0028 0.0010 -0.0028 0.0005
2019-02-01 00:00:00 -0.0033 0.0157 -0.0027 -0.0094 0.0005
2019-02-08 00:00:00 0.0572 0.0008 0.0029 -0.0137 0.0005
2019-02-15 00:00:00 0.0429 0.0273 0.0157 -0.0004 0.0005
2019-02-22 00:00:00 -0.0025 0.0064 0.0095 -0.0071 0.0005
2019-03-01 00:00:00 -0.0079 0.0050 -0.0033 -0.0141 0.0005
2019-03-08 00:00:00 -0.0036 -0.0255 -0.0197 -0.0018 0.0005
2019-03-15 00:00:00 0.0205 0.0283 -0.0091 -0.0057 0.0005
2019-03-22 00:00:00 0.0189 -0.0111 -0.0155 -0.0253 0.0005
2019-03-29 00:00:00 0.0881 0.0127 0.0107 -0.0030 0.0005
2019-04-05 00:00:00 0.0166 0.0214 0.0051 0.0113 0.0005
2019-04-12 00:00:00 0.0088 0.0055 -0.0083 0.0111 0.0005
2019-04-26 00:00:00 0.0359 0.0124 0.0031 -0.0159 0.0005
2019-05-03 00:00:00 -0.0286 0.0027 0.0076 0.0003 0.0005
2019-05-10 00:00:00 0.0032 -0.0222 -0.0010 -0.0002 0.0005
2019-05-17 00:00:00 -0.0103 -0.0102 -0.0152 -0.0047 0.0005
2019-05-24 00:00:00 -0.0102 -0.0130 -0.0051 -0.0012 0.0005
2019-05-31 00:00:00 0.0370 -0.0271 -0.0043 -0.0112 0.0005
2019-06-07 00:00:00 0.0380 0.0427 -0.0123 -0.0080 0.0005
2019-06-14 00:00:00 0.0528 0.0046 0.0000 -0.0008 0.0005
2019-06-21 00:00:00 -0.0043 0.0221 0.0011 -0.0182 0.0005
2019-06-28 00:00:00 0.0816 -0.0011 0.0140 0.0164 0.0005
2019-07-05 00:00:00 0.0190 0.0156 -0.0125 -0.0040 0.0005
2019-07-12 00:00:00 0.0260 0.0072 -0.0137 -0.0041 0.0005
2019-07-19 00:00:00 -0.0174 -0.0122 -0.0037 -0.0065 0.0005
2019-07-26 00:00:00 -0.0004 0.0175 -0.0022 0.0073 0.0005
2019-08-02 00:00:00 0.0156 -0.0345 0.0032 -0.0098 0.0004
2019-08-09 00:00:00 0.1784 -0.0061 -0.0068 -0.0207 0.0004
2019-08-16 00:00:00 0.0942 -0.0117 0.0025 -0.0128 0.0004
2019-08-23 00:00:00 0.0078 -0.0157 -0.0077 -0.0024 0.0004
2019-08-30 00:00:00 0.0134 0.0270 -0.0052 0.0032 0.0004
2019-09-06 00:00:00 0.0399 0.0161 -0.0116 0.0128 0.0004
2019-09-13 00:00:00 -0.0308 0.0133 0.0288 0.0500 0.0004
2019-09-20 00:00:00 0.0434 -0.0064 -0.0051 -0.0103 0.0004
2019-09-27 00:00:00 -0.0840 -0.0136 -0.0184 0.0198 0.0004
2019-10-04 00:00:00 -0.0090 -0.0040 -0.0044 -0.0250 0.0004
2019-10-11 00:00:00 -0.0321 0.0069 -0.0044 0.0023 0.0004
2019-10-18 00:00:00 0.0130 0.0047 0.0075 0.0054 0.0004
2019-10-25 00:00:00 -0.0872 0.0138 0.0033 0.0070 0.0004
2019-11-01 00:00:00 -0.0230 0.0147 0.0035 -0.0056 0.0003
2019-11-08 00:00:00 -0.2502 0.0101 -0.0042 0.0230 0.0003
2019-11-15 00:00:00 0.0097 0.0078 -0.0067 -0.0179 0.0003
2019-11-22 00:00:00 -0.0469 -0.0019 -0.0005 -0.0158 0.0003
2019-11-29 00:00:00 0.0378 0.0113 0.0154 -0.0160 0.0003
2019-12-06 00:00:00 -0.0536 0.0010 0.0048 0.0074 0.0004
2019-12-13 00:00:00 0.0056 0.0074 0.0017 0.0075 0.0004
2019-12-20 00:00:00 0.0425 0.0171 0.0035 0.0000 0.0004
2019-12-27 00:00:00 -0.0159 0.0049 -0.0048 -0.0042 0.0004