calculating-betas

Choose any 5 stocks from Yahoo finance and collect the past 5-year monthly data. Then, calculate their betas based on S&P 500 market index by excel.