historical data (2) - Excel Search File Home Insert Formulas Review View Help 15 Share LE 21 Clear Data Analysis Get Sort Filter Reapply What-If Forecast Columns Advanced Get & Transform Data Queries & Connections Data Types Sort & Filter Forecast Analysis Q66 X R DX Adj. Close IP Adj Close HPR(S&P) DX ER 13.762142 -4.65% 5.95% 2.36% 0.12% 0.0001000% -4.65 5.95% 2.36% 2013-12 0.12 1/1/13 14.43304 -1.909 2013-11 10/1/1 0.11% 9/1/13 14.934012 33.562408 1681.550049 9.22% 2.97% 0.10% -4.50% 2.97% 8/1/13 16.44% 2.289 -3.13% 0.11% 16.449 -2.28% 3.13% 2013-08 6/1/13 32.985905 1606.280029 0.20% -3.37% -1.50% 0.18% 0.0001500% 0.20% -3.37% -1.50% 0.18 17.153717 34.136803 1630.73999 2.08% 0.19% 0.0001583% 2013-05 3/1/13 1.39% 0.26% 2/1/13 32.31813 1514.68005 7.12% 1.11% 0.0002417% 6.25% 1.11% 2013-02 30.416195 8.17% 5.04% 0.27% 5.04% 2013-01 0.71% 0.29% 0.71% 11/1/12 0.329 3.66% 0.25% 0.0002083% -0.32% 3.66% 0.28% 10/1/12 6.080334 1412.160034 7.729 0.23% 0.0001917% 2012-10 1.73% 11.73% -0.10% 0.32 6/1/12 12.349 0.37% 0.37 -0.75% 3/1/12 0.42% 0.70% 0.40% 0.0003333% 0.70% 3.13% 2/1/12 24.942266 1365.680054 0.35% 0.0002917% 4.06% 2012-02 0.35 14.5531 2.58% 0.37% 2011-12 11/1/11 1.60% 0.31% -0.51% 2011-11 0.31 9/1/11 -13.419% -7.18% 0.40% 12.209 -7.189% 8/1/11 4.478291 18.877792 1218.890015 0.88% -8.599 0.46% 0.0003833% -8.59% -5.68% 2011- 08 7/1/11 0.48% 0.0004000% -2.15% 0.48 5/1/11 .40% 0.50% 1.10% 4/1/11 5.441772 21.294483 1363.60998 0.92% 2.85% 2.32% 2.85% 2/1/11 16.375 -1.03% -3.81% 3.20% 0.62% 0.0005167% -1.039 -3.81% 3.20% 1/1/11 19.786476 1286.119995 -1.39% 6.02% 2.26% 0.44% 0.0003667% -1.39% 6.02% 2.26% 0.44 12/1/10 0.49 10/1/10 1183.26001 0.919 1.42% 0.0011833% 1.42 9/1/10 14.829865 1.91% 7/1/10 14.789412 5.93% 6.94% 6.88% 2.28% 5.93% 6.94% 6.88% 6/1/10 13.961013 16.404726 1101.599976 15.340452 1030.709961 -2.09% -5.39% 0.0020167% -2.02% -2.09% -5.39% 5/1/10 4/1/10 3.87% 3/1/10 2.04% 6.34% 1.54% 6.33% 5.88% 2010-03 1.54 12/1/09 18.040937 1115.099976 8.18% 5.33% 0.0027167% 5.33% 1.77% 11/1/09 12.000087 17.127539 1095.630005 -0.49% 14.07% 5.74% -0.50% 14.07% 2009-11 9/1/09 1.81% -3.02% -3.02% 3.57% 8/1/09 2.13% 22.01% 0.0037250% -2.13% 3.35% 2009-08 Beta Question 4 Part 1 Copy of Beta 58% Enter Type here to search O cls 10/30/2020historical data (2) - Excel Search File Home Insert Formulas Review View Help 15 Share LE 21 Clear Data Analysis Get Sort Filter Reapply What-If Forecast Columns Advanced Data Types Analysis Get & Transform Data Queries & Connections Sort & Filter Forecast Q66 X R DX Adj. Close IP Adj Close DX ER S&P ER 12/1/13 13.762142 -4.65% -4.659 5.95% 2013-12 0.12 7/1/1 16.88803 23.688829 1379.31994 1.26% 13.49 0.29 6/1/12 0.32% 12.349 6.27% 2012-05 5/1/12 0.894791 0.37% 0.0003083% 6.27% 0.37 0.45 /1/12 -5.10% -0.75% -0.75% 2012-04 2.709% 12.88% 0.35% 1/1/12 14.905293 22.096786 1312.410034 2.42% 0.35% 0.0002917% 4.36% 2012-01 2.58% 0.85% 0.37% 0.0003083% 0.85% 10/1/11 9.474686 1253.30004 9.85% 10.77% 0.37% 0.0003083% 10.77% 9/1/11 12.71187 16.346083 1131.42004 2.20% 13.419 0.40% 0.0003333% 12.209 -7.18% 7/1/11 14.35211 20.650848 1292.280029 -5.149% -0.409% -2.15% 0.48% 0.0004000% -5.149 -2.15%% 0.48 6/1/11 -2.42% - 3.69% -1.83% 0.51% 0.0004250% -2.42% -3.69% -1.83% 2011-06 0.51 0.40% 3/1/11 -4.82% -4.83% 9.35% 2/1/11 16.375 -1.03% 0.62% -1.03% 12/1/10 16.777908 18.66287 1257.640015 4.00% 9.62% 6.53% 0.49% 0.0004083% 4.00% 9.62% 6.53% 0.49 11/1/10 16.132612 -0.94% -1.23% -0.23% 0.0008917% -1.23% -0.23% 1.07 2010-10 10/1/10 -0.91% 9/1/10 7.26% 0.0015917% 8/1/10 13.869452 1049.32995 3.61% 15.45%% -4.749% 2.18% -4.75% 2.18 2010-07 5/1/10 14.248401 1.62% -13.13% 2.06% 0.0017167% -8.20% 2010-05 4/1/10 3.87% 8.66% 1.74% 0.0014500% 8.65% 2/1/10 5.608982 -2.54% 2.05% 0.0017083% 2.05 /1/10 13.574679 15.433818 1073.869995 4.459 14.45% 3.70% 2.71 11/1/09 17.127539 1095.630005 0.499 14.079 3.50% 0.0029167% -0.509 5.73% 10/1/09 15.014361 1036.189941 -2.94% 0.36% 4.10% 0.0034167% -2.959 0.36% -1.98% 2009-10 9/1/09 1.81% 8/1/09 12.469412 987.47998 0.00413339% 4.96 7/1/09 6/1/09 11.976533 10.169501 0.49% 0.02% 4.96% 5.51% 0.02% 4/1/09 10.296897 1.49% 79.83% 9.39% 0.0041083% 9.39% 3/1/09 10.145984 11.43% 27.929% 8.54% 0.00410009 11.429 8.54% 4.92 2/1/0 735.090027 5.05% 10.909 2009-02 1/1/09 5.916698 825.880005 -8.579 5.06% -22.72% -8.57% 12/1/08 9.348572 903.25 0.0494 2008-12 4.94 0.0012381% 1.286066% 0.057193721 Stand: 0.057197105 0.14858 882 0.19801121 Variar 0.003271509 0.022078637 0.002126542 0.003271122 0.021713 0.00211072 0.03920844 0.03920844 Part 1 International Portfolio Beta Q Question 4 Part 1 Question 5 Part 1 Copy of Beta 58% Enter Type here to search O cls 10/30/2020