UPS

Solve problem 4 for ups

use FactSet

4. Determining the stock's Beta From Factset under charting get 3 -year monthly total returns for your firm and the S&P 500. See instruction on page 4. Download to an Excel Spread Organize your data from oldest to newest. On excel in the data tab choose data analysis. ( If you don't have it go to the office button, choose excel options on the bottom and then select add-ins --- manage add-ins and select Analysis ToolPak.) From Data analysis choose regression. Your dependent variable is your stock returns and the independent variable is the S&P returns. Select a 95% confidence level, residuals and residual plots. DO NOT USE the SLOPE function