B E 34 3. Calculate Amazon's Beta using the Regression Tool 35 Return Data 36 37 Date S&P 500 Amazon.com 38 S&P 500 return Amazon return 1257.64 $ 180.00 39 1286.12 $ 169.64 2.26% -5.76% 40 1327.22 $ 173.29 3.20% 2.15% 41 1325.83 $ 180.13 -0.10% 3.95% 42 1363.61 $ 195.81 2.85% 8.70% 43 1345.20 $ 196.69 -1.35% 0.45% 44 1320.64 $ 204.49 -1.83% 3.97% 45 1292.28 $ 222.52 -2.15% 8.82% 46 1218.89 $ 215.23 -5.68% -3.28% 47 1131.42 $ 216.23 -7.18% 0.46% 48 1253.30 $ 213.51 10.77% -1.26% 49 1246.96 $ 192.29 -0.51% -9.94% Dec-10 Jan-11 Feb-11 Mar-11 Apr-11 May-11 Jun-11 Jul-11 Aug-11 Sep-11 Oct-11 Nov-11 Dec-11 Jan-12 Feb-12 Mar-12 Apr-12 May-12 Jun-12 Jul-12 Aug-12 Sep-12 Oct-12 Nov-12 50 1257.60 $ 173.10 0.85% -9.98% 51 1312.41 $ 194.44 4.36% 12.33% 52 1365.68 $ 179.69 4.06% -7.59% 53 1408.47 $ 202.51 3.13% 12.70% 54 1397.91 $ 231.90 -0.75% 14.51% 55 1310.33 $ 212.91 -6.27% -8.19% 56 1362.16 $ 228.35 3.96% 7.25% 57 1379.32 $ 233.30 1.26% 2.17% 58 1406.58 $ 248.27 1.98% 6.42% 59 1440.67 $ 254.32 2.42% 2.44% 60 1412.16 $ 232.89 -1.98% -8.43% 61 1416.18 $ 252.05 0.28% 8.23%