Collect 61 months of the most recent historical data for your firms stock price and market data for the S&P500 total return index (^SP500TR) from Yahoo Finance. Use the historic data tab and collect monthly data. Import or copy and paste information into Excel.

Convert the collected 61 months of adjusted close price data to 60 months of return data for Starbucks and the S&P500 total return index.

Use an excel spreadsheet to graphically present the data with the S&P500 on the x-axis and Starbucks on the y-axis. Each months returns should therefore be represented by a single point on the graph. Calculate Starbucks beta using both a trendline technique and a regression. Be sure to show the trendline equation on the graph. Both methods should give you the same beta.