helpppp

Calculate Betas using both methods: Method 1: Formula B, Excel function for sample variance: VAR.S Excel function for sample covariance: COVARIANCE.S R, is the monthly return of the companies you picked R is the monthly return of the S&P 500 Index Make sure you have the most recent 60 monthly return for both R, and R, Cov(R, R) Var(R) Method 2: Regression Model: R,-ARM + C + Data - Data Analysis Tools - Regression R, is the Y variable (dependent variable) and R is the independent variable (See in-class project for more details)