the beta coefficient, using S&P 500 Index as the benchmark;

A- Create excel sheet Using monthly stock price data from 2010-2017 for and its competitor 1) compute the mean, standard deviation, and coefficient of variance; and 2) graph the monthly stock prices. 3) compare the two firms which has the lowest standalone risk and best risk-to-return ratio. Source: Yahoo!Finance or Mergent Online. B- In separate excel sheet : 1) Compute the beta coefficient, using S&P 500 Index as the benchmark;