Collect the weekly share price data

Calculate the average weekly returns and the standard deviation of the 2 companies and the index over the last year. Which of the companies has higher risk? Which factors specific to that company might explain the fact that the company has higher risk?

THE COMPANIES ARE :

EOG Resources, Inc.

Mylan N.V.

Question 3 (50 marks) a) Collect the weekly share price data (adjusted close) of companies assigned to you and the price data for the S&P500 market index for the period of one year. Calculate the weekly returns and graph the returns of the share prices and the index over the period (assume no dividends). Interpret the graph. (20 marks) (Hint: Download data from Yahoo. Finance and do the calculations in Excel file. Then copy & paste in word file.) b) Are there any market or industry specific factors that you think explain the share price movement of your companies over the period of one year? (10 marks) c) Calculate the average weekly returns and the standard deviation of the 2 companies and the index over the last year. Which of the companies has higher risk? Which factors specific to that company might explain the fact that the company has higher risk? (20 marks) (You need to do the procedure in excel and them to the word file) Question 3 (50 marks) a) Collect the weekly share price data (adjusted close) of companies assigned to you and the price data for the S&P500 market index for the period of one year. Calculate the weekly returns and graph the returns of the share prices and the index over the period (assume no dividends). Interpret the graph. (20 marks) (Hint: Download data from Yahoo. Finance and do the calculations in Excel file. Then copy & paste in word file.) b) Are there any market or industry specific factors that you think explain the share price movement of your companies over the period of one year? (10 marks) c) Calculate the average weekly returns and the standard deviation of the 2 companies and the index over the last year. Which of the companies has higher risk? Which factors specific to that company might explain the fact that the company has higher risk? (20 marks) (You need to do the procedure in excel and them to the word file)