PRICE DATA FOR 6 STOCKS AND THE S&P500 "Monthly returns" Hewlett-Packard Pfizer El Paso Pipelines Teva Kellogg Ford S&P500 HPQ PFE EPB TEVA K F ^GSPC Mean Variance Sigma Beta Excess Return Matrix Hewlett-Packard Pfizer El Paso Pipelines Teva Kellogg Ford S&P500 Hewlett-Packard Pfizer El Paso Pipelines Teva Kellogg Ford S&P500 Date HPQ PFE EPB TEVA K F ^GSPC Date HPQ PFE EPB TEVA K F ^GSPC 1/Feb/10 7.59% -5.21% 7.23% 5.97% -3.54% 7.95% 2.81% 1 1/Mar/10 4.71% -2.32% 7.45% 4.98% 2.44% 6.88% 5.71% 2 1/Apr/10 -2.26% -2.51% -1.77% -7.14% 2.78% 3.50% 1.47% 3 3/May/10 -12.17% -8.29% 2.06% -6.56% -2.09% -10.47% -8.55% 4 1/Jun/10 -5.97% -6.60% 3.84% -5.31% -6.02% -15.07% -5.54% 5 1/Jul/10 6.20% 5.07% 10.67% -6.23% -0.50% 23.64% 6.65% 6 2/Aug/10 -18.01% 6.98% -0.58% 3.93% 0.06% -12.38% -4.86% 7 1/Sep/10 9.19% 7.68% 2.40% 4.12% 1.65% 8.14% 8.39% 8 1/Oct/10 -0.05% 1.39% 6.20% -1.67% -0.49% 14.32% 3.62% 9 1/Nov/10 -0.27% -5.62% -1.74% -3.23% -1.25% 12.07% -0.23% 10 1/Dec/10 0.60% 7.18% 0.98% 4.09% 3.68% 5.17% 6.33% 11 3/Jan/11 8.19% 4.00% 5.03% 4.72% -1.54% -5.10% 2.24% 12 1/Feb/11 -4.63% 6.50% 8.22% -8.27% 7.04% -5.85% 3.15% 13 1/Mar/11 -6.09% 5.37% -3.98% 0.15% 0.79% -0.88% -0.10% 14 1/Apr/11 -1.46% 3.22% 3.45% -9.28% 5.90% 3.69% 2.81% 15 2/May/11 -7.70% 3.22% -7.47% 11.19% 0.24% -3.62% -1.36% 16 1/Jun/11 -2.34% -4.04% 1.07% -5.42% -2.98% -7.88% -1.84% 17 1/Jul/11 -3.42% -6.77% 2.58% -3.32% 0.83% -12.16% -2.17% 18 1/Aug/11 -30.09% -0.33% 4.46% -11.48% -1.86% -9.35% -5.85% 19 1/Sep/11 -14.25% -7.05% -3.67% -10.53% -2.10% -14.04% -7.45% 20 3/Oct/11 16.97% 8.53% -4.79% 9.30% 1.88% 18.95% 10.23% 21 1/Nov/11 4.92% 5.15% -1.70% -2.56% -8.89% -9.70% -0.51% 22 1/Dec/11 -7.72% 7.53% 5.52% 1.87% 2.84% 1.43% 0.85% 23 3/Jan/12 8.27% -1.11% 2.84% 11.19% -2.11% 14.76% 4.27% 24 1/Feb/12 -10.04% -0.24% 4.29% -0.11% 6.37% -0.33% 3.98% 25 1/Mar/12 -5.51% 6.91% -4.98% 0.54% 2.42% 0.82% 3.09% 26 2/Apr/12 3.83% 1.13% -1.45% 1.57% -5.87% -9.73% -0.75% 27 1/May/12 -8.81% -3.61% -3.19% -14.88% -2.75% -6.57% -6.47% 28 1/Jun/12 -11.41% 5.04% 2.98% 0.64% 1.12% -9.64% 3.88% 29 2/Jul/12 -9.77% 4.42% 4.65% 3.61% -3.35% -3.65% 1.25% 30 1/Aug/12 -7.77% 0.17% 3.75% -2.63% 6.86% 1.52% 1.96% 31 4/Sep/12 1.85% 4.06% 2.80% 4.52% 1.97% 5.45% 2.39% 32 1/Oct/12 -20.85% 0.08% -2.52% -2.44% 1.28% 12.89% -2.00% 33 1/Nov/12 -6.40% 1.49% 4.44% 0.47% 6.62% 2.57% 0.28% 34 3/Dec/12 10.19% 0.24% -0.97% -7.75% 0.70% 12.31% 0.70% 35 2/Jan/13 6.06% 3.45% 2.43% 1.86% 1.40% 4.68% 2.79% 36