Use either finance.yahoo.com or Bloomberg and download five years of monthly closing prices for eight stocks and the S&P 500 Index (ticker symbol "GSPC"). Download the data into an Excel file and use the Adjusted-Close prices, which adjust for dividend payments, to calculate the monthly rate of return for each price series. Use an XY Scatter Plot chart with no line joining the points to plot each stock's returns against the S&P 500. Now for each scatter plot chart, select one of the data points, and right-click to obtain a shortcut menu allowing you to enter a trend line. This is the company's characteristic line, and the slope of the line is the company's beta. You can use the slope function In Excel to compute the slope of the line, which is beta. Compile the betas of each company in a table and provide copies of each company's characteristic line (scatter plot). Based on your results, how are your companies similar and different? Which companies are aggressive and which are defensive?