Date GOOG_Close_Price ALXN_Close_Price SNP_Close_Price

12/27/2016 $792.45 $122.35 $2,238.83

12/19/2016 $807.80 $127.19 $2,263.79

12/12/2016 $809.84 $120.04 $2,258.07

12/5/2016 $809.45 $132.07 $2,259.53

11/28/2016 $764.46 $122.96 $2,191.95

11/21/2016 $780.23 $118.83 $2,213.35

11/14/2016 $775.97 $119.85 $2,181.90

11/7/2016 $771.75 $113.62 $2,164.45

10/31/2016 $781.10 $129.00 $2,085.18

10/24/2016 $819.56 $135.59 $2,126.41

10/17/2016 $824.06 $120.26 $2,141.16

10/10/2016 $804.60 $118.34 $2,132.98

10/3/2016 $800.71 $125.05 $2,153.74

9/26/2016 $804.06 $122.54 $2,168.27

9/19/2016 $814.96 $127.22 $2,164.69

9/12/2016 $797.97 $131.46 $2,139.16

9/6/2016 $788.48 $124.92 $2,127.81

8/29/2016 $796.87 $123.67 $2,179.98

8/22/2016 $793.22 $129.63 $2,169.04

8/15/2016 $799.65 $132.14 $2,183.87

8/8/2016 $807.05 $133.44 $2,184.05

8/1/2016 $806.93 $137.11 $2,182.87

7/25/2016 $791.34 $128.60 $2,173.60

7/18/2016 $759.28 $125.80 $2,175.03

7/11/2016 $735.63 $125.58 $2,161.74

7/5/2016 $717.78 $124.42 $2,129.90

6/27/2016 $710.25 $118.59 $2,102.95

6/20/2016 $685.20 $112.99 $2,037.41

6/13/2016 $704.25 $125.20 $2,071.22

6/6/2016 $733.19 $135.61 $2,096.07

5/31/2016 $735.86 $153.89 $2,099.13

5/23/2016 $747.60 $150.42 $2,099.06

5/16/2016 $721.71 $142.52 $2,052.32

5/9/2016 $724.83 $139.74 $2,046.61

5/2/2016 $725.18 $140.99 $2,057.14

4/25/2016 $707.88 $139.28 $2,065.30

4/18/2016 $737.77 $159.10 $2,091.58

4/11/2016 $780.00 $153.09 $2,080.73

4/4/2016 $759.47 $148.89 $2,047.60

3/28/2016 $769.67 $142.94 $2,072.78

3/21/2016 $754.84 $133.19 $2,035.94

3/14/2016 $755.41 $128.45 $2,049.58

3/7/2016 $744.87 $139.27 $2,022.19

2/29/2016 $730.22 $144.46 $1,999.99

2/22/2016 $724.86 $140.16 $1,948.05

2/16/2016 $722.11 $145.89 $1,917.78

2/8/2016 $706.89 $141.11 $1,864.78

2/1/2016 $703.76 $142.28 $1,880.05

1/25/2016 $761.35 $145.93 $1,940.24

1/19/2016 $745.46 $159.15 $1,906.90

1/11/2016 $710.49 $158.68 $1,880.33

1/4/2016 $730.91 $168.13 $1,922.03

12/28/2015 $778.01 $190.75 $2,043.94

12/21/2015 $765.84 $189.41 $2,060.99

12/14/2015 $756.85 $182.13 $2,005.55

12/7/2015 $750.42 $188.06 $2,012.37

11/30/2015 $779.21 $175.76 $2,091.69

11/23/2015 $771.97 $182.46 $2,090.11

11/16/2015 $777.00 $173.59 $2,089.17

11/9/2015 $740.07 $166.44 $2,023.04

11/2/2015 $761.60 $172.15 $2,099.20

10/26/2015 $737.39 $176.00 $2,079.36

10/19/2015 $719.33 $171.16 $2,075.15

10/12/2015 $695.32 $160.72 $2,033.11

10/5/2015 $671.24 $161.08 $2,014.89

9/28/2015 $656.99 $166.07 $1,951.36

9/21/2015 $640.15 $149.25 $1,931.34

9/14/2015 $660.92 $166.58 $1,958.03

9/8/2015 $655.30 $171.93 $1,961.05

8/31/2015 $628.96 $171.98 $1,921.22

8/24/2015 $659.69 $178.86 $1,988.87

8/17/2015 $644.03 $173.81 $1,970.89

8/10/2015 $689.37 $186.58 $2,091.54

8/3/2015 $664.39 $189.62 $2,077.57

7/27/2015 $657.50 $197.44 $2,103.84

7/20/2015 $654.77 $200.99 $2,079.65

7/13/2015 $699.62 $204.30 $2,126.64

7/6/2015 $556.11 $192.53 $2,076.62

6/29/2015 $547.34 $185.22 $2,076.78

6/22/2015 $553.06 $184.45 $2,101.49

6/15/2015 $557.52 $184.40 $2,109.99

6/8/2015 $547.47 $169.04 $2,094.11

6/1/2015 $549.53 $160.26 $2,092.83

5/26/2015 $545.32 $163.84 $2,107.39

5/18/2015 $554.52 $171.94 $2,126.06

5/11/2015 $546.49 $160.56 $2,122.73

5/4/2015 $548.95 $163.02 $2,116.10

4/27/2015 $551.16 $172.50 $2,108.29

4/20/2015 $573.66 $180.08 $2,117.69

4/13/2015 $532.74 $181.34 $2,081.18

4/6/2015 $548.54 $182.68 $2,102.06

3/30/2015 $541.31 $169.94 $2,066.96

3/23/2015 $557.55 $180.59 $2,061.02

3/16/2015 $564.95 $187.71 $2,108.10

3/9/2015 $553.00 $176.89 $2,053.40

3/2/2015 $572.90 $181.65 $2,071.26

2/23/2015 $562.63 $180.37 $2,104.50

2/17/2015 $541.80 $186.02 $2,110.30

2/9/2015 $551.16 $182.29 $2,096.99

2/2/2015 $533.88 $175.63 $2,055.47

1/26/2015 $537.55 $183.24 $1,994.99

1/20/2015 $541.95 $183.32 $2,051.82

1/12/2015 $510.46 $180.44 $2,019.42

1/5/2015 $500.72 $184.27 $2,044.81

1/2/2015 $529.55 $186.60 $2,058.20

1. Calculate weekly returns.

a. You will first need to compute the weekly returns on both Google & Alexion

stocks and the S&P index. Use the following formula to calculate the % weekly

return of the two stocks and the S&P Market index.

(% weekly return =

100)

2. Correlation between weekly stock returns and market returns

a. What is the correlation between Google Stock returns and the market (S&P 500)

returns? Is the correlation significant? Provide statistical justification.

b. What is the correlation between ALXN Weekly returns and the market (S&P

500) returns? Is the correlation significant? Provide statistical justification.

3. Run Regression model to estimate the beta of each stock

a. A regression model to predict Google weekly stock returns based on S&P weekly

Stock returns.

i. What is the beta of Google? Interpret its meaning.

ii. Construct a 95% confidence interval estimate of Google's beta. Interpret

its meaning.

b. Run a regression model to predict ALXN weekly stock returns based on S&P

weekly Stock returns.

i. What is the beta of ALXN? Interpret its meaning.

ii. Construct a 95% confidence interval estimate of ALXN's beta. Interpret

its meaning.