data Analytics

dexter90
Delldata.xlsx

Sheet1

Date S and P return Dell return
1-Sep-88 0.042 0.2821128451
1-Oct-88 0.027 0.1582397004
1-Nov-88 -0.014 -0.0840743735
1-Dec-88 0.018 -0.0803177405
1-Jan-89 0.072 -0.0499040307
1-Feb-89 -0.025 -0.1717171717
1-Mar-89 0.024 -0.0951219512
1-Apr-89 0.052 0.1051212938
1-May-89 0.04 0.0792682927
1-Jun-89 -0.005 -0.0734463277
1-Jul-89 0.09 -0.1426829268
1-Aug-89 0.019 0.0369843528
1-Sep-89 -0.004 0.0178326475
1-Oct-89 -0.023 -0.1576819407
1-Nov-89 0.021 -0.0416
1-Dec-89 0.024 -0.0434056761
1-Jan-90 -0.067 -0.1588132635
1-Feb-90 0.013 0.3506224066
1-Mar-90 0.026 0.2196620584
1-Apr-90 -0.025 0.1146095718
1-May-90 0.098 0.2949152542
1-Jun-90 -0.007 0.147469459
1-Jul-90 -0.003 -0.0692015209
1-Aug-90 -0.09 0
1-Sep-90 -0.049 -0.2557189542
1-Oct-90 -0.004 0.2151481888
1-Nov-90 0.064 0.2348690154
1-Dec-90 0.027 0.4096561814
1-Jan-91 0.044 0.2231447846
1-Feb-91 0.072 0.1158252015
1-Mar-91 0.024 0.1288973384
1-Apr-91 0.003 -0.1798585382
1-May-91 0.043 0.0587268994
1-Jun-91 -0.046 -0.0100853375
1-Jul-91 0.047 0.1735893417
1-Aug-91 0.024 0.134557596
1-Sep-91 -0.016 0.02324897
1-Oct-91 0.013 -0.2548173713
1-Nov-91 -0.04 -0.0551910459
1-Dec-91 0.114 0.0902777778
1-Jan-92 -0.019 0.2439115774
1-Feb-92 0.013 0.0942771084
1-Mar-92 -0.02 0.0429397192
1-Apr-92 0.029 0.0826075482
1-May-92 0.005 0.0236470015
1-Jun-92 -0.015 -0.3255537033
1-Jul-92 0.04 0.2690677966
1-Aug-92 -0.02 0.0976627713
1-Sep-92 0.012 0.1338403042
1-Oct-92 0.004 0.1920411357
1-Nov-92 0.034 0.0768942236
1-Dec-92 0.013 0.3061650993
1-Jan-93 0.007 -0.0364
1-Feb-93 0.014 -0.3053825931
1-Mar-93 0.022 0.0932270916
1-Apr-93 -0.025 -0.1743804665
1-May-93 0.027 -0.167954094
1-Jun-93 0.003 -0.2228116711
1-Jul-93 -0.005 0.0733788396
1-Aug-93 0.038 -0.0871224165
1-Sep-93 -0.007 -0.0950888192
1-Oct-93 0.02 0.2178598922
1-Nov-93 -0.009 0.3394437421
1-Dec-93 0.012 -0.1658801321
1-Jan-94 0.034 -0.0274398868
1-Feb-94 -0.027 0.1361256545
1-Mar-94 -0.044 0.009984639
1-Apr-94 0.013 -0.1285171103
1-May-94 0.016 0.3010471204
1-Jun-94 -0.025 -0.0786943886
1-Jul-94 0.033 0.0616355254
1-Aug-94 0.041 0.1606857143
1-Sep-94 -0.024 0.1520283576
1-Oct-94 0.023 0.1885470085
1-Nov-94 -0.037 -0.0322163095
1-Dec-94 0.015 -0.0480011889
1-Jan-95 0.026 0.0396503278
1-Feb-95 0.039 -0.0264264264
1-Mar-95 0.03 0.0542874769
1-Apr-95 0.029 0.2514628438
1-May-95 0.04 -0.0799532437
1-Jun-95 0.024 0.1936221573
1-Jul-95 0.033 0.0810005322
1-Aug-95 0.003 0.1846199291
1-Sep-95 0.042 0.1038982628
1-Oct-95 -0.004 0.0970559446
1-Nov-95 0.044 -0.0509265614
1-Dec-95 0.019 -0.21752965
1-Jan-96 0.034 -0.2093345656
1-Feb-96 0.01 0.2556399766
1-Mar-96 0.01 -0.0254142618
1-Apr-96 0.015 0.3693762537
1-May-96 0.026 0.2071010045
1-Jun-96 0.004 -0.0813059809
1-Jul-96 -0.045 0.0909548371
1-Aug-96 0.021 0.2094672509
1-Sep-96 0.056 0.1582685799
1-Oct-96 0.027 0.0466312714
1-Nov-96 0.076 0.2488399528
1-Dec-96 -0.02 0.0455003464
1-Jan-97 0.062 0.2447068036
1-Feb-97 0.008 0.0756145954
1-Mar-97 -0.042 -0.0491980294
1-Apr-97 0.06 0.2375195192
1-May-97 0.061 0.3442691903
1-Jun-97 0.045 0.0438900899
1-Jul-97 0.079 0.4561023461
1-Aug-97 -0.056 -0.040205848
1-Sep-97 0.055 0.1805065414
1-Oct-97 -0.033 -0.1729069979
1-Nov-97 0.046 0.0507009066
1-Dec-97 0.017 -0.0022236159
1-Jan-98 0.011 0.1837809524
1-Feb-98 0.072 0.4066630731
1-Mar-98 0.051 -0.0312793118
1-Apr-98 0.01 0.1918819188
1-May-98 -0.017 0.0205126935
1-Jun-98 0.041 0.1262765999
1-Jul-98 -0.011 0.1700333145
1-Aug-98 -0.145 -0.0791354187
1-Sep-98 0.064 0.315
1-Oct-98 0.081 -0.0038022814
1-Nov-98 0.061 -0.0715664122
1-Dec-98 0.058 0.2034979708
1-Jan-99 0.042 0.3663516771
1-Feb-99 -0.031 -0.19875
1-Mar-99 0.04 0.0202808112
1-Apr-99 0.039 0.0076452599
1-May-99 -0.024 -0.1638846737
1-Jun-99 0.056 0.0744101633
1-Jul-99 -0.031 0.1047297297
1-Aug-99 -0.005 0.1941896024
1-Sep-99 -0.027 -0.1434058899
1-Oct-99 0.063 -0.0403587444
1-Nov-99 0.02 0.0716510903
1-Dec-99 0.059 0.1860465116
1-Jan-00 -0.05 -0.2463235294
1-Feb-00 -0.019 0.0617886179
1-Mar-00 0.098 0.3215926493
1-Apr-00 -0.03 -0.0706836616
1-May-00 -0.021 -0.1396508728
1-Jun-00 0.025 0.1434782609
1-Jul-00 -0.016 -0.1089987326
1-Aug-00 0.062 -0.0071123755
1-Sep-00 -0.053 -0.2936962751
1-Oct-00 -0.004 -0.0425963489

Sheet2

Sheet3