FOR VODAFONE COMPANY

Find the recent 60 month return. Compute the average return and then standard deviation for each year. For the same years find average and standard deviation of S&P index. Create two line graphs: one for average return (put year on x-axis and average return of the company and S&P on y-axis) and one for standard deviation (put year on x-axis and standard deviation of the company and S&P on y-axis). In both graphs interpret best and worst years.  

Go to finance.yahoo.com and find “Historical Data”. Use the prices that appear in the last column (adjusted for dividend payments and stock splits) to compute return. Next, download S&P 500 index over the same period (Search for S&P 500 on finance.yahoo.com and then go to historical data) then compute return using the prices in the last column.