Spreadsheet: 107070d1304247324-need-help-with-correlation-matrix-westpac
Sheet: Sheet 1 - Table 1

Price History
Westpac Banking Corporation (WBC)
Date | Close | Monthly Return | Average | [NAME]
2003-01-31 00:00:00 | 14.2 | -0.01418463499195641 | 0.004363286781070107 | 0.003501241163587666
2003-02-28 00:00:00 | 14 | 0.07563741420561998
2003-03-31 00:00:00 | 15.1 | 0.05162436540530724
2003-04-30 00:00:00 | 15.9 | 0.0248459985865308
2003-05-30 00:00:00 | 16.3 | -0.006153865574378335
2003-06-30 00:00:00 | 16.2 | 0.02439145312415926
2003-07-31 00:00:00 | 16.6 | -0.06213178110700628
2003-08-29 00:00:00 | 15.6 | 0.03774032798284711
2003-09-30 00:00:00 | 16.2 | 0
2003-10-31 00:00:00 | 16.2 | -0.05715841383994852
2003-11-28 00:00:00 | 15.3 | 0.04473589384139152
2003-12-31 00:00:00 | 16 | 0.0368139731227164
2004-01-30 00:00:00 | 16.6 | 0.01197619104671562
2004-02-27 00:00:00 | 16.8 | 0.04652001563489291
2004-03-31 00:00:00 | 17.6 | -0.005698021114637779
2004-04-30 00:00:00 | 17.5 | -0.01149437942573502
2004-05-31 00:00:00 | 17.3 | 0.01719240054037277
2004-06-30 00:00:00 | 17.6 | -0.04652001563489293
2004-07-30 00:00:00 | 16.8 | 0
2004-08-31 00:00:00 | 16.8 | 0.05218575317057004
2004-09-30 00:00:00 | 17.7 | 0.06559728248581327
2004-10-29 00:00:00 | 18.9 | -0.02139118998131745
2004-11-30 00:00:00 | 18.5 | 0.05264373348542188
2004-12-31 00:00:00 | 19.5 | -0.01550418653596531
2005-01-31 00:00:00 | 19.2 | -0.005221943981151601
2005-02-28 00:00:00 | 19.1 | -0.00524935588614379
2005-03-31 00:00:00 | 19 | 0.02083408690284183
2005-04-29 00:00:00 | 19.4 | 0.01025650016718928
2005-05-31 00:00:00 | 19.6 | 0.02020270731751947
2005-06-30 00:00:00 | 20 | -0.01005033585350145
2005-07-29 00:00:00 | 19.8 | -0.005063301956546762
2005-08-31 00:00:00 | 19.7 | 0.06865440473807818
2005-09-30 00:00:00 | 21.1 | -0.01432005377474856
2005-10-31 00:00:00 | 20.8 | 0.07410797215372183
2005-11-30 00:00:00 | 22.4 | 0.01769957709940108
2005-12-30 00:00:00 | 22.8 | 0.02169282461125975
2006-01-31 00:00:00 | 23.3 | 0.01279335145990954
2006-02-28 00:00:00 | 23.6 | 0.008438868645864604
2006-03-31 00:00:00 | 23.8 | 0.05318226546030922
2006-04-28 00:00:00 | 25.1 | -0.0917309355775444
2006-05-31 00:00:00 | 22.9 | 0.01731645001146096
2006-06-30 00:00:00 | 23.3 | -0.05741090721333904
2006-07-31 00:00:00 | 22 | 0.06169356900533975
2006-08-31 00:00:00 | 23.4 | -0.03037109787629876
2006-09-29 00:00:00 | 22.7 | 0.05568890586058863
2006-10-31 00:00:00 | 24 | 0.01652930195121051
2006-11-30 00:00:00 | 24.4 | -0.00823049913651548
2006-12-29 00:00:00 | 24.2 | 0.03651521297509747
2007-01-31 00:00:00 | 25.1 | 0.01581060602664225
2007-02-28 00:00:00 | 25.5 | 0.03468555798788989
2007-03-30 00:00:00 | 26.4 | 0.02247285585205858
2007-04-30 00:00:00 | 27 | -0.03390155167568134
2007-05-31 00:00:00 | 26.1 | -0.01544432242747374
2007-06-29 00:00:00 | 25.7 | 0.01926841886587699
2007-07-31 00:00:00 | 26.2 | 0.03745756253490042
2007-08-31 00:00:00 | 27.2 | 0.04668711397265326
2007-09-28 00:00:00 | 28.5 | 0.06782259633876109
2007-10-31 00:00:00 | 30.5 | -0.07486487896417399
2007-11-30 00:00:00 | 28.3 | -0.0142351158218721
2007-12-31 00:00:00 | 27.9 | -0.08603433734180303
2008-01-31 00:00:00 | 25.6 | -0.09413899091386191
2008-02-29 00:00:00 | 23.3 | 0.02123222010577412
2008-03-31 00:00:00 | 23.8 | 0.02898753687325219
2008-04-30 00:00:00 | 24.5 | -0.05452083887841711
2008-05-30 00:00:00 | 23.2 | -0.1484200051182732
2008-06-30 00:00:00 | 20 | 0.0769610411361284
2008-07-31 00:00:00 | 21.6 | 0.08855339734144503
2008-08-29 00:00:00 | 23.6 | -0.09319377689794738
2008-09-30 00:00:00 | 21.5 | -0.0574320490858754
2008-10-31 00:00:00 | 20.3 | -0.1258201732010324
2008-11-28 00:00:00 | 17.9 | -0.05158736879049312
2008-12-31 00:00:00 | 17 | -0.08594242980072477
2009-01-30 00:00:00 | 15.6 | 0.08004270767353636
2009-02-27 00:00:00 | 16.9 | 0.1223747131235566
2009-03-31 00:00:00 | 19.1 | 0.005221943981151625
2009-04-30 00:00:00 | 19.2 | -0.01574835696813917
2009-05-29 00:00:00 | 18.9 | 0.06652068234156243
2009-06-30 00:00:00 | 20.2 | 0.07162965613925486
2009-07-31 00:00:00 | 21.7 | 0.1172708717527423
2009-08-31 00:00:00 | 24.4 | 0.07117627846789495
2009-09-30 00:00:00 | 26.2 | 0.007604599385219213
2009-10-30 00:00:00 | 26.4 | -0.09115216965566109
2009-11-30 00:00:00 | 24.1 | 0.04859255523686528
2009-12-31 00:00:00 | 25.3 | -0.0569259367960097
2010-01-29 00:00:00 | 23.9 | 0.08805685539118287
2010-02-26 00:00:00 | 26.1 | 0.06310070636794354
2010-03-31 00:00:00 | 27.8 | -0.02181904739463984
2010-04-30 00:00:00 | 27.2 | -0.167722757372802
2010-05-31 00:00:00 | 23 | -0.08149303425118291
2010-06-30 00:00:00 | 21.2 | 0.1240526486699788
2010-07-30 00:00:00 | 24 | -0.1007415698015317
2010-08-31 00:00:00 | 21.7 | 0.06684001812585044
2010-09-30 00:00:00 | 23.2 | -0.0217873541849073
2010-10-29 00:00:00 | 22.7 | -0.05897400245955119
2010-11-30 00:00:00 | 21.4