Hi Sarahmarkhan,could you help me to do the question 3?Only the question 3,thank you so much!

Date 4/28/2000 5/31/2000 6/30/2000 7/31/2000 8/31/2000 9/29/2000 10/31/2000 11/30/2000 12/29/2000 1/31/2001 2/28/2001 3/30/2001 4/30/2001 5/31/2001 6/29/2001 7/31/2001 8/31/2001 9/28/2001 10/31/2001 11/30/2001 12/31/2001 1/31/2002 2/28/2002 3/29/2002 4/30/2002 5/31/2002 6/28/2002 7/31/2002 8/30/2002 9/30/2002 10/31/2002 11/29/2002 12/31/2002 1/31/2003 2/28/2003 3/31/2003 4/30/2003 5/30/2003 6/30/2003 7/31/2003 8/29/2003 9/30/2003 10/31/2003 11/28/2003 12/31/2003 1/30/2004 2/27/2004 PE 22.08 21.36 22.74 22.4 19.92 19.79 19.34 19.1 18.76 19.64 19.13 17.97 19.06 19.3 19.23 18.25 18.57 17.48 18.61 20.13 20.65 20.63 21.62 22.32 21.76 21.43 20.36 19.59 20.07 19.03 19.15 18.67 18.22 18.03 17.02 17.55 18.71 18 18.14 18.89 20.58 19.29 19.67 17.9 18.5 18.67 17.57 DY 3.13 3.22 3.02 3.08 3.13 3.21 3.24 3.22 3.27 3.11 3.15 3.34 3.14 3.13 3.2 3.35 3.53 3.51 3.32 3.21 3.39 3.15 3.09 3.07 3.14 3.17 3.33 3.48 3.45 3.69 3.61 3.63 3.69 3.8 3.96 3.85 3.7 3.73 3.73 3.59 3.63 3.71 3.64 3.71 3.57 3.55 3.56 PI 3085.1 3040.6 3257.6 3213.6 3261.7 3246.1 3203.9 3222 3154.7 3291.5 3274.1 3096.9 3270.3 3317.2 3425.2 3270.8 3217.8 2988 3185.3 3276.9 3359.9 3404 3358.6 3363.3 3299.5 3325.1 3163.2 3032.6 3073.7 2928.3 2995 3025.2 2975.5 2935.4 2778.4 2848.6 2970.9 2979.8 2999.7 3106.7 3202.9 3176.2 3282.4 3195.7 3306 3283.6 3372.5 RI Int Rate 14471.4 6.04 14284.5 6.31 15384 6.23 15179 6.20 15441 6.49 15472 6.57 15297 6.41 15469 6.33 15167 6.20 15827 5.91 15791 5.59 15029 5.14 15886 4.86 16139.6 4.89 16745 4.97 15993 5.04 15792 4.95 14738 4.55 15740 4.36 16271 4.28 16703.7 4.25 16924 4.26 16745 4.31 16876 4.46 16576 4.59 16727.1 4.84 15991 5.07 15334 4.98 15611 4.96 14973 4.92 15357 4.90 15583 4.84 15351.3 4.83 15147 4.80 14391 4.75 14888 4.76 15541 4.79 15620 4.78 15818 4.67 16389 4.72 16964 4.82 16941 4.91 17530.7 4.97 17156 5.31 17787 5.47 17668 5.55 18218 5.57 MV 634878 616440 661306 655211 667249 665713 654696 660245 647981 677262 674838 640182 684694 706141 731350 696368 690510 637779 680742 701486 720543 730625 717582 721098 716520 723499 688364 664886 674402 643353 660222 666129 655949 650167 614895 627354 658441 661936 662017 689132 707535 704703 727806 711585 738376 738963 759171 TE 28753.5326087 28859.5505618 29081.17854 29250.4910714 33496.435743 33638.8580091 33851.9131334 34567.8010471 34540.565032 34483.808554 35276.4244642 35625.0417362 35923.0849948 36587.6165803 38031.7212689 38157.1506849 37184.1680129 36486.2128146 36579.3659323 34847.7893691 34893.1234867 35415.6568105 33190.6567993 32307.2580645 32928.3088235 33761.0359309 33809.6267191 33940.071465 33602.4912805 33807.3042564 34476.3446475 35679.1108731 36001.5916575 36060.2884082 36127.7908343 35746.6666667 35191.9294495 36774.2222222 36494.8732084 36481.3128639 34379.7376093 36532.037325 37000.8134215 39753.3519553 39912.2162162 39580.2356722 43208.3665339 3/31/2004 4/30/2004 5/31/2004 6/30/2004 7/30/2004 8/31/2004 9/30/2004 10/29/2004 11/30/2004 12/31/2004 1/31/2005 2/28/2005 3/31/2005 4/29/2005 5/31/2005 6/30/2005 7/29/2005 8/31/2005 9/30/2005 10/31/2005 11/30/2005 12/30/2005 1/31/2006 2/28/2006 3/31/2006 4/28/2006 5/31/2006 6/30/2006 7/31/2006 8/31/2006 9/29/2006 10/31/2006 11/30/2006 12/29/2006 1/31/2007 2/28/2007 3/30/2007 4/30/2007 5/31/2007 6/29/2007 7/31/2007 8/31/2007 9/28/2007 10/31/2007 11/30/2007 12/31/2007 1/31/2008 2/29/2008 17.74 17.63 17.4 17.98 18.19 16.89 17.06 17.47 18.07 19 19.52 19.84 18.76 18.66 17.3 17.93 18.27 18.18 16.82 16.02 16.46 16.95 17.55 17.29 17.64 18.03 15.8 16.14 15.75 16.16 15.24 15.97 16.54 17.36 17.92 17.28 16.34 16.8 17.08 15.98 15.86 15.32 15.77 16.05 15.6 15.05 13.47 13.13 3.46 3.49 3.5 3.43 3.33 3.56 3.49 3.4 3.26 3.19 3.16 3.17 3.28 3.33 3.43 3.38 3.32 3.29 3.52 3.66 3.54 3.44 3.35 3.35 3.22 3.19 3.53 3.53 3.62 3.72 3.76 3.61 3.52 3.44 3.35 3.43 3.46 3.38 3.3 3.4 3.35 3.36 3.2 3.14 3.29 3.37 3.9 3.88 3416.4 3407.7 3456.9 3530.3 3546.1 3561.9 3674.7 3786.3 3942.8 4053.1 4106.7 4156.5 4100.6 3943.1 4070.4 4229.9 4346.7 4413.5 4592.6 4412.7 4583.6 4708.8 4880.2 4878.4 5087.2 5207 4972.3 5034 4957.1 5079.8 5113 5352.9 5461.6 5644.3 5757.7 5816.5 5978.8 6158.3 6341.8 6310.6 6187.5 6248.3 6580.9 6779.1 6593.6 6421 5697 5674.7 18581 18557 18857 19356.2 19467 19671 20413 21055 22028.8 22690.1 22992 23405 23230.8 22352 23115 24146 24814 25354 26559.3 25542 26665 27475 28477 28676 30054 30777 29442 29988.8 29534.5 30472 30853 32335 33136 34334 35026 35584 36767 37887 39096 39070 38311 38961 41212 42478 41478 40498 35943 36037 5.51 5.54 5.51 5.49 5.46 5.44 5.42 5.41 5.43 5.41 5.42 5.63 5.81 5.75 5.68 5.66 5.65 5.62 5.62 5.63 5.63 5.63 5.63 5.61 5.61 5.69 5.87 5.96 6.05 6.19 6.21 6.28 6.37 6.39 6.43 6.37 6.43 6.48 6.37 6.42 6.47 6.75 6.94 6.91 7.15 7.29 7.18 7.69 787547 786794 799078 816230 820804 823857 853567 880681 917562 947527 960387 973627 966032 926651 952202 979544 1006107 1022227 1010710 972768 1010495 1043449 1081953 1082109 1152938 1180979 1125117 1143360 1126395 1154573 1170607 1222547 1254619 1308120 1329638 1343901 1410777 1452446 1494763 1505801 1461694 1466734 1558061 1602109 1554691 1511599 1341299 1331469 44393.8556933 44628.1338627 45924.0229885 45396.5517241 45123.9142386 48777.7975133 50033.2356389 50411.04751 50778.1959048 49869.8421053 49200.1536885 49073.9415323 51494.2430704 49659.7534834 55040.5780347 54631.5672058 55068.8013136 56228.1078108 60089.7740785 60722.0973783 61390.9477521 61560.4129794 61649.7435897 62585.8299595 65359.2970522 65500.7764836 71209.9367089 70840.1486989 71517.1428571 71446.3490099 76811.4829396 76552.7238572 75853.6275695 75352.5345622 74198.5491071 77772.0486111 86338.8616891 86455.1190476 87515.3981265 94230.350438 92162.295082 95739.8172324 98799.0488269 99819.8753894 99659.6794872 100438.471761 99576.7631774 101406.626047 3/31/2008 4/30/2008 5/30/2008 6/30/2008 7/31/2008 8/29/2008 9/30/2008 10/31/2008 11/28/2008 12/31/2008 1/30/2009 2/27/2009 3/31/2009 4/30/2009 5/29/2009 6/30/2009 7/31/2009 8/31/2009 9/30/2009 10/30/2009 11/30/2009 12/31/2009 1/29/2010 2/26/2010 3/31/2010 4/30/2010 5/31/2010 6/30/2010 7/30/2010 8/31/2010 9/30/2010 10/29/2010 11/30/2010 12/31/2010 1/31/2011 2/28/2011 3/31/2011 4/29/2011 5/31/2011 6/30/2011 7/29/2011 8/31/2011 9/30/2011 10/31/2011 11/30/2011 12/30/2011 1/31/2012 2/29/2012 12.79 13.53 14.02 13.11 12.05 12.27 12.49 11.26 10.26 10.38 9.78 9.93 10.98 11.42 11.98 12.38 13.27 15.69 15.84 15.68 15.84 16.38 15.93 16.16 15.82 15.51 14.56 14.21 14.68 13.33 14.34 14.55 14.59 15.22 15.21 15.28 16.55 16.17 15.32 14.83 14.41 13.39 12.23 12.93 12.54 12.38 13 13.7 4.26 4.09 3.96 4.27 4.57 4.52 4.65 5.8 6.48 6.42 6.76 6.89 6.14 5.95 5.72 5.52 5.24 4.73 3.46 4.9 5.04 4.7 4.83 4.79 4.25 3.53 3.78 3.89 3.78 3.96 3.79 3.8 3.85 3.68 3.67 3.69 3.66 3.7 3.86 3.96 4.07 4.34 4.9 4.59 4.7 5.05 4.81 4.5 5409.7 5657 5773.9 5332.9 5052.6 5215.5 4631.3 3982.7 3672.7 3659.3 3478.1 3296.9 3532.3 3744.7 3813.3 3947.8 4249.5 4484.1 4739.3 4646.9 4715.5 4882.7 4596.9 4651.1 4893.1 4833.9 4453.6 4324.8 4507.4 4438.8 4636.9 4733.4 4676.4 4846.9 4849.9 4923.6 4928.6 4899 4788.9 4659.8 4500.5 4369.8 4070.1 4360.5 4184.7 4111 4325.7 4388.1 34555 36159 37046.5 34336 32539 33848.6 30253.9 26042 24162 24143 22949 21971 23740 25181 25723 26732 28777 30640 32493 31879 32499 33698.6 31727 32304 34188 33785 31229 30415 31702 31476 33056 33774 33538 34813 34836 35600 35830 35623 34952 34118 32957 32297 30270 32440.8 31327 30833 32445 33227 7.90 7.84 7.75 7.81 7.75 7.31 7.27 6.03 4.76 4.39 3.74 3.16 3.16 3.10 3.13 3.25 3.14 3.30 3.37 3.78 3.95 4.13 4.20 4.16 4.33 4.55 4.81 4.89 4.84 4.74 4.82 4.81 5.02 5.03 4.96 4.92 4.92 4.90 5.00 4.99 4.96 4.86 4.81 4.73 4.62 4.51 4.41 4.37 1302711 1364748 1399502 1300700 1235582 1276564 1138867 980775 904561 925795 884973 845980 920531 979901 1009215 1060843 1146263 1215069 1302126 1276306 1296018 1348135 1268074 1282488 1362651 1348961 1243814 1210725 1262263 1239724 1285574 1311646 1293156 1338295 1339504 1359159 1365948 1353872 1322448 1282323 1241004 1204539 1122754 1203789 1150845 1110921 1169315 1185756 101853.870211 100868.292683 99821.8259629 99214.3401983 102537.925311 104039.445803 91182.3058447 87102.5754885 88163.8401559 89190.2697495 90488.0368098 85194.3605237 83837.0673953 85805.6917688 84241.6527546 85690.0646204 86380.0301432 77442.2562141 82204.9242424 81397.0663265 81819.3181818 82303.7240537 79602.8876334 79361.8811881 86134.7029077 86973.6299162 85426.7857143 85202.3223082 85985.2179837 93002.5506377 89649.511855 90147.4914089 88633.0363263 87930.0262812 88067.3241289 88950.1963351 82534.6223565 83727.3964131 86321.6710183 86468.1726231 86121.0270645 89958.103062 91803.270646 93100.4640371 91773.923445 89735.1373183 89947.3076923 86551.5328467 3/30/2012 4/30/2012 5/31/2012 6/29/2012 7/31/2012 8/31/2012 9/28/2012 10/31/2012 11/30/2012 12/31/2012 1/31/2013 2/28/2013 3/29/2013 4/30/2013 5/31/2013 6/28/2013 7/31/2013 8/30/2013 9/30/2013 10/31/2013 11/29/2013 12/31/2013 1/31/2014 2/28/2014 3/31/2014 4/30/2014 5/30/2014 6/30/2014 7/31/2014 8/29/2014 9/30/2014 10/31/2014 11/28/2014 12/31/2014 1/30/2015 2/27/2015 3/31/2015 4/30/2015 5/29/2015 6/30/2015 7/31/2015 8/31/2015 9/30/2015 10/30/2015 11/30/2015 12/31/2015 1/29/2016 2/29/2016 14.07 14.15 13.37 13.42 13.87 14.64 15.01 15.43 15.56 16.07 16.87 18.62 18 18.66 17.72 17.26 18.24 18.6 18.49 19.09 18.2 17.55 17.07 16.83 16.97 17.18 17.52 17.29 17.95 17.14 14.69 16.39 15.35 15.8 16.28 17.93 18.18 17.96 17.73 16.84 17.53 16.36 16.62 17.38 17 17.38 16.49 16.22 4.46 4.41 4.8 4.65 4.48 4.51 4.45 4.37 4.4 4.28 4.07 4.48 4.04 3.9 4.12 4.24 3.99 4.01 3.93 3.88 3.98 3.95 4.07 4.04 3.99 3.94 4.04 4.03 3.87 4 4.24 4.08 4.25 4.19 4.15 4.04 3.99 4.05 4.09 4.33 4.17 4.75 4.82 4.63 4.71 4.62 4.88 4.77 4420 4467.2 4133.7 4135.5 4289.4 4339 4406.3 4535.4 4518 4664.6 4901 5120.4 4979.9 5168.6 4914 4775.4 5035.7 5125.3 5217.7 5420.3 5314.3 5353.1 5205.1 5415.4 5403 5470.8 5473.8 5382 5623.1 5624.6 5296.8 5505 5298.1 5388.6 5551.6 5898.5 5861.9 5773.7 5774.9 5451.2 5681.7 5222.1 5058.6 5288.6 5218.2 5344.6 5056.6 4947.9 33608 33979 31634.5 31714 32901.4 33600 34315 35333 35427 36643 38504 40497 39590 41103 39300 38270 40360 41407 42395 44054 43446 43845 42634.5 44697 44810.8 45389 45667.4 45021 47044 47383 44891 46669 45175.8 46047 47442 50760 50746 49999 50290 47575 49589 45970 44820 46878 46555.2 47788 45216 44550.2 4.44 4.20 3.66 3.49 3.55 3.62 3.49 3.16 3.24 3.11 3.00 2.95 3.05 3.02 2.82 2.80 2.76 2.60 2.58 2.58 2.59 2.61 2.62 2.63 2.66 2.68 2.69 2.70 2.65 2.63 2.66 2.72 2.75 2.75 2.70 2.36 2.30 2.25 2.15 2.15 2.14 2.14 2.17 2.15 2.22 2.34 2.30 2.28 1202787 1212477 1124872 1125319 1169422 1182824 1201624 1237237 1231184 1273350 1338122 1398533 1368938 1420498 1349414 1313446 1385805 1411134 1439990 1496157 1465298 1476840 1436306 1495858 1509122 1529689 1523009 1497850 1563616 1562546 1478396 1536817 1481191 1509820 1555839 1653829 1666895 1644238 1648922 1553918 1624000 1496640 1458501 1530502 1514585 1556340 1472464 1440028 85485.9275053 85687.4204947 84134.0314136 83853.8748137 84313.0497477 80793.989071 80054.8967355 80183.8626053 79124.9357326 79237.7100187 79319.6206283 75109.1836735 76052.1111111 76125.2947481 76152.0316027 76097.6825029 75976.1513158 75867.4193548 77879.3942672 78373.86066 80510.8791209 84150.4273504 84142.1206796 88880.4515746 88928.8155569 89038.9406286 86929.7374429 86631.0005784 87109.5264624 91163.7106184 100639.618788 93765.5277608 96494.5276873 95558.2278481 95567.5061425 92238.0925823 91688.3938394 91550 93001.8048505 92275.415677 92641.1865374 91481.6625917 87755.7761733 88061.1047181 89093.2352941 89547.7560414 89294.3602183 88781.0110974 3/31/2016 4/29/2016 5/31/2016 6/30/2016 7/29/2016 AVERAGE ST.D 17.43 17.99 19.88 19.4 20.63 4.67 4.34 4.28 4.4 4.13 5151.8 5316 5447.8 5310.4 5644 46664 48173 49662 48530 51581 2.31 2.26 2.01 1.99 1.93 1512556 1562011 1600523 1561321 1661467 86778.8869765 86826.6259033 80509.2052314 80480.4639175 80536.4517693 16.75821 3.938112 4466.787 30356.92 4.6336559 1129006.39 69930.2682828 2.552398 0.71986 978.9625 10960.28 1.5037441 320411.596 23384.5684084 Data source: Datastream, RBA PE = the total market value of all constitutents divided by the total earnings at the end of each month DY = the total dividend of all constituents divided by the total market value at the end of each month; in PI = the All Ordinaries Index at the end of each month RI = the total return index which captures both price changes and dividend payouts Int Rate = Bank Accepted Bills/Negotiable Certificates of Deposit-3 months, monthly average, in percen MV = the total market value of all constituent companies in million dollar TE= total earnings at the end of each month Chart Title 25 20 15 10 5 0 PE DY Int Rate Chart Title 60000 50000 40000 30000 20000 10000 0 PI RI Chart Title 1800000 1600000 1400000 1200000 1000000 800000 600000 400000 200000 0 MV TE 600000 400000 200000 0 MV TE Before GFC Date 4/28/2000 5/31/2000 6/30/2000 7/31/2000 8/31/2000 9/29/2000 10/31/2000 11/30/2000 12/29/2000 1/31/2001 2/28/2001 3/30/2001 4/30/2001 5/31/2001 6/29/2001 7/31/2001 8/31/2001 9/28/2001 10/31/2001 11/30/2001 12/31/2001 1/31/2002 2/28/2002 3/29/2002 4/30/2002 5/31/2002 6/28/2002 7/31/2002 8/30/2002 9/30/2002 10/31/2002 11/29/2002 12/31/2002 1/31/2003 2/28/2003 3/31/2003 4/30/2003 5/30/2003 6/30/2003 7/31/2003 8/29/2003 9/30/2003 10/31/2003 11/28/2003 12/31/2003 1/30/2004 2/27/2004 PE 22.08 21.36 22.74 22.4 19.92 19.79 19.34 19.1 18.76 19.64 19.13 17.97 19.06 19.3 19.23 18.25 18.57 17.48 18.61 20.13 20.65 20.63 21.62 22.32 21.76 21.43 20.36 19.59 20.07 19.03 19.15 18.67 18.22 18.03 17.02 17.55 18.71 18 18.14 18.89 20.58 19.29 19.67 17.9 18.5 18.67 17.57 DY 3.13 3.22 3.02 3.08 3.13 3.21 3.24 3.22 3.27 3.11 3.15 3.34 3.14 3.13 3.2 3.35 3.53 3.51 3.32 3.21 3.39 3.15 3.09 3.07 3.14 3.17 3.33 3.48 3.45 3.69 3.61 3.63 3.69 3.8 3.96 3.85 3.7 3.73 3.73 3.59 3.63 3.71 3.64 3.71 3.57 3.55 3.56 PI 3085.1 3040.6 3257.6 3213.6 3261.7 3246.1 3203.9 3222 3154.7 3291.5 3274.1 3096.9 3270.3 3317.2 3425.2 3270.8 3217.8 2988 3185.3 3276.9 3359.9 3404 3358.6 3363.3 3299.5 3325.1 3163.2 3032.6 3073.7 2928.3 2995 3025.2 2975.5 2935.4 2778.4 2848.6 2970.9 2979.8 2999.7 3106.7 3202.9 3176.2 3282.4 3195.7 3306 3283.6 3372.5 RI Int Rate MV TE 14471.4 6.04 634878 28753.53 14284.5 6.31 616440 28859.55 15384 6.23 661306 29081.18 15179 6.20 655211 29250.49 15441 6.49 667249 33496.44 15472 6.57 665713 33638.86 15297 6.41 654696 33851.91 15469 6.33 660245 34567.8 15167 6.20 647981 34540.57 15827 5.91 677262 34483.81 15791 5.59 674838 35276.42 15029 5.14 640182 35625.04 15886 4.86 684694 35923.08 16139.6 4.89 706141 36587.62 16745 4.97 731350 38031.72 15993 5.04 696368 38157.15 15792 4.95 690510 37184.17 14738 4.55 637779 36486.21 15740 4.36 680742 36579.37 16271 4.28 701486 34847.79 16703.7 4.25 720543 34893.12 16924 4.26 730625 35415.66 16745 4.31 717582 33190.66 16876 4.46 721098 32307.26 16576 4.59 716520 32928.31 16727.1 4.84 723499 33761.04 15991 5.07 688364 33809.63 15334 4.98 664886 33940.07 15611 4.96 674402 33602.49 14973 4.92 643353 33807.3 15357 4.90 660222 34476.34 15583 4.84 666129 35679.11 15351.3 4.83 655949 36001.59 15147 4.80 650167 36060.29 14391 4.75 614895 36127.79 14888 4.76 627354 35746.67 15541 4.79 658441 35191.93 15620 4.78 661936 36774.22 15818 4.67 662017 36494.87 16389 4.72 689132 36481.31 16964 4.82 707535 34379.74 16941 4.91 704703 36532.04 17530.7 4.97 727806 37000.81 17156 5.31 711585 39753.35 17787 5.47 738376 39912.22 17668 5.55 738963 39580.24 18218 5.57 759171 43208.37 3/31/2004 4/30/2004 5/31/2004 6/30/2004 7/30/2004 8/31/2004 9/30/2004 10/29/2004 11/30/2004 12/31/2004 1/31/2005 2/28/2005 3/31/2005 4/29/2005 5/31/2005 6/30/2005 7/29/2005 8/31/2005 9/30/2005 10/31/2005 11/30/2005 12/30/2005 1/31/2006 2/28/2006 3/31/2006 4/28/2006 5/31/2006 6/30/2006 7/31/2006 8/31/2006 9/29/2006 10/31/2006 11/30/2006 12/29/2006 1/31/2007 2/28/2007 3/30/2007 4/30/2007 5/31/2007 6/29/2007 7/31/2007 8/31/2007 9/28/2007 10/31/2007 11/30/2007 12/31/2007 1/31/2008 2/29/2008 17.74 17.63 17.4 17.98 18.19 16.89 17.06 17.47 18.07 19 19.52 19.84 18.76 18.66 17.3 17.93 18.27 18.18 16.82 16.02 16.46 16.95 17.55 17.29 17.64 18.03 15.8 16.14 15.75 16.16 15.24 15.97 16.54 17.36 17.92 17.28 16.34 16.8 17.08 15.98 15.86 15.32 15.77 16.05 15.6 15.05 13.47 13.13 3.46 3.49 3.5 3.43 3.33 3.56 3.49 3.4 3.26 3.19 3.16 3.17 3.28 3.33 3.43 3.38 3.32 3.29 3.52 3.66 3.54 3.44 3.35 3.35 3.22 3.19 3.53 3.53 3.62 3.72 3.76 3.61 3.52 3.44 3.35 3.43 3.46 3.38 3.3 3.4 3.35 3.36 3.2 3.14 3.29 3.37 3.9 3.88 3416.4 3407.7 3456.9 3530.3 3546.1 3561.9 3674.7 3786.3 3942.8 4053.1 4106.7 4156.5 4100.6 3943.1 4070.4 4229.9 4346.7 4413.5 4592.6 4412.7 4583.6 4708.8 4880.2 4878.4 5087.2 5207 4972.3 5034 4957.1 5079.8 5113 5352.9 5461.6 5644.3 5757.7 5816.5 5978.8 6158.3 6341.8 6310.6 6187.5 6248.3 6580.9 6779.1 6593.6 6421 5697 5674.7 18581 18557 18857 19356.2 19467 19671 20413 21055 22028.8 22690.1 22992 23405 23230.8 22352 23115 24146 24814 25354 26559.3 25542 26665 27475 28477 28676 30054 30777 29442 29988.8 29534.5 30472 30853 32335 33136 34334 35026 35584 36767 37887 39096 39070 38311 38961 41212 42478 41478 40498 35943 36037 5.51 5.54 5.51 5.49 5.46 5.44 5.42 5.41 5.43 5.41 5.42 5.63 5.81 5.75 5.68 5.66 5.65 5.62 5.62 5.63 5.63 5.63 5.63 5.61 5.61 5.69 5.87 5.96 6.05 6.19 6.21 6.28 6.37 6.39 6.43 6.37 6.43 6.48 6.37 6.42 6.47 6.75 6.94 6.91 7.15 7.29 7.18 7.69 787547 786794 799078 816230 820804 823857 853567 880681 917562 947527 960387 973627 966032 926651 952202 979544 1006107 1022227 44393.86 44628.13 45924.02 45396.55 45123.91 48777.8 50033.24 50411.05 50778.2 49869.84 49200.15 49073.94 51494.24 49659.75 55040.58 54631.57 55068.8 56228.11 1010710 972768 1010495 1043449 1081953 1082109 1152938 1180979 1125117 1143360 1126395 1154573 1170607 1222547 1254619 1308120 1329638 1343901 1410777 1452446 1494763 1505801 1461694 1466734 1558061 60089.77 60722.1 61390.95 61560.41 61649.74 62585.83 65359.3 65500.78 71209.94 70840.15 71517.14 71446.35 76811.48 76552.72 75853.63 75352.53 74198.55 77772.05 86338.86 86455.12 87515.4 94230.35 92162.3 95739.82 98799.05 1602109 1554691 1511599 1341299 1331469 99819.88 99659.68 100438.5 99576.76 101406.6 3/31/2008 4/30/2008 5/30/2008 6/30/2008 7/31/2008 8/29/2008 9/30/2008 10/31/2008 11/28/2008 12/31/2008 12.79 13.53 14.02 13.11 12.05 12.27 12.49 11.26 10.26 10.38 4.26 4.09 3.96 4.27 4.57 4.52 4.65 5.8 6.48 6.42 5409.7 34555 5657 36159 5773.9 37046.5 5332.9 34336 5052.6 32539 5215.5 33848.6 4631.3 30253.9 3982.7 26042 3672.7 24162 3659.3 24143 7.90 7.84 7.75 7.81 7.75 7.31 7.27 6.03 4.76 4.39 1302711 1364748 1399502 1300700 1235582 1276564 1138867 980775 904561 101853.9 100868.3 99821.83 99214.34 102537.9 104039.4 91182.31 87102.58 88163.84 925795 89190.27 PE DY PI Before GFC Mean St Dev Var 17.6219047619 3.556476 4130.329 2.5384792901 0.561004 1128.716 6.4438771062 After GFC Mean St Dev Var 15.7616483516 4.378462 4855.008 2.189643433 0.626977 565.5302 4.7945383639 Full Sample Mean St Dev 16.7582142857 3.938112 4466.787 2.5523982438 0.71986 978.9625 z-Test: Two Sample for Means Mean Known Variance Observations Hypothesized Mean Difference z P(Z